Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-27-2014, 12:42 AM
kmeechan kmeechan is offline how to automatically copy parts of a record to another sheet? Windows 8 how to automatically copy parts of a record to another sheet? Office 2010 32bit
Novice
how to automatically copy parts of a record to another sheet?
 
Join Date: May 2014
Posts: 1
kmeechan is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 05-28-2014, 02:24 AM
OTPM OTPM is offline how to automatically copy parts of a record to another sheet? Windows 7 32bit how to automatically copy parts of a record to another sheet? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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

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
how to automatically copy parts of a record to another sheet? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:22 AM.


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