<help me to write macro in excel>

Closed
mihi - 25 Nov 2009 à 08:11
Slayer2004 Posts 3 Registration date Monday 30 November 2009 Status Member Last seen 1 December 2009 - 1 Dec 2009 à 04:47
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 30 November 2009 Status Member Last seen 1 December 2009
1 Dec 2009 à 04:47
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