View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tod[_2_] Tod[_2_] is offline
external usenet poster
 
Posts: 1
Default value of a cell based upon column letter and variable for row#

Please forgive the dumb question....
A user enters daily data into a worksheet. I need to create a macro that
inserts the daily values from that worksheet into a different worksheet based
upon the value of a variable. The values from the daily worksheet are from 3
or 4 columns and about 20 rows. They will all need to placed into cells in
one row on the other worksheet. For example...

If variable equals 2
Daily Worksheet -- Monthly Worksheet
A1 -- B2
A9 -- C2
D15 -- D2
C30 -- E2

I am completely lost. Please help!

TIA,
Tod