M
Matt G.
I'm not sure if this is the right place to post this. I really
appreciate any
and all help from you experts!!
So here's the example: I have a mess of data sheets with sales numbers
from a lemonade stand. The sheets list the seller in rows (Johnny,
Bobby, Sue), and then have several columns for each seller listing what
each seller sold: lemonade, coke, pretzels...and how many of each of
those they sold. These sellers and their sales numbers are listed on
several worksheets in several workbooks from different weekends and
different seasons.
I need to combine all this information to make a production sheet for
each year and hopefully repeat for years to come.
One of the issues is combining duplicate entries: Rather than updating
his single row, Johnny made a new entry named "Johnny" every time he
worked a shift, so there are many "Johnny" rows that have small sales
numbers; these need to be combined and they exist on several different
workbooks and worksheets.
appreciate any
and all help from you experts!!
So here's the example: I have a mess of data sheets with sales numbers
from a lemonade stand. The sheets list the seller in rows (Johnny,
Bobby, Sue), and then have several columns for each seller listing what
each seller sold: lemonade, coke, pretzels...and how many of each of
those they sold. These sellers and their sales numbers are listed on
several worksheets in several workbooks from different weekends and
different seasons.
I need to combine all this information to make a production sheet for
each year and hopefully repeat for years to come.
One of the issues is combining duplicate entries: Rather than updating
his single row, Johnny made a new entry named "Johnny" every time he
worked a shift, so there are many "Johnny" rows that have small sales
numbers; these need to be combined and they exist on several different
workbooks and worksheets.