Merging two sheets

How can you use the date as key identifier when your first sheet has multiple rows for a specific date? Do you want all those rows combined to a single row with the combined data (plus B to J) of the other sheet?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi Bruce and welcome to the forum,

I think you only get 10% because you have a relationship between the two sheets that is NOT exact. If you try to match your "Sales Date" field, the time is included in the match.

I suggest you use a combination of fields to do the match or perhaps a rounding of the date field to eliminate the time.

If you can supply a sample workbook, we could be of more help.