How to cell in sheet 1 into another calendar sheet

Elson - Feb 23, 2018 at 09:16 PM - Latest reply: ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen
- 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.




See more 

Your reply

1 reply

ac3mark 9622 Posts Monday June 3, 2013Registration dateModeratorStatus June 22, 2018 Last seen - Mar 7, 2018 at 04:08 PM
0
Thank you
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.
Respond to ac3mark