C
Carl Brehm
sheet1
Column A contains a list of dates. Formatted 18-Jan-2005
Column B a list of values Formatted as dollars
Sheet2
In column a Starting at a2 there is a list of weekending dates, Formatted 18-Jan-2005
The week ends on Saturday's
IN b1 through h1 there is a list of days starting at Sunday
What I need is to extract the Sunday amounts for the weekending date from
Column B based on the date in column a.
Ie. If Sunday is the heading what was the amount on sheet1 Column b that
was on Sunday for the weekending date.
Thanks In advance.
--
Carl & Linda Brehm
Lake Lafourche Bird House
Hebert, LA
Keets, Tiels, GN Lories, Quakers
Mitred Conures, TAG's, Bourkes
Lovebirds, Cherry Head Conures
Prince of Whales
Wholesale Cages to Breeders & Pet Stores
Column A contains a list of dates. Formatted 18-Jan-2005
Column B a list of values Formatted as dollars
Sheet2
In column a Starting at a2 there is a list of weekending dates, Formatted 18-Jan-2005
The week ends on Saturday's
IN b1 through h1 there is a list of days starting at Sunday
What I need is to extract the Sunday amounts for the weekending date from
Column B based on the date in column a.
Ie. If Sunday is the heading what was the amount on sheet1 Column b that
was on Sunday for the weekending date.
Thanks In advance.
--
Carl & Linda Brehm
Lake Lafourche Bird House
Hebert, LA
Keets, Tiels, GN Lories, Quakers
Mitred Conures, TAG's, Bourkes
Lovebirds, Cherry Head Conures
Prince of Whales
Wholesale Cages to Breeders & Pet Stores