How to track over data that is over written every time the file is used.

DMPMO

New Member
Joined
Mar 15, 2016
Messages
21
This post is really to ask for a good suggestion on how to accomplish this task.

I have made a Template in excel that calculates sales opportunities. The first few columns data is directly imported from the amount of new business sales. The last few columns is where the formulas are stored and simply does % of things like how much was sold and how much sales opportunity exists within the new business. Since the data is imported every time it is used those percentages change over time.


What I am attempting is to find a way to make a independent column where those percentages is tracked over time that is automatically updated when the data is imported. I am aware this can be done by manually entering the date and percentage every time. Can this be done without using VBA?
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

mrmmickle1

Well-known Member
Joined
May 11, 2012
Messages
2,461
You can use a worksheet change event to accomplish your task. For example when a user pastes data into the file it would trigger a macro that does X task (The action that you describe above). Here is some sample code (Needs to be pasted in a worksheet module):

Code:
[COLOR=#0000ff]Private Sub[/COLOR] Worksheet_Change([COLOR=#0000ff]ByVal[/COLOR] Target [COLOR=#0000ff]As[/COLOR] Range)
    MsgBox "I just changed something on the worksheet"
[COLOR=#0000ff]End Sub[/COLOR]
 

Forum statistics

Threads
1,141,483
Messages
5,706,649
Members
421,460
Latest member
Taamrak

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top