If I'm not mistake to get what you mean....
The activesheet has a formula in one column
where in the formula there is going to be always has a text "sum",
because the formula will always be sum formula ---> =SUM(cell:cell).
The user has to tell the code on what column the formula is by typing the column letter
for example type a (if the sum formula is in column A), type q (if the sum formula is in column Q), etc.
The user also has to tell the code to what direction the code has to paste the copied formula.
In this code case, type left (if the paste range is to the left), type right (if the paste range is to the right).
Assuming that the condition of the active sheet is "clean" - no other thing which can disrupting the process code,
the expected result is : to each row where the column has sum formula,
this formula will be copied then paste either to the END-left or to the END-right column range.
I do my way like this :
Bookmarks