Combining sheets with variable layout

  • Thread starter Thread starter glyn
  • Start date Start date
G

glyn

Hi I imagine this must of come up before and there must be a solution
that already exists somewhere.

I regularly receive multiple workbooks or workbooks with multiple
sheets that need to be combined to one file to produce a list of
addresses etc.

curently I manually sort them to a standard layout and have VB scripts
of my own that will then combine either the books or the sheets
(mainly books).

I would love to have a soloution that will automatically combine these
sheets into one file removing the human error factor of getting one or
more out of sequence.

Points to note:

The data layout can change and may or may not include the same number
of fields/columns

I would rename the header in each book/sheet to be consistant (only
way i can see something working)

so in summary what i need is something that will arrange the books/
sheets into the same order and i can then combine them with the code I
already have.

Or something that will arrange and combine them.

I could simply do this with access by importing each file into a
standard table but it runs the risk of missing or duplicating a file.

Any info on a solution that exists or where to start programming one
would be of great help
 
Hi

I have a lot of examples on my site
See if something is working for you

Maybe you can use the merge add-in ?
See the "Copy/Paste/Merge examples" section
 
Hi Ron,

Great site

Had a quick play with the merge addin, fantastic addin however it does
not account for the fact that the data layout can be different in the
files I have eg

file 1
column A - Name
column B - Address
column C - Telephone

File 2
column A - Address
column B - Name
column C - Telephone

I need to shuffle all the data to be in the same layout this is the
crux of whats stumping me at the moment.

Glyn
 
No one any ideas on the simplest way to shuffle data on different
sheets or books to the same layout?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine multiple sheets within workbook 1
Combining Multilple Worksheets Into One 6
combine sheets from several workbooks into one 1
password protect individual sheets 1
Open multiple workbook then combine into single workbook butdifferent sheets 10
Combine columns from seperate sheets into new sheet- macro improve 4
How to combine amount in manys sheets into 1 summary sheets 2
COMBINING WORKBOOKS 1

Back
Top