How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS

J

jan.patrzalek

Hi,
I've got a huge problem.
I surfed now thru various forums but I unfortunately did not find an
answer.

Here a description:
I have several sheets in one Excel workbook (with identical column
names and content). Now I would like to have a consolidated sheet with
all content of the other sheets WITHOUT using a VBA MACRO.

I am looking for a formula/ formulas which helps me to have a
consolidated always up-to-date sheet including all content rows from
all other sheets. The main problem I have is how to ensure that added
new lines in one of the worksheets are automatically added to the
consolidated sheet.

If you need an example Excel file I can provide you one.

Thanks in advance,
Best regards, jan
 
J

jan.patrzalek

Hi Ron,
thanks for the quick answer.

The problem is that I have to run a macro everytime and I do want to
have up-to-date data at every time and not only after running the
macro.

A solution without macro must exist!

thx, jan
 
R

Ron de Bruin

It exist but you need so many formulas.
It will make your workbook slow and big.

You can also use the same sheet for merging and run the macro in the activate event of the sheet.
This way when you go to the merge sheet the data is up to date

I believe Max have a example for you with formulas.
I hope he reply in this thread for you
 
J

jan.patrzalek

Hi Ron,
thanks again. So far Max has not shown up in this thread....
unfortunately.... :-(
rgds, jan
 
M

me04984

My situation is similar. I have 26 sheets in one Excel file and would iike to
merge some of the columns, but not all. i don't know how to use a macro but
would be willing to learn if it would make it easy to merge those sheets.
They all have the same columns and are names, addresses, phone, etc.

Then as I update, is there a way to keep the changes identified so I could
have a file just for them to accompany my printed copy?
 

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

New computer, how do i move outlook 365 ENTIRELY? 0
VBA for Dependents shortcut menu 0
Combine sheets into one 4
Group information from several worksheets into one worksheet 1
Combine several spreadsheets with multiple worksheets into 1 file 5
Excel Macro help to merge multiple files 0
How to I combine excel worksheets? 5
move worksheet to end of another workbook 7

Top