Previous Topic Next Topic

Macro to find and copy cells

Closed
AB - Jan 11, 2012 at 02:57 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 11, 2012 at 09:34 PM
Hello,
I have never wrote a macro using VB I normally just do simple ones step by step, could you please tell me how to do one that finds the cells that have the same information and copies it to another sheet? ex: if the part 14-604L is using in another site other than site 1 i would like that to be copied to another sheet so i end up with a list of all the shared parts among sites.

Thank you and sorry for such a basic question but I am not sure how else to find out, I have been reading but with no guidance i have a hard time visualizing it.

AB

site 1 site 2 site 3 site 4 site 5
14-604L 1 .44NRSR01.50 #150 hose
386-054 1.5 95 008 052.145
556-111 22.0318 111.094 009 055.0804
641-005 027.735 000157 10.4861 66
697-045 0096 000160 10.4881 066.6001



1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 11, 2012 at 09:34 PM
try RECORDING the macro and edit the macro. if there is problem in editing the macro post back with the macro and if possible with small extract of sheet 1 and sheet which can be uploaded to
speddyshare.com
you have to post the webpage for downloading.
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Condition formatting on changing cell color based on another cel
Saitoh7 -
Mazzaropi -

1 response
Comparing columns and returning value
ll -
kittu -

35 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses