|
How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS
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 |
How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS
Why not use a macro ?
When you want your data to refresh simple run the macro again an it is up to date See http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ups.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 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 |
How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS
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 - |
How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS
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 - |
How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS
Hi Ron,
thanks again. So far Max has not shown up in this thread.... unfortunately.... :-( rgds, jan On 12 Jun., 21:25, "Ron de Bruin" wrote: 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 themergesheet 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 Bruinhttp://www.rondebruin.nl/tips.htm wrote in ooglegroups.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 exampleExcelfile I can provide youone. Thanks in advance, Best regards, jan- Zitierten Text ausblenden - - Zitierten Text anzeigen -- Zitierten Text ausblenden - - Zitierten Text anzeigen - |
How to merge / combine several worksheets into one new workshe
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? "Ron de Bruin" wrote: 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 - |
How to merge / combine several worksheets into one new workshe
I said 26 sheets in one file but I meant in one Workbook.
"me04984" wrote: 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? "Ron de Bruin" wrote: 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 - |
How to merge / combine several worksheets into one new workshe
Start with the add-in
http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "me04984" wrote in message ... I said 26 sheets in one file but I meant in one Workbook. "me04984" wrote: 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? "Ron de Bruin" wrote: 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 - |
How to merge / combine several worksheets into one new workshe
How about if they are in separate workbooks?
"Ron de Bruin" wrote: Start with the add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "me04984" wrote in message ... I said 26 sheets in one file but I meant in one Workbook. "me04984" wrote: 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? "Ron de Bruin" wrote: 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 - |
How to merge / combine several worksheets into one new workshe
The add-in is for separate workbooks and you can choose all sheets from each workbook
See also the code examples (copy a range from each workbook) http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "me04984" wrote in message ... How about if they are in separate workbooks? "Ron de Bruin" wrote: Start with the add-in http://www.rondebruin.nl/merge.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "me04984" wrote in message ... I said 26 sheets in one file but I meant in one Workbook. "me04984" wrote: 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? "Ron de Bruin" wrote: 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 - |
| All times are GMT +1. The time now is 02:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com