I have a spreadsheet tracking work orders. When work orders are generated,
they
must be submitted for Purchase Orders. In the spreadsheet I enter the work
order the day I get them, I don't necessarily process them that day. When I
do process, I do a search (using "find") for the work order number and put
the date processed in the appropriate column. I have 5 planners that I work
with.
Sometimes it's easier to sort by planner and enter the dates that way. When I
use the filter, the date, requisition number, and PO number end up in the
wrong row. How can this be fixed? I have a macro for each planner so they
only have to click on their name to see their work orders. I also have a
clear filter button. I don't think this fixed the problem. Any ideas?

Hi

Like always, post the macro for comments.

Is the date, requisition number and PO number inserted by the macro?

Regards,
Per

"chickalina" skrev i meddelelsen
...
I have a spreadsheet tracking work orders. When work orders are generated,
they
must be submitted for Purchase Orders. In the spreadsheet I enter the work
order the day I get them, I don't necessarily process them that day. When
I
do process, I do a search (using "find") for the work order number and put
the date processed in the appropriate column. I have 5 planners that I
work
with.
Sometimes it's easier to sort by planner and enter the dates that way.
When I
use the filter, the date, requisition number, and PO number end up in the
wrong row. How can this be fixed? I have a macro for each planner so they
only have to click on their name to see their work orders. I also have a
clear filter button. I don't think this fixed the problem. Any ideas?

The macro has actually nothing to do with the information being entered on
the wrong line item. It was happening before I added the macros. The PO
numbers and the requisition numbers are put in by me. I just use the macro to
remove all filters.
M

"Per Jessen" wrote:

Hi

Like always, post the macro for comments.

Is the date, requisition number and PO number inserted by the macro?

Regards,
Per

"chickalina" skrev i meddelelsen
...
I have a spreadsheet tracking work orders. When work orders are generated,
they
must be submitted for Purchase Orders. In the spreadsheet I enter the work
order the day I get them, I don't necessarily process them that day. When
I
do process, I do a search (using "find") for the work order number and put
the date processed in the appropriate column. I have 5 planners that I
work
with.
Sometimes it's easier to sort by planner and enter the dates that way.
When I
use the filter, the date, requisition number, and PO number end up in the
wrong row. How can this be fixed? I have a macro for each planner so they
only have to click on their name to see their work orders. I also have a
clear filter button. I don't think this fixed the problem. Any ideas?

The macro has actually nothing to do with the information being entered on
the wrong line item. It was happening before I added the macros. The PO
numbers and the requisition numbers are put in by me. I just use the macro
to
remove all filters.
M

Then I don't see how the data can end up in the wrong row, unless you have
selected the wrong row.

Regards,
Per