Im having an issue that i want to make simpler. i have a spreadsheet with alot of fomulas in it that compares days from one month with the next month. now what i want is i want to write a macro that takes one number lets call this number X. after i type X into cell lets say A1 i want it to copy row A2:Q2 with formulas and then progressively add that row beneath it until it hits X.
that way i can just type how many days are in that month and it will automatically create that many lines
yet im trying to write a macro for this but i dont know the IF, compare, add row commands.
please all help will be welcomed
Bookmarks