| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select cells according to row number in different sheet
Hi and thank you in advance
I have 2 different worksheets. The one worksheet (call it the catalogue for ease) has product codes and descriptions etc. The second one is a validation sheet with all the errors in the catalogue. This second validation sheet references the ROW NUMBER of the error in the catalogue instead of the product codes as we would like. Is there a way to find the product codes in these lines? We have a few hundred in a file that has 18000 product codes. Ideally I would like to identify the product codes with the errors and 'pull' them out so I can send them to suppliers. Please help as this will take ages to do! Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Still can select locked cells in protected sheet | New Users to Excel | |||
| Select a certain number of cells in a row | Excel Discussion (Misc queries) | |||
| is it possible to select and change the values of cells in a minimized excel spread sheet from vba? | Excel Worksheet Functions | |||
| how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
| Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions | |||
Threaded Mode
