Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy from different workbook's worksheet into a single worksheet...
Hello,
Can somebody help to to do the followings: i) We have offices in sixty-two countries. We send them an excel form with five or six sheets for next year budgets. I would like to know how to get all the data in a single workbook when I will get all the files from the countries? Now I am opening each file and copying and pasting them in a single sheet. Is there any way to make this work a bit easier. ii) Another question would be, there are account number in three columns(for example - 1st column - 1000, 2nd column - 1200 and 3rd column has - 500. What I have do get all the account number rows would be like this 1000-1200-500. I need this format for that particular row because I need to export this format to our system. Please help Thanks John |
#2
|
|||
|
|||
Copy from different workbook's worksheet into a single worksheet...
Hi John
See http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.com... Hello, Can somebody help to to do the followings: i) We have offices in sixty-two countries. We send them an excel form with five or six sheets for next year budgets. I would like to know how to get all the data in a single workbook when I will get all the files from the countries? Now I am opening each file and copying and pasting them in a single sheet. Is there any way to make this work a bit easier. ii) Another question would be, there are account number in three columns(for example - 1st column - 1000, 2nd column - 1200 and 3rd column has - 500. What I have do get all the account number rows would be like this 1000-1200-500. I need this format for that particular row because I need to export this format to our system. Please help Thanks John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple Copy from Worksheet to Worksheet | Excel Worksheet Functions | |||
Automate worksheet copy | Excel Discussion (Misc queries) | |||
macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
copy link from next worksheet | Excel Worksheet Functions | |||
How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) |