Insert rows on numerous sheets at offset to an ID in column A and autofill down formulae.

[Silverjman]

Hello folks, I really need to learn VBA among other things...any help you can provide here would be terribly appreciated.

I have 40 sheets that have unique IDs (1,2,3,4,5) in column "A" but the IDs (of course) have a different starting row on each page, thankfully their order on each sheet is the same, so their offset to the IDs on the master sheet will be constant.

I need code that when ran:
1) Takes the user's active cell (or asks for the column "A" ID to insert below) on the single master sheet (only sheet the user views) and asks the # of rows they would like to insert.

2) Automatically inserts the same # of rows on sheets "Blue", "Dragon", "Apple", etc. (37 more) at the same appointed ID as ActiveCell or user dictated ID as on the master sheet.

3) Autofills only new rows with formulae and conditional formatting from respective last old row above in each sheet, but does not copy down hardcoded data.

Wow that description looks so benign compared to the code I've been looking at in the forum and elsewhere.

Thanks again, cheers!

 

[Silverjman]

Ended up getting a solution to this, I know it goes against the spirit of this board not to post it but let me know if you'd like it and I'll private message it.