Hello everyone,
I'm new to this forum and I'm quite green in VBA as well. What i want to do is to edit formulae in my spreadsheet so they would refer to a different row, and the row number is a variable. I have 12 sheets for each month, in each sheet i have a list of 300 records, each having like 11 values: nr, name, brutto gain and so on...
Now what i want to do is to quickly create a sheet with a summary for each person, so it looks like this:
nr: 1 John Doe
brutto gain | Tax 1| Tax 2| and so on...
January:
February:
March:
and so on...
so basically i need to create a table for each of the 300 records. I have done like 50 separate tables by now by simply copying the code of the first manually input table and altering the formulae using the Find / Change tool to change the row number inside the formula, but that's been a pain. Can someone help me write a macro which would copy a selection (15rows:12columns) 16 rows lower while changing all the formulae to be referring to only 1 row number higher than the original formulae?
thx in advance
EDIT:
to be more specific, I need a way to change all the formulas within a selected range in this manner: Formula(x,y) = Formula(x+1,y). The used formulas are simply references to cells in other sheets, but i don't really want to write it manually for all 134 meaning cells in the selection...
Bookmarks