Automatic copying to another sheet using indirect

Hi

I have a raw database sheet and I would like it to pull data from one sheet and pull it onto the relevant sheet. In column AC of the sheet “PO Line Analysis” it lists the sheet I need this row copied to.

The data on the raw sheet will always remain there, it’s just also pulled onto the other sheets.

e.g.

Row 2 on the PO line Analysis sheet, column AC is “Manual Process”

I would like columns A:R to be copied to the sheet “Manual Process”

Can anyone help with this please?


I have attached an example

Hi,

I would ideally like a formula but if not I have found a macro here which may help:

Please Login or Register  to view this content.

However - this looks up column 3. Is there any way I can change this to AC?

It tests for an existing output sheet. the formula should handle the errors with iferror()

The posted line is complemented with a "***" mark to avoid repeated postings.

Hi,

This works -

Please Login or Register  to view this content.

Never seen anything like this before - how is it knowing to pull the sheet name?

A Massive Thank you buy the way!!!