Hello,
I have a table (see attached) that has the product name; revenue per month; start date when revenue begins and end date for when revenue stops. I would like to automate my sales table (providing monthly sales) so that the revenue starts on the date the table indicates and ends on the date the table indicates -- for each product.
Does anyone know how to do this? I attach a sample spreadsheet for reference.
Any help would be much appreciated.
Many thanks!
Bookmarks