Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Worksheets with Different Number of Entries
Hi Everyone-
I've got a workbook with some 40 worksheets containing macroeconomic data for a number of countries. The problem is that some worksheets have data on a certain number of countries, while others have more or less. What is the easist way to populate one worksheet with all of the data (where missing info for certain fields would be left blank)? Let me know your thoughts, thanks! Alex |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging Worksheets with Different Number of Entries
Clarification Example
Worksheet 1: Italy 30,000 Germany 25,000 France 28,093 Worksheet 2: Italy 4.5 Germany 6.8 Worksheet 3: Italy 344 France 223 Spain 112 I want to simply create Worksheet 4: Italy 30,000 4.5 344 Germany 25,000 6.8 - France 28,093 - 223 Spain - - 112 This is obviously a simplification. The workbook contains a couple hundred countries.. Thanks again Alex wrote: Hi Everyone- I've got a workbook with some 40 worksheets containing macroeconomic data for a number of countries. The problem is that some worksheets have data on a certain number of countries, while others have more or less. What is the easist way to populate one worksheet with all of the data (where missing info for certain fields would be left blank)? Let me know your thoughts, thanks! Alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command to count number of worksheets in a workbook? | Excel Worksheet Functions | |||
Max number of worksheets in a file | New Users to Excel | |||
Checking for duplicate entries over multiple worksheets | Excel Discussion (Misc queries) | |||
How can I use dcount to total the number of columns with entries? | Excel Worksheet Functions | |||
TOTAL NUMBER OF ENTRIES | Excel Worksheet Functions |