Delete Entry & Replace w/ Formula

M

MarkReddell

Board Regular
Joined
Sep 1, 2011
Messages
210
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
I have mny rows in a Col. I need 2 b able 2 use the cells with a formula & b able 2 make manual entries. But, after I make a manual entry that I'm finished with; I wan 2 b able 2 restore the cell/cells back with the formula upon the deleting of the manual entry!!! Is it possible to write a macro that could do this one cell @ a time as needed over many rows in a Col activated by deleting one cell & then returning the oginal formula 2 the cell??? Thanx 4 any "HELP" !!!
 
Sort by date Sort by votes
Can you give us a specific example? I'm having trouble following what you're attempting to do here. I might just not be following the question correctly, but if you were to perform a manual overwrite on a formula, wouldn't any automation that rebuilds the formula simply undo your manual update?

Step us through an example. What you start with, what change you want to make, then what the automation is expected to perform. I think we need a clear understanding on what you're starting with and what the end result is supposed to be.
 
Upvote 0
"I have formulas is I2:I501, & K2:K501, however sometimes I manually override the formulas in select cells to enter a desired value. I want to invoke a macro upon the deleting of the manual override to return the orginal formula!!!" :)
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Use VBA to search displayed text in cell, not formula
Replies
2
Views
158
CallMeDave
C
P
  • Solved
Delete both duplicate entries across two columns
Replies
9
Views
97
saboh12617
S
L
  • Question Question
Macro to correct entries across multiple sheets
Replies
1
Views
294
Lux Aeterna
L
R
  • Solved
How to delete row based on cell value?
Replies
5
Views
343
Peter_SSs
Peter_SSs
M
  • Solved
Insert new row with incremental formula
Replies
8
Views
1K
Sheik
S

Share this page

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