Previous Topic Next Topic

How to cell in sheet 1 into another calendar sheet

Closed
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.




Related:

1 response

Answer 1 / 1
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.
0