If Column =(number range) then copy row to different worksheet! :(

[digbee]

Good Morning,

My brain is fried please help.
I have a large project on the go and currently have 6 worksheets on a work book and to allow me to track the evidence I have added in Column A of each worksheet called "number" and I have to number each bit of evidence in order to track where it is stored, these are spread over each worksheet.

Not every row has a number as not every file had evidence.

Therefore to make life easy I want to copy all of these rows with numbers over to a sheet called 'evidence' (there is ALOT of evidence).

Please note I am a complete novice when it comes to macros (if this is the resolution!)

Is this possible, happy to explain further.

Thank you

Jodie

[AliGW]

Welcome to the forum.

Please see the instructions at the top of the page about how to attach a desensitised sample workbook.

[digbee]

Thankyou so much, I have created a very small version of what I need help on. I hope this makes sense.

on my actual spreadsheet I have over 600 numbers I need copied into one.

[AliGW]

I don't think you read the instructions properly. You missed this:

... and some manually calculated results.

Please show us what you are looking for (10-15 rows will be enough).

[digbee]

Apologies, please see attached.

I hope this is what you are looking for.

[AliGW]

This solution uses PowerQuery, which is built into Excel 2019 as Get & Transform on the Data ribbon.

It requires the tables on each of the source tabs to be converted to real Excel tables (select - Insert - Table). When refreshed, the results will update and append any new tables in new tabs added to the workbook.

It uses the following M Code:

Please Login or Register  to view this content.