<help me to write macro in excel>

Closed
mihi - Nov 25, 2009 at 08:11 AM
Slayer2004 Posts 3 Registration date Monday November 30, 2009 Status Member Last seen December 1, 2009 - Dec 1, 2009 at 04:47 AM
Hello,
I have a exel sheet containing data.i wont to check each cell and if that is equal to string "ABC" the next cell value have to copy and paste to another sheet.like wise have many rows.and columns.
Related:

1 response

Slayer2004 Posts 3 Registration date Monday November 30, 2009 Status Member Last seen December 1, 2009
Dec 1, 2009 at 04:47 AM
Hi

I will see if I can help, you will need to setup a macro that does a find so it will search the ABC and the select the next column. The only problem will be how you specify how it does this, how many times etc or looping it as this could end up being very messy

What version of Excel are you using also as the syntax xhanges dependant on the verison you have.

Regards
Andy
0