Macro which will copy entire ROW to another sheet based on contents of one cell!

Hi All,

See the attached spreadsheet for exact details, but basically what I want is:

The employee will fill out their workload for each day on the "MAIN INPUT" sheet, then, based on what the cell says in COLUMN E, I want a macro linked to a button that will copy the different outcomes, to the sheet with the matching name which I have already created.

I also need them to appear on their sheets with no rows blank inbetween, with no duplicates, and in the same order as they appear on the "MAIN INPUT" Sheet.

I want the macro linked to a button that the employee can press to update the workbook.

I also want the employee to only be able to scroll from: Columns A - K, and rows 1-2000.

Can this be done? I hope so!

Any questions or if i'm not being clear, do let me know!

Thanks so much!

Chris

P.S. I have had a go at writing some code for the scrolling thing which I don't think works, may be best to just delete that and start over! Thanks!

Hi p24leclerc!

That's good, but imagine if I wanted to keep the "Main Input" sheet the same as it is, could I do that...

I thought of this idea:

If we inserted the Formula

Formula:

Please Login or Register  to view this content.

into Cell L2 this would then result in the settlement route followed by a number representing the number of times this outcome had occurred in the format: "Cash Settlement_1". If then we copied that down 2000 rows, could the macro copy the rows to the right sheet, and then use the number at the end to paste them in the right order on their respective sheets?

Would this be possible?

Also, I need to be able to scroll to areas which the people I give the workbook to cannot, is there anyway I can override the scroll lock part of the macro, but they can't?

Thanks!

Chris

Hi P24Leclerc!

Back again with a similar issue. There is a spreadsheet attached to this post, so what I need now is a macro which will "read" column C, identify the surveyor, and then copy the relevant rows to sheets named after the surveyors. If a sheet for the surveyor does not currently exist I need the macro to make one.

I need the copied rows to stay in the same order that they appear on the main Input sheet as before. When copying the rows, I only need columns A to U copied to the sheets.

I hope this makes sense, I need this to happen via a button on the MAIN INPUT Sheet.

I need a response to this URGENTLY please!

Thanks!

Chris