Transfer data from one sheet to another with a keyword using a macro

[deano3141]

Hi all i was wondering is it possible to give a section of data a keyword e.g App for appointment and then copy all data with the same keyword and put it into a new sheet. this function needs to be done with either a macro or with typing the keyword itself.

Please Help.

Kind Regards

Deano

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[deano3141]

Hi there John. i've just tried that and it comes up with run time error '9' subscript out of range.

Please Login or Register  to view this content.

what have i done wrong

kind regards deano

[JOHN H. DAVIS]

Do you have a Sheets("Good Data") ? Check your spelling and errant spaces.

[deano3141]

Yes i have and it is correct.
i have changed EntireRow to EntireColumn as i need to search the column not the row. it is now with run time error 424 object requiered.

Please Login or Register  to view this content.

do i need to change "X" to the keyword i need to search for.

kind regards deano

[JOHN H. DAVIS]

Can you attach a sample file with some dummy data which also causes the error?

[deano3141]

ok here it is. i have only put the key word data in.

[deano3141]

could you also help me with the charts sheet. i need o be able to input all of the necessary columns in the formula to search for the keywords.

[JOHN H. DAVIS]

I don't think I can help you with these requirement. Perhaps someone else has some ideas.