Is it possible to maintain One Master worksheet and upon specific entries, automatically enter data (row) into the appropriate worksheet without using macros and vba? Our company security will not allow me to save a document with macro/vba.
I would like to be able to maintain only one master worksheet which includes invoice number, date, vendor, etc. When a specific vendor invoice is entered, add entry to Vendor Worksheet, ie. Vehicle maintenance (1 worksheet), Fuel (1 worksheet), etc.
Thank you very much for any assistance/suggestions you may offer.
UPDATE: Example attached
My hope is to enter each of my invoices with all pertinent information into one Master Data section.
1) If vendor matches criteria (Fleet,Fuel,Temp) I will automatically complete additional cells at the far right of worksheet (Master)
2) Once data is entered, the information will be added automatically to the appropriate worksheet tabs, as well.
3) I'll maintain one master worksheet with all data but it will also be available on their own worksheet.
I am most likely making this more complicated than it should be. The fact is...I'm spending valuable time entering this data on multiple spreadsheets when I feel it's totally unnecessary.
I appreciate any assistance that may be offered and your candor if I'm backwards in my "thought" process.
Thank you.
Bookmarks