How to cell in sheet 1 into another calendar sheet Closed

Question

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.




System Configuration: Windows / Chrome 64.0.3282.167

ac3mark · Answer

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.

How to cell in sheet 1 into another calendar sheet

1 response

Subscribe To Our Newsletter!