| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying cell info from one worksheet to another based on a specific date
Is this possible?
I have 2 worksheets in an excel file. Sheet 2 updates everyday and is fed from an input schedule. Every quarter end i would like to copy that days info into Sheet 1. So for example, all through jan, feb and march information is being fed into Sheet 2. However, on MARCH 31 I would like to take the information shown in Sheet 2 and paste that info into Sheet 1 (pretty much taking a snapshot of that quarters data). Once April 1st hits, Sheet 2 goes about its business collecting data thats being fed and Sheet 1 retains the info it took on March 31. The idea is at the end of every quarter Sheet 1 populates info copied and pasted from Sheet 2....... Can anyone help me??? Cheers. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating a cell based on a specific date/combo | Excel Worksheet Functions | |||
| Copying rows from 2 sheets to a new worksheet based on date criter | Excel Discussion (Misc queries) | |||
| formula for specific dates based on another date in worksheet | Excel Discussion (Misc queries) | |||
| Want info in a specific cell to reflect in another worksheet.. | New Users to Excel | |||
| Copying block (range of cells) based on a value of a specific cell-VBA | Excel Programming | |||
Threaded Mode
