If value in column F is < 80 then copy value in column A to new Worksheet

[Groovicles]

Hi everyone,

The following is my poor attempt at this macro:

Please Login or Register  to view this content.

All I'm trying to do is have the macro go over all values in column F of worksheet Core April. If the value is < 80, then copy the value in Column A to the Core Analysis page starting at cell A5 and working downwards.

Any help?

Thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Groovicles]

hi John,

thanks awesome, thanks. Is there anyway the values in Core April column A can be pasted on the following row? right now the results are coming up right but they're scattered along the entirety of column A in the Core Analysis page.

Thanks,

[JOHN H. DAVIS]

Not sure what you mean by "the results are coming up right but they're scattered along the entirety of column A in the Core Analysis page". Do you have data in Core Analysis A5?

[Groovicles]

hi John,

No. For some reasons the data shows up in Core Analysis A37. The results don't start at A5 nor are they listed in immediately subsequent rows.

[JOHN H. DAVIS]

Try this:

Please Login or Register  to view this content.

[Groovicles]

Hi John,

That's perfect! Thanks very much!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.