How to cell in sheet 1 into another calendar sheet

 Blocked Profile -
Hello, Elson here.

Would like to ask. How to transfer a date + remark from sheet A, into a calendar sheet B.
For example.
Sheet A
Cell 1: date (2.2.2018)
Remark: Not working

Calendar sheet B
I want the date in Sheet A to be display on the calendar, together with that remark.

1 reply

By remark, do you mean a note, or is it another value in another cell. If it is another value in another cell, then you would place this in the cell you want to display the COMBINED value:

=(Sheet1!A1 & " " & Sheet1!A2)

Hope this helps.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!