Formula to copy text from one worksheet to another

[jtmbell]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Account number

[/TD]
[TD]Account notes
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]Account status updates pending review, docs due by EOW
[/TD]
[/TR]
</tbody>[/TABLE]
Working with alarge Excel document with several worksheets (a new worksheet is generated eachday - each named as the date). Today's worksheet is 9.2.18 and yesterday's worksheet is 9.1.18
Each worksheet is a large "pipeline" report for that specific daysbusiness so the rows and order of information each day can change. Todays report may have account 123 in A2 but that same account may be in A12 on yesterdays or it could have fallen off from yesterday to todays report. Thecolumn headers do not change.
Column A header = account number Column G header = Account notes

Needing a formula to copy the specific text (alpha text, not numerical) from yesterdays worksheet for that specific account to todays worksheet for the specific account . Text needing to copy is notes from yesterdays business for the specific account.

I currently use the below formula for other columns within this document but I am not sure how to get the specific text/notes to copy over. I don't just want an X in the notes, I need the notes from yesterday to show on todays worksheet for that specific account.

=IF(COUNTIFS('9.1.18'!A:A,A2,'9.1.18'!EM:EM,"X"),"X","")


Any and all help on this is greatly appreciated! There has to be an easier and less time consuming way than manually copying each individual note over - there are in excess of 200 rows!

 

[mole999]

Quick question, have you asked this else where, curious because the dates you use are 20 days ago so it dosen't seem a recent question