| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
transfering data
I need to transfer data from one sheet to another every week. The first sheet will contain a roster and the second sheet will contain the values/totals of the roster from throughtout the year. Is it possible to make a formula that will lookup the cell "week number" from the roster sheet (that changes every week) and pastes the data under the cell that contains the name week number in the datasheet (the sheet that contains the data from previos weeks. Therefore, it will copy from the current sheet and store them after each other in a different sheet. Please help, Thanks, Chris -- pisanichris ------------------------------------------------------------------------ pisanichris's Profile: http://www.excelforum.com/member.php...o&userid=28138 View this thread: http://www.excelforum.com/showthread...hreadid=476531 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| transfering data between sheets | Excel Discussion (Misc queries) | |||
| transfering data in another column entering more sorted data | Excel Worksheet Functions | |||
| Transfering data across worksheets | Excel Discussion (Misc queries) | |||
| Transfering data from 1 worksheet to another | Excel Discussion (Misc queries) | |||
| Transfering dynamic data | Excel Programming | |||
![pisanichris[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
