Help with macro

[bromano]

Hello All. thanks for reading my problem.

I have a workbook with one sheet (called 'data') that is a calender with staff assignments. for example:
DAY DATE MONTH DAY CALL NIGHT CALL NOTES
tues 1 jan Sam Sue
wed 2 jan Sue Sam Leaves early

I have a second sheet (called "GW_calendar) where each row looks at the first sheet and combines the data so I end up with:
"Jan 1- DAY CALL= SAM; NIGHT CALL=SUE; NOTES: "
"Jan 2 -DAY ALL=Sue; NIGHT CALL=Sam; Notes: Leaves early"

I need a formula that can recognizes that the first NOTES cell is empty and just ignore it so I don't end up with the "NOTES:" blank entry.

Hope this all makes sense and someone can help.
Many thanks in advance!
//bill

 

[Fackouch]

assuming ur Notes are in column F. and the rest of data column A,B,C,D,E. try this.

=IF(F2="",CONCATENATE(A2,B2,C2,D2,E2),CONCATENATE(A2,B2,C2,D2,E2,F2))

Hello All. thanks for reading my problem.

I have a workbook with one sheet (called 'data') that is a calender with staff assignments. for example:
DAY DATE MONTH DAY CALL NIGHT CALL NOTES
tues 1 jan Sam Sue
wed 2 jan Sue Sam Leaves early

I have a second sheet (called "GW_calendar) where each row looks at the first sheet and combines the data so I end up with:
"Jan 1- DAY CALL= SAM; NIGHT CALL=SUE; NOTES: "
"Jan 2 -DAY ALL=Sue; NIGHT CALL=Sam; Notes: Leaves early"

I need a formula that can recognizes that the first NOTES cell is empty and just ignore it so I don't end up with the "NOTES:" blank entry.

Hope this all makes sense and someone can help.
Many thanks in advance!
//bill

 

[bromano]

assuming ur Notes are in column F. and the rest of data column A,B,C,D,E. try this.

=IF(F2="",CONCATENATE(A2,B2,C2,D2,E2),CONCATENATE(A2,B2,C2,D2,E2,F2))

Thanks, Fackouch...
I tried it and it's returning the contents of a2:e2 but not F2 when there's something in that cell.

/b