| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro To insert missing data
Hi all Thank to repliers Now I am writing again without attacments . Need a macro to check which products have not ordered for eac branch. I have a list of branches in column "A" (10 rows) and products tha they have ordered in column "B". There is a list of all products in other sheet (20 rows). Since the every branch have their orders contains just a part of th products list, this macro have to open rows in column A , Insert the missing product and branch code , and have to write "not ord" for those items in column C . any help will appreciate Thanks again , lshavi -- lshavi ----------------------------------------------------------------------- lshavit's Profile: http://www.excelforum.com/member.php...fo&userid=1462 View this thread: http://www.excelforum.com/showthread.php?threadid=27359 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Name missing from Toolbar | Excel Discussion (Misc queries) | |||
| Embedding an "insert row" macro with data validation | Excel Worksheet Functions | |||
| What variable do you insert for X-cel if there is missing data? | New Users to Excel | |||
| macro to complete missing data | Excel Programming | |||
| find and insert missing values | Excel Programming | |||
![lshavit[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
