Matching numbers

[jenniferpastan]

Let me first give an eg in xl-2007


my data in a sheet named ProductList

Columns

[pre]

A B C D E F and so on till column M
Code  Name      Make       Type and so on
1001  Pillow    ABC&Co.     GN
1002  BedSheet  ABC&Co.     GN
1003  Carpet    ABC&Co.     GN
1004  Brush     RR Trader   GN
1005  Cleaner   XYZ&Co.     GN
1006  Gloves    XYZ&co.     GN
need some method wherein I enter the code number

only, in another sheet named UsedNos in column A like

[pre][code]A
1005
1002
1001
etc

[/pre]
and the output in sheet ProductList will be

Code Name Make Type and so on
1001
1002
1003 Carpet ABC&Co. GN
1004 Brush RR Trader GN
1005
1006 Gloves XYZ&co. GN[/code][/pre]
As you see the Code number should'nt be deleted in the ProductList sheet. I have such 7000+ records. The Code number is not repeated.The Code number in UsedNos sheet matches with the number in the ProductList sheet and delets the record.


thanks

 

[Faseeh]

Hi jenniferpastan,


Welcome to the Forums, I don't think you can edit ProductList this way, instead you can add a new sheet and update it for changes, the original ProductList will stay as it was.


https://dl.dropboxusercontent.com/u/60644346/jenniferpastan_sample.xlsx


Please see above file and suggest.


Regards,

 

[jenniferpastan]

Hello Faseeh


It was good but as you delete the

Code number from the Output sheet

the data re-appears in the

ModifiedProdLst.

What I needed was it should get deleted perma

since I will use that code for some other

details and not the same.


thanks