Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from one tab to another based on cell value on one tab
I have a spreadsheet where each tab represents 1 week. the tabs are named
based on the week ending date that tab covers - "June 25", "July 2", etc. There is a master tab named "Invoice" with the period ending date residing in cell C10. Is there a way I can have a macro go to the appropriate tab based on the date entered in C10 on the "Invoice" tab? I need the macro to copy over specific information, which I can do, but I wanted the macro to automatically look at the value in C10 on "Invoice", then go get the information from the appropriate tab that corrosponds to that cell value. Anyone have any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell data from workbook based on user input | Excel Programming | |||
Copy data in column based on cell value | Excel Programming | |||
Copy data in column based on cell value | Excel Programming | |||
Copy data in column based on cell value | Excel Programming | |||
Macro to copy cell data to word document based on an active row? | Excel Programming |