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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
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

On 12 Jun., 20:07, "Ron de Bruin" wrote:
Why not use amacro?

When you want your data to refresh simple run themacroagain an it is up to date

Seehttp://www.rondebruin.nl/copy2.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



wrote in oglegroups.com...
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 haveseveralsheets inoneExcel workbook (with identical column
names and content). Now I would like to have a consolidated sheet with
all content of the other sheetsWITHOUTusing aVBAMACRO.

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
newlines inoneof theworksheetsare automatically added to the
consolidated sheet.

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

Thanks in advance,
Best regards, jan- Zitierten Text ausblenden -

- Zitierten Text anzeigen -