Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merge information from different sheets in to 1 | Excel Discussion (Misc queries) | |||
How do you merge the sheets in two files? | Excel Discussion (Misc queries) | |||
merge sheets | Excel Discussion (Misc queries) | |||
merge data from many sheets to one | Excel Worksheet Functions | |||
Merge two sheets | Excel Discussion (Misc queries) |