Match and copy

[clownstyle]

Hi everyone,

Got a problem spreadsheet and it's been a while since I've done anything with Excel. If you pros can cast an eye over the following I would be very grateful :D

I've got a large report that has exported data about printers. I have 6 sheets that are just data, with serial numbers for each printer. The last sheet contains serial numbers for each of the machines. Basically I need somehow to search the first 1-6 worksheets for text that contains "For printer [ID:4]" . [ID:5] [ID:6] etc.. and add the machine serial number, copied from the other sheet.

I can probably explain better with pictures

https://imgur.com/1MLkean

https://imgur.com/gXVpz3Z

 

[clownstyle]

When I run the macro on the file located at this link, it works properly.
https://app.box.com/s/qco16r47c3qfv3bmra8snicpbez608ub

That's strange, it's working now when I add it as a module, on the large sheet though I'm getting this error:

https://imgur.com/Mtl9w7L

Think it's due to the fact it's unable to create any more rows, would it be possible to remove that part from the code?

 

[mumps]

The macro uses filters and the header row is needed for the filtering to work. There may be a way around that buy I'm not aware of it. Perhaps you could manually move a row from the bottom of one sheet to the top of the next sheet so that a blank row.is left at the bottom of each sheet.

 

[clownstyle]

The macro uses filters and the header row is needed for the filtering to work. There may be a way around that buy I'm not aware of it. Perhaps you could manually move a row from the bottom of one sheet to the top of the next sheet so that a blank row.is left at the bottom of each sheet.

Ah I see. Well that seems to be working well! I've manually cut and inserted a few lines on each page and its inserted all the serials for me.

Many thanks mumps!

 

[mumps]

You are very welcome