copy cell in row to another sheet if criteria is met

[thebrin]

Hi,
I am a novice so please bear with me.

I am looking at row 2 in sheet 1. I would like to copy any cell in this row if the cell in the same column @ row 44 is > 1 to another sheet (sheet2 beginning at c17 and down if empty.

I am stuck on the if/then. How do I globally look for criteria in each column without separately listing an if/then for each.



THIS IS WHAT I HAVE SO FAR....

Please Login or Register  to view this content.

Any assistance would be appreciated
thebrin

[Kaper]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[stnkynts]

Please Login or Register  to view this content.

[Kaper]

You may also try something like:

Please Login or Register  to view this content.

and note how is ot easy to read the above in code tags - so please edit your post.

[thebrin]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Sorry - will read forum rules

[thebrin]

Thanks stnkynts - I ran the code and it does indeed place the first result into C17 , but there are multiple columns that meet the criteria and it only placed the 1st result it found, not the rest. Your thoughts?

[thebrin]

Thanks Kaper - I ran the code and I am getting a syntax error on line

Please Login or Register  to view this content.

[Kaper]

Please Login or Register  to view this content.

anyway - not tested it because there is no sample file (and I'm too lazy/busy to create one :-P)
as for the code by stnkynts - at first sight - shall list all values where criterium (row 44 value in resp. column >1) is met

[Kaper]

By the way in my code here shall be 42 as offset I thing - current row is 2 so offsetted down by 42 will be 44 :mrgreen:

Please Login or Register  to view this content.

[stnkynts]

Thanks stnkynts - I ran the code and it does indeed place the first result into C17 , but there are multiple columns that meet the criteria and it only placed the 1st result it found, not the rest. Your thoughts?

Worked just fine for me when tested. Submit an example workbook