Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 07:26 PM.


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