Please see attachment with this job for further details and samples of the Excel sheets.
I have a few hundred Excel sheets that I want stored together and made so that I can retrieve the data through an Admin. These are customer figures done weekly. I will need to pull out data based on several parameters, customer name, date range etc.
Please feel free to ask me questions as well as sugest how you would want to store and save the data. Understand that I will need to add new data weekly.
## Deliverables
Attached are several files. We would be drawing the customer name and figure from the "Individuals" worksheet. Please remember that I will need to add a new excel file to this program each week.
Please message me with questions/suggestions.
Thanks
* * *This broadcast message was sent to all bidders on Sunday Feb 27, 2011 9:36:04 PM:
On the "individuals" page, all customer id's are in black bold font. Next to them is their balance for the week. I need the program to grab all customers and their figures for eack week and allow me to query that data.
* * *This broadcast message was sent to all bidders on Sunday Feb 27, 2011 10:13:00 PM:
I do not have MC Access, I have SQL
* * *This broadcast message was sent to all bidders on Monday Feb 28, 2011 11:35:32 AM:
I think I need to clear some things up. I am getting many suggestions as how the work can be done as well as what specifically I need to pull out of the Excel sheets. From the "Individuals" page on the Excel samples I provide, Column A and Column E are the customer names. Column B and F next to them are their figures for that week. These usernames are not static. Sometimes new customer names are added and some removed over time. Therefore user T16 may be at E 31 but 5 weeks later be at E33 because of a few new customer. The program needs to match up each customer from the different sheets to provide an accurate figure. T16 may be in 10 different spots overall in column E. I need to be sure the program knows that and can deal with it. If this can be done in one Master Sheet through Excel then I am ok with that. I want the easiest solution obviously that allows me to continually update and have it so your program is always providing the most up to date data.