Copy formula value from one sheet and paste value only to another sheet

[drewship]

Hello all. Below is a snippet I need help with. I looked through the Forum and tried the suggestions as indicated below, but none of them work. The formula is located in cells on the ("Uniform Order Sheet") and I want only the VALUE copied and pasted to the ("UniformBuild") sheet. The suggestions popup various errors. I think it may just the position of the PASTE section if the line that is the issue but I have tried without success to move it.

Please Login or Register  to view this content.

Thanks,
Andrew

[AB33]

Should be on a separate lines

Please Login or Register  to view this content.

[AB33]

Most likely

Please Login or Register  to view this content.

[drewship]

Is any one of them better than the others? This will be repeated hundreds of times so I want the fastest/best option.

Thanks,
Andrew

[drewship]

We posted at the same time so I will assume you posted the most effecient method.

Thanks AB33!!

[AB33]

Andrew,
You should use the second one as it looks at the next empty row in column T while the first one pastes in to a fixed row.

[drewship]

Got it, thanks again!!