#1
|
|||
|
|||
how to automatically copy parts of a record to another sheet?
I am working on a sales commission spreadsheet and am looking for a way to enter a record of a customer/sale on a line on 1 sheet (ex: May sales) and upon a trigger (entering a value in a cell when the job is closed) have the customer record (or better yet selected cells or fields from the record) copied to a line on a second sheet (ex: May closed jobs) where commissions would be calculated based in part on the date the job was closed. There are incremental commissions paid depending on the cumulative sales closed in the month so the copied records would need to populate the second sheet in chronological order upon being "triggered". Hope this makes sense, any ideas? Of course i could manually copy them at the correct time but would like something where the closed date is entered ahead of time with the original record on sheet 1 and upon entering a trigger (confirming the job is in fact closed) it auto populates sheet 2.
|
#2
|
|||
|
|||
Hi
This is relatively straightforward to do with VBA however we would need to see a sample to build the vba for you. If you can post a sample of gthe before and after and details of the trigger you wish to use then I can take a look for you. Tony |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to copy data automatically to particular sheet? | nicholes | Excel Programming | 13 | 03-12-2014 01:05 AM |
Find Results in excel copy the rows to another sheet | khalidfazeli | Excel | 2 | 02-06-2013 09:38 AM |
How to Copy data from Outlook mail and Paste it in a Excel sheet? | padhu1989 | Outlook | 0 | 09-11-2012 04:07 AM |
avoid duplicete record and merge the record with the existed record | hemant.behere | Excel | 0 | 01-10-2012 02:53 AM |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |