G
Guest
I have two sheets... Cdata & summary
Cdata has fields like
A1: Apr 05
A2: May05
A3: June 05
and so on
Summary sheet. A20. currentregion keep changing at click of option boxes.
but
The formula needs to lookup a20.region
If first row contains 04/05 as heading
then copy last cell in that row ( grand total at bottom row)
and paste into Cdta in Apr 05
and so with 05/05, etc
also, if data is not found... in sumamry sheet then value in cdata should be
cleared
blank
Is it possible by vlookup or macro?
vlookup would be ideal as a chart picks up data from the cdata sheet
Cdata has fields like
A1: Apr 05
A2: May05
A3: June 05
and so on
Summary sheet. A20. currentregion keep changing at click of option boxes.
but
The formula needs to lookup a20.region
If first row contains 04/05 as heading
then copy last cell in that row ( grand total at bottom row)
and paste into Cdta in Apr 05
and so with 05/05, etc
also, if data is not found... in sumamry sheet then value in cdata should be
cleared
blank
Is it possible by vlookup or macro?
vlookup would be ideal as a chart picks up data from the cdata sheet