ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to combine several tabs on a spreadsheet into a summary tab w. (https://www.excelbanter.com/excel-discussion-misc-queries/1256-how-combine-several-tabs-spreadsheet-into-summary-tab-w.html)

adeeb

how to combine several tabs on a spreadsheet into a summary tab w.
 
I have a spreadsheet with several tabs containing contact information by city
( each tab represent a city) I now would like to combine them into a summary
Tab containing all the information.

Myrna Larson

Copy and paste, perhaps?

On Sat, 4 Dec 2004 19:15:03 -0800, "adeeb"
wrote:

I have a spreadsheet with several tabs containing contact information by city
( each tab represent a city) I now would like to combine them into a summary
Tab containing all the information.



Ron de Bruin

Hi adeeb

Here is a macro solution
http://www.rondebruin.nl/copy2.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"adeeb" wrote in message ...
I have a spreadsheet with several tabs containing contact information by city
( each tab represent a city) I now would like to combine them into a summary
Tab containing all the information.





All times are GMT +1. The time now is 05:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com