Macro not displaying all the rows. Cuts some

Need help with this file, i did most of the code but cant figure out some bugs i am having.

CTRL-SHIFT-F runs the macro,

the problem i am running into is ,

1), i have the macro looking up the legend in row 3 in the factory install tab, and having it find this legend in the T1 Verbiage file. Once found i want all of the data in the column of that legend pasted in row 12.

I currectly have the macro pasting the legend verbiage according to the legend in row 3 correctly but it leaves out some rows. Can someone look at the code and find out why its leaving out some rows of verbiage?


, Next i have certain requirements of where Capital E's should go, where routine maintanence should go ect. I have that at the end of the code and is correct.

The problem here is with this part. ( starts at row 12, counds all of n which is the verbiage rows, then adds 8. So in other words this formula needs to be 8 rows after the verbiage ( which is dynamic depending on the legend )

Cells(12 + n + 8, i + 1).Value =

i need this value to equal a formula. It needs to Say Completed have a space and include the data that is in row 2.

In excel this would look like ="COMPLETED"&" "&B2

Obviously this is dynamic, meaning if i am in Column H, it would say ="COMPLETED"&" "&H2

Once again ctrl shift f runs the macro, which shows you the results i have so far. Once again the problems include ALL the verbiage rows are not being pulled, it leaves some at the end, and also the place where it shows completed needs to be the formula i explained above.

This might sound confusing but if anyone downloads the file and runs this macro they will clearly understand what i am doing.

Thanks for anyone that helps, as this will save me tremendous time.

Thanks

WOW, perfect.

Very impressive, you did this so fast.

Much different approach then i took. I assume its better because it works :D

Will this macro work with other sheets, i have other tabs, after the 5-20k, for instance the next tab is 30k, 40 k ect. Legends are in the verbiage part once again, but different tab name.

Also if i want to use T2 Verbiage tab instead of T1 Verbiage tab what would i have to change.

Reason i am asking is sometimes the tab's change names and i want to make sure i can fix it.