Please help with excel 2002 version 12527-21104

%3CLINGO-SUB%20id%3D%22lingo-sub-1724520%22%20slang%3D%22en-US%22%3EPlease%20help%20with%20excel%202002%20version%2012527-21104%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1724520%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20some%20guidance%20on%20how%20to%20enter%20invoice%20data%20in%20a%20spreadsheet.%3C%2FP%3E%3CP%3EExample%20has%20been%20copied%20below.%3C%2FP%3E%3CP%3ESome%20vendors%20only%20send%20an%20invoice%20once%20per%20month%20which%20would%20work%20perfectly%20with%20this%20type%20of%20layout.%20But%20some%20of%20the%20other%20vendors%20send%20multiple%20invoices%20per%20month.%20I%20would%20like%20some%20suggestion%20on%20how%20I%20can%20input%20multiple%20invoices%20into%20a%20chart%20while%20keeping%20all%20the%20other%20vendors'%20invoices%20in%20an%20organized%20manner.%20I%20would%20greatly%20appreciate%20the%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22386%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22142%22%3EVENDOR%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EInvoice%20%23%3C%2FTD%3E%3CTD%20width%3D%2279%22%3EDate%20Coded%3C%2FTD%3E%3CTD%20width%3D%22101%22%3EDate%20Approved%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EStaples%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EHamster%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EImperial%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EBarocco%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EGFL%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECBSC%20Capital%20Inc.%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECanon%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ERogers%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETyco%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENational%20Leasing%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EPitney%20Bowes%20Leasing%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EPitney%20Works%20Postage%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EB.Zee%20Brokerage%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESwift2Go%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFedEx%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EExtreme%20Reach%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EIron%20Mountain%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EBeck%20Taxi%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1724520%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I would like some guidance on how to enter invoice data in a spreadsheet.

Example has been copied below.

Some vendors only send an invoice once per month which would work perfectly with this type of layout. But some of the other vendors send multiple invoices per month. I would like some suggestion on how I can input multiple invoices into a chart while keeping all the other vendors' invoices in an organized manner. I would greatly appreciate the help.

 

Thank you.

 

VENDORInvoice #Date CodedDate Approved
Staples   
Hamster   
Imperial   
Barocco   
GFL   
CBSC Capital Inc.   
Canon   
Rogers   
Tyco   
National Leasing   
Pitney Bowes Leasing   
Pitney Works Postage   
B.Zee Brokerage   
Swift2Go   
FedEx   
Extreme Reach   
Iron Mountain   
Beck Taxi   
0 Replies