Hey guys, I figured I would ask here and see if someone can help me.
Heres a little bit of what I need help with.
I have an excel database that has store names, address, and what brands they purchase from us. It gets into detail every month in a diffrent worksheet as to how many exactly did they buy, 1 or 2 cases etc..
At the end of the month I get another excel worksheet from our distrubutor saying who bought what and how many. This info needs to be entered into my excel database. What I usally do is just copy and paste, copy and paste. Its very time consuming considering there might be as many as 900+ sales in a month. There HAS to be a simple way to get this done, the problem is sometimes there are new accounts in the list that I have to make a new entry into my database.
I know it seems complicated but its really not, if someone thinks they might be able to help me out, PM me, I have AIM and MSN where I can explain a little better.
Thanks in advance guys!