Completed Projects

[mikesjd110]

I am looking for the work sheet "Chuck Riddle" to show me what projects that he does not have completed from data in work sheet "Safety" "1 Week Response" and "Routine" On Chucks work sheet I would like to view the W.O. #'s under the Reason Code and also show the date the work order was generated only on those incomplete. I am sending an attachment hopefully someone can help me with what I am trying to do.

[JBeaucaire]

This is placed in the employee sheet itself. It will reassess the list each time it is activated.

To create other employee sheets, you need only copy this "Chuck Riddle" sheet and rename it properly. Then it will reassess for that employee name.

Please Login or Register  to view this content.

[mikesjd110]

Thanks a lot for your help, But I'm having a few issues...
Please review the attachment.

[JBeaucaire]

When I run that code on your sheet, it finds the spot B6 for me every time. I didn't want to hardcode B6 as the spot where your chart starts because I know how people like to reposition things. If we use a .Find then it will always find it.

Anyway, you can try:

1) Turn on the macro recorder and let it record you doing a CTRL-F (find) for W.O.# in your sheet, then post the code here, let's see if your system has a different result than mine.

2) Just hard code the first cell to paste into as:

Please Login or Register  to view this content.

[mikesjd110]

Thanks so much, It works perfectly

[mikesjd110]

Here is the new attachment / workbook. Thank-you for your help.

[JBeaucaire]

This new workbook has a completely different layout, as well a different sheet name for Safety. Thus I presume you have edited the code in your attempt. Also, you seem to want the data copied in to appear in a new place... remember how I said in post #4 that was why I was searching for the position instead of hardcoding it.


Anyway, I can't find your non-working yet edited code anywhere in the sample workbook. To insure you're understanding the code you're using, or at least the part that need editing, let's work from your edited code.

Please post the file with your non-working edited version so I can see what you tried and where you tried to get it to appear. We'll work from there, OK?

Also, anything not abundantly clear please provide as an informational aid.

[mikesjd110]

Great to hear back from you I truly appreciate the help. Attached is a copy of my alterations, As you can see worksheet Chuck Riddle starts to work but shows no data, Turns that area of the sheet white but does not show data. Also it turns the sheet white starting at column "A" instead of "O"
Hopefully you can help,

Mike

[JBeaucaire]

The data no longer starts at row 1, so we can't just autofilter the whole sheet anymore, can we? The .Cells reference filters the whole sheet, we need to specifically filter from B11 now. See, I told you people like to move things around, I didn't think that would include the DATA sheets... hehe... I'll make that part self-adjusting, too, so you can start the data anywhere on the source sheets, too.

Here's the adjusted code, once installed and working in one sheet, you can simply duplicate the sheet and rename it to get an instantly working new version.

Note, I changed the copy command to "values only", so as you move things around (I noticed each sample employee sheet had the chart in a different spot, which is fine)...make sure the date columns are formatted as dates.

You can go ahead and put your desired formatting back in place on those employee sheets.

Please Login or Register  to view this content.

WARNNG: While I was working on your sheet, it ballooned up to 10Mb for no reason. This "bloat" is attributed to applying cell formatting and/or conditional formatting to entire worksheets, so it is not a good idea. I would suggest you reign that in a bit.

[mikesjd110]

Excellant, I appreciate your help and support so much.
The best. Thank-You.