Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put several sheet into one sheet.
We have budgets in many sheet. I wish to put all data into one sheet so that
i can use information as a database. With headder coloums. Does anybody kwow how to easily do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put several sheet into one sheet.
Hi Frode
Sheets or workbooks ? I have code for both on my site -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Frode Hjartøy" wrote in message ... We have budgets in many sheet. I wish to put all data into one sheet so that i can use information as a database. With headder coloums. Does anybody kwow how to easily do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put several sheet into one sheet.
Dear Ron de Bruin
This is about sheet in one xls. file. In sheet "Management" I have an area F1:J100 In sheet "IT" I have an area F1:J100 In sheet "customer service" I have an area F1:J100 55 sheet And so on. I wish to create a "new sheet" in the same workbook were I Copy from management into "new sheet" F1:F100 IT into "new sheet" F101:F200 An so on. Best regards frode "Ron de Bruin" wrote: Hi Frode Sheets or workbooks ? I have code for both on my site -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Frode Hjartøy" wrote in message ... We have budgets in many sheet. I wish to put all data into one sheet so that i can use information as a database. With headder coloums. Does anybody kwow how to easily do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put several sheet into one sheet.
Try this one
http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Frode Hjartøy" wrote in message ... Dear Ron de Bruin This is about sheet in one xls. file. In sheet "Management" I have an area F1:J100 In sheet "IT" I have an area F1:J100 In sheet "customer service" I have an area F1:J100 55 sheet And so on. I wish to create a "new sheet" in the same workbook were I Copy from management into "new sheet" F1:F100 IT into "new sheet" F101:F200 An so on. Best regards frode "Ron de Bruin" wrote: Hi Frode Sheets or workbooks ? I have code for both on my site -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Frode Hjartøy" wrote in message ... We have budgets in many sheet. I wish to put all data into one sheet so that i can use information as a database. With headder coloums. Does anybody kwow how to easily do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |