Cell constancy when transferring combined date/text from one sheet to another

**Grasshopper Green** · 02-07-2018, 01:56 PM

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 $?

**TMS** · 02-07-2018, 02:00 PM

Untested, but something like:

Formula:

Please Login or Register  to view this content.

**Grasshopper Green** · 02-07-2018, 02:46 PM

Originally Posted by TMS

Untested, but something like:

Formula:

Please Login or Register  to view this content.

This worked, thank you!! If you don't mind, what does the index function do? I'm self taught with Excel (except the help I receive here!)

**TMS** · 02-07-2018, 03:38 PM

You're welcome. Thanks for the rep.

You can INDEX a row, or column, or range. That is, you can choose an element from the row, column, or range based on row and/or column indices. In this example, we are saying, pick the second element in the column A. As the 2 is a static value, it does not change (auto-adjust) as you add or remove rows.

See: https://support.office.com/en-us/art...2-b56b061328bd

Cell constancy when transferring combined date/text from one sheet to another

LinkBack

Thread Tools

Rate This Thread

Display

Cell constancy when transferring combined date/text from one sheet to another

Re: Cell constancy when transferring combined date/text from one sheet to another

Re: Cell constancy when transferring combined date/text from one sheet to another

Re: Cell constancy when transferring combined date/text from one sheet to another

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Combining dates & text and transferring to separate sheet

[SOLVED] Combined text and date

[SOLVED] Grabbing information on a row based on date and transferring to another sheet for summary

Transferring multiple data from the same sheet in a single cell In another sheet.

Convert Date To Text To Be Combined With Other Texts

text and number combined in a cell

[SOLVED] Counting based on combined text and date criteria

Bookmarks

Bookmarks

Posting Permissions