I was just wondering the cost and how long it might take to change a fairly simple macros formula. What the macros does now is it searches in file from a register to find a specific day's sales file, and the it imports the data into 3 excel sheets. Right now when you hit the button on the sales sheet it asks for the day of the week, then shift, then the date you're looking for. Then it imports the data into the 3 excel sheets - IM,IS,ID The IS, and the ID sheets should import 3 columns of data for each day. The IM sheet should just import the 1 column of data.
Here's what I need done-
When I hit the button-
Enter the date - example (06/30/2006)
When the date is entered it searches for the date in the dat file.
Once it finds the data, dump the appropiate data (IM select sheet) into the columns for the day#30.
So basically you would be taking out the asking for the day of the week, and the shift- and it would only ask for the date.
And Instead of having only 7 days- we would now have 31 days
I Don't need the sales sheet messed with at all, I am going to totally redo it. So basically all I need is to be able to just get the data by entering the date and be available to import the 31 files for the 31 days of a possible month into the 3 sheets, instead of just 7 days.
I'll attatch the excel sheets and the dat file need. I'm sure you can figure it out but in order to get the macros to work you will have to change the path for the dat file to where ever it is located on your computer. There are 2 places to change the path- it's about 1/2 the way down.