Hello Excel Whizzes,
I am self taught and love a challenge, but I think I've bitten off more than I can chew on this one.
I have a workbook that tracks all my craft sales, I'm not sure that it's laid out very well, but it's what I managed to put together myself. I have separate worksheets for Etsy, Facebook, Offline and website sales.
What I would like to do is have an Orders worksheet that will look at each of the above sheets and see where an order has been made (date entered) and not shipped and list all those items together with the dates they were ordered (chronologically if I'm not being presumptuous). Once I enter a shipping date on any of the four source worksheets, then the order would be removed from the Orders worksheet.
Does that make any sense?
Appreciating any help I can get on this one!
~kasper
I am self taught and love a challenge, but I think I've bitten off more than I can chew on this one.
I have a workbook that tracks all my craft sales, I'm not sure that it's laid out very well, but it's what I managed to put together myself. I have separate worksheets for Etsy, Facebook, Offline and website sales.
What I would like to do is have an Orders worksheet that will look at each of the above sheets and see where an order has been made (date entered) and not shipped and list all those items together with the dates they were ordered (chronologically if I'm not being presumptuous). Once I enter a shipping date on any of the four source worksheets, then the order would be removed from the Orders worksheet.
Does that make any sense?
Appreciating any help I can get on this one!
~kasper
