#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Merge wk sheets

Tnks for the replies.
Well, I have about 10 worksheets like HH1, HH2, WEd1 & so on. I too have a
quite a lot of data in these wk sheets. The solusion you all suggested will
do the job but its a long way. Is there another way of transfering data to a
main sheet where you have all data you will find on these sheets.
Eg.
Sheet HH1
Column A Column B Column C Column D
Ref Description Amount Contra
charge to
contra/newy/1 repair elec switch £35 J&H
Contra/newy/2 fit DP switch £100 JBS

Sheets HH2
Contra/starrant/1 fit bath £150 Newy
Contra/Starrant/2 repair tap £90 J&H

Now I have 16 shhets like HH1, HH2 at the moment, but can grow up to 20.
I would like to craete a wk sheet (summary all trades) where I have all the
date from wk sheets HH1, HH2 and so on.
I would then like to summarise data in "Summary all Trade" wk sheet
according to the contra charge to column.
I would like to do this with out referencing as its a long way.
tnks.
Sanj.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge information from different sheets in to 1 Fiona Excel Discussion (Misc queries) 2 January 22nd 07 06:42 PM
How do you merge the sheets in two files? Kim Excel Discussion (Misc queries) 2 October 28th 06 02:39 PM
merge sheets lache Excel Discussion (Misc queries) 1 March 31st 06 04:38 PM
merge data from many sheets to one jb Excel Worksheet Functions 1 March 20th 06 07:14 PM
Merge two sheets BPR Excel Discussion (Misc queries) 1 March 16th 06 03:36 PM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"