Hello,
I am trying to increment by one after eg. 7 rows for 7 rows and then again and again.
This should explain the premise
The columns/ renovation dates are the same for every Apartment, the only thing that changes is the row and with that the date.
Also I want to disregard the start dates of the renovations. The only thing I am interested in is, which apartment has upcoming renovation deadlines, for which I´ve already found my solution.
The hard thing to construct for me is to let excel know to increment the 2 by 1 after 7 rows and than again after 7 rows
This is how it should look for the first 7 rows "$E", $G, $M, $N, $AH, $AM and $AO are supposed to stay like this for every apartment as this is the link to the end-dates of the renovations.
=Information!$E2
=Information!$G2
=Information!$M2
=Information!$N2
=Information!$AH2
=Information!$AM2
=Information!$AO2
When It starts with Apartment 2, I want it to look like this
=Information!$E3
=Information!$G3
=Information!$M3
=Information!$N3
=Information!$AH3
=Information!$AM3
=Information!$AO3
and Apartment 4 like this
=Information!$E4
=Information!$G4
=Information!$M4
=Information!$N4
=Information!$AH4
=Information!$AM4
=Information!$AO4
and Apartment 1000 would be
=Information!$E1000
=Information!$G1000
=Information!$M1000
=Information!$N1000
=Information!$AH1000
=Information!$AM1000
=Information!$AO1000
Unfortunately the Apartments are not names as they are here. Each Apartment has a very different name and there is no particular system behind the naming. Also it cannot be changed
I have attached a Excel File to make it a little more clear. I have no knowledge with macros and a basic knowledge with formulas in general, meaning I have never done something of this complexity (at least for me) before. Also please pay no attention to the dates they are basically just placeholders, I´ve just copied random Dates, so it be very likely that a renovations ends before it starts.
Thanks for reading and for everyone that can help me somehow!!
Bookmarks