How to copy data automatically to particular sheet?

macropod · #6 03-09-2014, 02:10 PM

Quote:

Originally Posted by nicholes

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

what to do now?

Now you enter some data on a new row the main sheet. As soon as columns A to D or F to I are completed, the data for that row will be copied to the Customer A or Customer B sheet.

The macro doesn't change any existing data. If you need to transfer the existing data, I'd suggest sorting columns A to D by customer name, transferring their data to the Customer A & Customer B sheets, then doing the same for columns F to I. You can re-sort columns A to D & F to I by date afterwards.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 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