Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-09-2015, 09:27 AM
zain_shaikh zain_shaikh is offline Copy data from certain Cells in new sheet Windows 7 32bit Copy data from certain Cells in new sheet Office 2007
Novice
Copy data from certain Cells in new sheet
 
Join Date: Feb 2015
Posts: 1
zain_shaikh is on a distinguished road
Post 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.
Reply With Quote
  #2  
Old 02-11-2015, 07:35 PM
excelledsoftware excelledsoftware is offline Copy data from certain Cells in new sheet Windows 7 64bit Copy data from certain Cells in new sheet Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft