Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 03-09-2014, 08:17 AM
nicholes nicholes is offline How to copy data automatically to particular sheet? Windows XP How to copy data automatically to particular sheet? Office 2007
Novice
How to copy data automatically to particular sheet?
 
Join Date: Apr 2012
Posts: 21
nicholes is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post

To add the macro to your workbook's 'main' sheet code module, press Alt-F11 to start the VB Editor, double-click on the 'Sheet1(main)' entry on the left, then paste the code from my post into it. Oh, and fix up the spelling errors (e.g. 'Customer A', not 'cutomaer A')!

PS: Please don't quote the entire post responded to in your replies; if something needs to be quoted, quote only that part.
1. I have renamed the sheet Customer A.

2. Thanks for the opinion, i would now quote only important things.


Now since i am doing this for the first time, this easy job looks a bit hard for me
here is what i did>>>>>>


I copied your code, and in my workbook perss alt+ F11(it opened VB editor) i dubble click on sheet one(main) and paste your code there .

after that i go to "file" Tab and choose> "Close and return to Microsoft Excel"(alt+Q)

i dont see any changes in my workbook.nor i see any saved micro to run

what to do now?

i know i am not doing it in a right way.please help me
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Copy data from Outlook mail and Paste it in a Excel sheet? padhu1989 Outlook 0 09-11-2012 04:07 AM
sheet 2 data highlight in sheet 1 gsrikanth Excel 1 04-21-2012 06:25 PM
How to copy data automatically to particular sheet? How to copy automatically data from Excel file to Word file? fuchsd Word 6 10-25-2011 05:52 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
copy cell from sheet 2 to sheet 3 macro slipperyjim Excel Programming 1 02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:02 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