Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use button on sheet to transfer data based on todays date
I have data on sheet1 that I'd like to transfer to sheet2. The destination
cells are the same but the referenced cells will change depending on what month we are currently in. Here is what I need. I want to use a command button on sheet 2 to do this. Please Help! If more explanation is necessary I will be more than happy to clarify. Detination cell sheet2 G9 is today is in Jan05 sheet1 a38 Feb05 sheet1 b38 mar05 sheet1 c38 apr05 sheet1 d38 ....until dec jan06 sheet1 a74 feb06 sheet1 b74 ....until dec jan07 sheet1 a110 feb07 sheet1 b110 .....until dec jan08 sheet1 a146 feb08 sheet1 b146 ....until dec |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graphing data based on todays date | Excel Discussion (Misc queries) | |||
turn a cel a color based o todays date | Excel Worksheet Functions | |||
Autofill cell based on todays date | Excel Worksheet Functions | |||
Transfer only information under todays date | Excel Worksheet Functions | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) |