Hi, I need a little help with CONCATENATE
I already have a form that finds the last cell with data in sheet 1 then adds the new data to the row beneath (pretty standard thing to do and I’ve got that working).
What I need help with is, once that data is entered I want my concatenate formula in sheet 2 to write a little blurb about the latest entry (so staff can highlight it and paste it into another program).
So in sheet 1 I have data like
A B C
1 Type Size Colour
2 Truck Small Blue
3 Car Big Red
In sheet 2 I have =CONCATENATE(Sheet1!A3,Sheet3!A1……….)
In sheet 3 I have strings like ‘This is a’ to concatenate with the data from sheet 1.
So the end product should be a small narrative in sheet 2 that reads something like ‘This is a Big car that is the colour red’
What I can’t do is make reference to sheet 1 in the CONCATENATE formula. In the example above I would need to reference the last row with text, rather than type A3.
So when the next entry is added to sheet one, let’s say boat – small – white
The narrative in sheet 2 will change to read ‘This is a small boat that is the colour white’
Can anyone help? What I need is the formula for CONCATENATE that reads (In Sheet 1 find the last cell with data in column A, Sheet3!A1......) Instead of (Sheet1!A3, Sheet3!A1…)
Thanking you in advance
Bookmarks