Hello I am new here and am having a problem when copying data. I have a sheet set up to keep a list of items by date on the first tab. I have a column on that tab when I send the item out I want all the data (name, amount, account number) to pull to another tab based off the date I put in. When I have multiple ones with the same date when it pulls the data to the new tab it keeps them all the same name, account number and amount. Is there a way to make it not do that. The only work around I have found so far is to use different dates but then I am limited to 7 a week. I hope this makes sense if it would help if I put up screen shots of the formulas or the sheet please let me know. Thanks in advance for any help.