Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate data with text
Excel Consolidate Data does not consolidate text. I need to somehow combine
data from several different worksheets into one (the sheets contain text and numbers). The tables on each sheet are set up identically with identical column headers. Ideally, I would like to import worksheet #1, then beginning on the first blank row after worksheet #1, import (or copy and paste) worksheet #2, etc to form one combined database. Ideas, please? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate data with text
I should have mentioned these worksheets are in different workbooks.
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidate data with text
Ron de Bruin has tons of code samples for combining data he
http://www.rondebruin.nl/tips.htm John wrote: Excel Consolidate Data does not consolidate text. I need to somehow combine data from several different worksheets into one (the sheets contain text and numbers). The tables on each sheet are set up identically with identical column headers. Ideally, I would like to import worksheet #1, then beginning on the first blank row after worksheet #1, import (or copy and paste) worksheet #2, etc to form one combined database. Ideas, please? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidate Data & Text | Excel Discussion (Misc queries) | |||
Consolidate text | Excel Programming | |||
Can't consolidate non-data (ie text) cells from worksheets | Excel Worksheet Functions | |||
How do you consolidate tables contianing text? | Excel Worksheet Functions | |||
Consolidate text | Excel Discussion (Misc queries) |