Macro to copu split data into diferent column

[dobracik]

Hi all


Hope, that here is somebone who could help me. I have macro, which will merge and split compiled data into more sheets based on column A. This is working.
However, I would liek to make small correction in the macro, that will paste those split into column Q. at the moment it past to column A.

I've tried to change all the references, but it's not working

Thanks,
Andy

Please Login or Register  to view this content.

[dobracik]

Hi all,

I just found out, where it should be updated, but don't know how to modify it.

Is there anybody, who could help me to update following part so it will be untill columns P, not untill last active column?

Please Login or Register  to view this content.

[dobracik]

Hi all

is there anybody who could help me to modify the above code to have it for the specific range, not to LR?

Thank you,
Kind Regards,
Andy

[Alf]

so it will be untill columns P, not untill last active column?

instead of

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

Looking at your post #2 there is a mistake in the ws.Cells expression I think. Should it not be i instead og 1?

Alf

[Alf]

No I now realise that that the "Unique" value in column P is probably a heading so it should go into row 1. So replace the i in my code snippet with a 1.

not to LR?

one way could be to change

Please Login or Register  to view this content.

to the "lr" value to the highest row number in your specific range or perhaps an

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

alf