Hi There! Im Juan from Argentina.
I've been working around with a datasheet thats used to make an internal order within a small company.
I've used a macro (not written by me) to have a "search" dialog box. You can searh all the items you need and place de units you need in column D but the problem how to finish the order.
PLAN A: Originally i tried to use a filter a select everything but "empty" cells, but everytime i use the "search" dialog, the Filter dissapear.
PLANB: Maybe i could copy entire rows to another sheet, but only the ones that have an amount in D Column. "D" is the one where you place the quantity you need
I think Plan B is deffinitely better because a can you more tools.
Notes: Articles code, description and stock ammount comes from an SQL query
Thanks in advantage
I've been working around with a datasheet thats used to make an internal order within a small company.
I've used a macro (not written by me) to have a "search" dialog box. You can searh all the items you need and place de units you need in column D but the problem how to finish the order.
PLAN A: Originally i tried to use a filter a select everything but "empty" cells, but everytime i use the "search" dialog, the Filter dissapear.
PLANB: Maybe i could copy entire rows to another sheet, but only the ones that have an amount in D Column. "D" is the one where you place the quantity you need
I think Plan B is deffinitely better because a can you more tools.
Notes: Articles code, description and stock ammount comes from an SQL query
Thanks in advantage