Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Run Macro when Cell Input changes
Grumpy_Old_Duffer
Posts: 689
Forumite
in Techie Stuff
I have a Module macro called 'Sub Copy_Paste() and I want this to automatically operate everytime there is a new input made in any cell in the range Q5:U27 on a worksheet called "Updates", which I have given a named range to of "DataChanges".
What 'Private Sub' code do I need for the "Updates" Worksheet 'Module'?
What 'Private Sub' code do I need for the "Updates" Worksheet 'Module'?
It has taken about 4,500,000,000 (4.5 billion) years for the Earth to form as it is now .........
and it'll only take about another 100 years for mankind to really **** it up!!!!
and it'll only take about another 100 years for mankind to really **** it up!!!!
0
Comments
-
This should do it. Copy and paste the following code into the Worksheet_Change event of your Updates sheet:
If Not Application.Intersect(Target, Range("DataChanges")) Is Nothing Then
Copy_Paste
End If0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.5K Work, Benefits & Business
- 606.2K Mortgages, Homes & Bills
- 179.1K Life & Family
- 264K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards