Copying rows to a particular sheet!

[TrueBlue073]

Hi everybody,

I'm a newbie in Excel en I do hope so U can help me.
I'm trying to write a formula which will (if any cel in that row has a value->number from 1-to 8 ) copy that particular row to a another sheet.
For example:
I have a same person with same information throughout a columns within 4 row's, but in row's they differ in location.
So if I set a value in row 4, column B for example with location X this raw should be copied to sheet x with all of it's formulas.

Thank U very much in advance,

Please let me know whether I was clear enough.

 

[TrueBlue073]

Here is excel sheet I'm working on.

 

[Nebu]

Hi:

Please find the attached, This macro will basically split your master sheet into different tabs as per opmerkingen, I am not sure about

(if any cell in that row has a value->number from 1-to 8 )

, if you can explain a bit more on this I can incorporate that condition in the macro.

 

[TrueBlue073]

Nebu,

Thnx a lot for your response.
This is exactly what I meant.
Is it possible to; as I fill cells uren(hours) in master sheet and whatever cell I want, to transfer this value automatically into differtent tabs as per opmerking(remark)?
Also as weeks will progress to week 5, 6, 7, and so on, will this macro pick-up this weeks as well or I must run(kick) macro every time, and If so were I can find it?

Hats off for U. This is very, very helpful.

 

[Nebu]

The macro is flexible enough to accommodate "n" no of rows . Currently the macro just checks the remark column and transfer it into respective tabs, Its not checking any of the week numbers. I was not clear regarding your requirement on week numbers hence I asked for the clarification. Yes, you will have to run the macro by clicking the button every time a new week gets added. It basically deletes all the data from your various remark tab and paste it fresh every time you run the macro. If you do not need this to happen let me know it is just a minor change in the code. Try to run the macro using Function F8 key and see how the macro works in the background by splitting the screen between excel workbook and VBA editor, you will have a better idea. Let me know with questions if any...

Thanks

 

[TrueBlue073]

Nebu,

Thnx,

How can I get columns H to S to be included in macro?
As I fill remark column, macro will take this and process it. So this works.
Only thing is that as I fill columns H to S in master sheet, values that I put in are not shown in separate tabs. I'm not sure how to manage this in macro. can U help me.

Thanks a bunch,

 

[Nebu]

Hi:

You will have to run the macro after updating the master sheet.

The macro copies from column A through U

Thanks

 

[TrueBlue073]

I see.
Sorry. Just a newbie . It works.
I'm very, very grateful for this.