Need a macro to append data from one worksheet to another in the same workbook

[sam chee]

Hi all,

I am seriously looking for some help to append data from one worksheet to another with specific criteria.

My master worksheet (Register) contain the field Loc, DR, Client No., Holdings and Remarks.
The specific criteria is at the Remarks column, whereby it contain USD, GBP, SGD & Share.

What was intended is to append the data (Loc, DR, Client No., Holdings and Remarks) that has the Remarks "USD" to another worksheet call "USD worksheet" in the same workbook.
I have attach the excel workbook for reference.

I would not mind if there is an excel formula that works too.

Hope I can get some help soon.

Thanks in advance for any response

Regards,

Sam Chee

[Sindhus]

Hi, Check if the formula in the attached sheet would help.

[sam chee]

Hi Sindhus,

Thank you in advance.
The formula do helps, but how to get rid of #NUM!?
What if the master copy data is large? Sometime can be little and sometime a lot of data.

[Sindhus]

Just enclose the entire formula with iferror. =iferror(existing_Formula,"")

[sam chee]

Hi Sindhus,

Thanks, will try it out.

Regards,

Sam Chee

[sam chee]

Hi Sindhus,

Ok, I try it out in my copy of excel, but it does not work at all.

Regards,

Sam Chee

[Sindhus]

Hi Sam Chee,
PFA the attached sheet. It is an array formula. You need to enter it with Ctrl+Shift+Enter. Enter the formula it the first row. And you can copy it to the other rows.

[sam chee]

Hi Sindhus,

Thank you for your patience.
I have tried to entry the formula manually, after completing i press Ctrl+Shift+Enter, but the result came out to a 0(zero).
Not sure where have i make a mistake, I have attach the copy for your reference, hope that you are able to pinpoint where my mistake is.

[Sindhus]

Hi Sam Chee,
In the formula you have missed two " marks. At the end of the formula, it should be row(indirect("1:113")). You have entered it as row(indirect(1:113))

Regards,
Sindhu

[mohan.r1980]

Hi sam chee,

Please find the attached file of excel

i think it may solve your problem

[sam chee]

Hi Sindhus,

Thanks for the pinpointing, I will go thru' it again.

Have a nice day.

Regards,
Sam Chee

[sam chee]

Hi Mohan.r1980,

I have tried it out, it really resolve my issue.

Thanks a million.

[mohan.r1980]

Hello sam chee

your welcome

Please mark your thread as Solved