Hi everyone. I need help with my excel table. I've created a financials workbook for my business and need help keeping it in order. I want to have the data from the "Purchase Report" auto populate to the appropriate tab based on a criteria. I have a tab for inventory and one for other. I want to set it up so when i add a purchase on the main report, it will auto generate it to the proper tab with a line between each auto entry so i can add in the details about the entry.
Will it screw up the formula if i insert rows between the formulas on the "inventory and other" tabs? So i can add the itemized data per entry.
Is there a will to have it pull multiple lines of data as well?
I would like to have it pull the "date, receipt number, supplier, and total"
any help is appreciated
