Find data based off unique identifiers and return only columns showing data

CV Viper Daily Inputs December.xlsx

I have a spreadsheet that is half copy and paste from a website report, with the other half manual entry to identify and sort cost. This is the data located on the "Sysco Inputs" tab. I'm trying to take that data and put it in a format to upload into QuickBooks which is the "Sysco Inmports" tab. The layout is the way I need it on the imports tab but I'm trying to get the data to auto populate and only return rows and or columns with data. I'm stumped!

Any help anyone can offer would be very much appreciated!

Thanks...

Yes, everything you stated is correct. Net 15 should be the date plus 15 days unless it falls on a weekend. I'm just not sure how to make that work. All suppliers should be included as well please.

Thank you for your help!

Incredible! Thank you so much! Before I close this out, just out of curiosity can a Macro also be created to save a tab like this as a Text (delimited) file to save time for my upload file?

Sysco File W-Bill Credits.xlsmLast issue: the import was being rejected by Quickbooks. I thought at first because the ENDTRNS was not on its own line. After doing additional testing I discovered its because I cant post a negative as a bill. It has to be imported in its own file as a bill credit. I added a Tab on the spreadsheet called "Sysco Import Bill Credit". If there is anyway I can get the negative invoices from the "Sysco Inputs" tab to come off of the "Sysco Import Bills" tab that you created and sent to the "Sysco Import Bill Credit" tab this should be done. I have no idea how to do what you created and would be more than happy to pay for you to take it all the way through to the end. I value your time and appreciate your help!

That's it. I need the positives to go to the bills tab from the Sysco inputs and the negative to the bill credit. Then if there is anyway to get the ENDTRNS on its own line after everytransaction that would be perfect.

The two tabs are very similar with only a few fields that are different. The layout I provided is how it needs to be for the import. I hope I'm answering your question. Also the file needs to be saved as a comma dilimites file and cal be called QB Bill import and QB Bill Credit Import. Thanks so much for your help. Can I pay you?

That would be great! One more thing I thought I would ask for it its not too late.. Are you able to ignore all the "Zero" dollar items? For example if row 3 of the Sysco inputs tab only returned the two fields that had data below the main line, this being Paper for $139.30 and cleaning, chemical, janitorial for $276.83. All of the zero items make a huge spreadsheet. If not, no big deal. I can live with it.

The file looks perfect! I cant tell where its saving the .csv file to though. Any ideas?