Hi all,
I have vastly simplified my problem to make it clear what I am trying to do. In reality, the ranges I am looking at are much larger.
I have two identically sized and formatted ranges:
e.g. (1) B3:D5 and (2) F3:H5
Range F3:H5 has three cells containing different formulas, all of them with absolute references so copy and pasting them to another location would not be an issue.
Basically I want users to enter values into any of the cells in range B3:D5. And then once the user has finished entering values into range B3:D5, I want to have a macro that can paste the formulas in range F3:H5 (if needed) to the same relative locations in range B3:D5 WHILST leaving the values the user has entered into the rest of the cells in range B3:D5 intact/unchanged.
E.g. if the three formula cells in range F3:H5 are in cells F3, G3 and H4. I want the formula in F3 to be pasted to cell B3, the formula in G3 to be pasted to cell C3 and the formula in H4 to be pasted to cell D4.
Is it possible for a macro to find each formula cell in one range, note its relative location in the range and then paste it to the same relative location in another identically sized range? Is this complicated to do? The alternative is me painstakingly recording myself copy and pasting each formula cell back and forth.
I tried to attach a simple file to explain what I mean and make it clearer, but I can't seem to be able to.
Hoping someone can help.
Kind regards
Henry
Bookmarks