Macro to find and copy cells

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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.