How to cell in sheet 1 into another calendar sheet

Elson - Updated on Feb 24, 2018 at 06:27 AM
 Blocked Profile - Mar 7, 2018 at 04:08 PM
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 response

Blocked Profile
Mar 7, 2018 at 04:08 PM
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.