Hi,
I need help and I'm not great with macros but if you can tell me a way to do what I want with 1 cell I will be able to mimic the results for multiple cells.
I've had a look through the threads and I've seen some which are similar but not exactly what I want and they all seem to do the same, which is when I shift the data down by 1 cell any formulas I have set up to read the data also moved down.
this is what I wrote which does the copying and the poasting and shifts the cells down:
When I then want to do some calculation on the data that appears in sheet "data" the ranges on the formulas I write keep moving down, how do I stop the shift from effecting my formulas range?Please Login or Register to view this content.
Bookmarks