Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
collect data from one excel sheet to another
I have one main workbook with a whole lot of onfo in it and when i open the
otehr workbooks then they must gather certain information from the main workbook. I have this partially worked out in the following: =IF('[MAIN TIMESHEET.xls]October'!$F5="BWC",'[MAIN TIMESHEET.xls]October'!$B5:$I5,$B$79) However, it is basically copying the info line by line and inserting it into the other workbook on the same row number as where it got the info from. How can i change this so that the workbook will add in the info starting from the first row and follow through to the second, third and fourth row instead of basically just doing a "copy and Paste" scenario. Please help I am Desperate for an answer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
collect data from one excel sheet to another | Excel Discussion (Misc queries) | |||
use a worksheet as a form to collect data | Excel Worksheet Functions | |||
Collect data of several sheets on another book's singel sheet | Excel Discussion (Misc queries) | |||
How to collect data from every 60th row? | Excel Discussion (Misc queries) | |||
collect data from different worksheet | Excel Worksheet Functions |