I'm trying to keep a cell constant during data transfer (combining text & dates) within a master sheet and second sheet of a workbook, and I'm adding rows to the second sheet of the workbook. Here is the formula I've tried on the master sheet:
=TEXT(SecondSheet!$A$2,"mm/dd/yyyy")&" "&SecondSheet!$B$2
The $ before the cells I want to stay constant isn't working. I'm adding a row above the previous one used so things stay in chronological order with newest date on top. I need the date and text combined and transferred to the master sheet so the latest data is there at a quick glance. Is there another way to keep the cell constant besides using the $?
Bookmarks