Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying (variable) rows from another spreadsheet
Hallo,
I want to copy data from other spreadsheets, which get updated daily, and the issue I have is that these rows change say from 6 rows to 12 rows etc.). Ideally I want to copy the data from different spreadsheets into one master worksheet so that say I download 6 rows from one spreadsheet, then I have a one row gap, underneath the next, say, 8 rows of data from another spreadsheet get downloaded, one row gap etc. How can I implement this ideally? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying (variable) rows from another spreadsheet
You say you have worksheets that get updated daily and then you put the data
into a master sheet. 1) Do you want to clar the master sheet every day and then re-generated the Master Sheet? Or do you want to add the new info to the Master sheet. How can you tell what gets changed on a daily bases. 2) Is the Name of your Master Sheet "Master"? 3) Does you sheets have header rows? I assume the Master Sheet have the same header rows as the other sheets and you want to add the header rows only once to the master sheet. "Tommy" wrote: Hallo, I want to copy data from other spreadsheets, which get updated daily, and the issue I have is that these rows change say from 6 rows to 12 rows etc.). Ideally I want to copy the data from different spreadsheets into one master worksheet so that say I download 6 rows from one spreadsheet, then I have a one row gap, underneath the next, say, 8 rows of data from another spreadsheet get downloaded, one row gap etc. How can I implement this ideally? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable data from one spreadsheet sent to new spreadsheet | New Users to Excel | |||
Macro for copying a value to a variable no. of rows | Excel Discussion (Misc queries) | |||
Conitional copying of a serie of rows from one spreadsheet to another | Excel Worksheet Functions | |||
Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
Copying range to variable number of rows | Excel Programming |