#1
|
|||
|
|||
Copy data from certain Cells in new sheet
Hello Friends,
I need some help regarding copying data from certain cells in multiple worksheets into one worksheet in a categorized format. Basically I am looking for a VBA code or any other workaround if possible to help ease my task a bit. I have lets say 10 worksheets each containing invoices. The worksheets are renamed according to invoice number like (3001, 3002, 3003). Cell B2 contains the invoice date, B3 contains product code, B4 contains name of the client, E3 contains warehouse number, H2 contains account number & H3 contains warranty date. I want to have an 11th sheet which should hold all information in following sequence: H3 in A2 (of the 11th sheet) B3 into B2 B4 in C2 C2 in D2 B3 in E2 E3 in F2 I need a VBA code which goes through all worksheets, collect data & paste in new worksheet row wise. I addition i want to have title of my company in cell A1 of the 11th sheet. I have tried some codes from different websites but could not get it to work. Help would be highly appreciated as I am a complete newbie to advance programming stuff. |
#2
|
|||
|
|||
This can be done pretty easily but because there are so many worksheets and they have a different names we would need a sample workbook posted. I am a little confused at to why the data would fluctuate when you say E3 to F2 and C2 to D2 I would figure it would all be the same row and then that would go to a result row and then continue till the worksheet was analyzed. After that it would go to the next worksheet.
Please post a sample workbook and I should be able to get this coded for you soon. Thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Want to change Macro to copy and paste data to new sheet | Vortex69 | Excel Programming | 0 | 12-23-2014 09:53 PM |
How to copy all data from a website to excel sheet? Plz plz plz plz plz help...urgent | Sam123 | Excel | 0 | 07-19-2014 02:12 AM |
How to copy data automatically to particular sheet? | nicholes | Excel Programming | 13 | 03-12-2014 01:05 AM |
How to Copy data from Outlook mail and Paste it in a Excel sheet? | padhu1989 | Outlook | 0 | 09-11-2012 04:07 AM |
If two geographical data match in two sheets, copy unique id/code found in one sheet | alliage | Excel | 1 | 09-01-2011 05:23 AM |