Create VLookup excel worksheet for gym member tracking

Let me create a dashboard for you that will have necessary information selectable in a dynamic way (say you can select Gold Members and it gives you checkins, with top 10 clubs list and so on). I am working as business process improvement professional with extensive knowledge in Excel and Processes streamlining. I managed Excel improvements materials for such companies as AOL, DELL and L’Oreal etc. I will provide you with a high quality and time committed service with outcomes match your needs and look professional and attractive. I can provide you with Excel that will automate majority of these tasks .

Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project. Thanks, Jay

Hi there! I'm an excel expert and I would like to help you with your project. Please consider my proposal and contact me to discuss further details. Regards.

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).

Hello! Please share further details of the project and get Vlookup help at affordable price. Thanks

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets and formulas. I can easily solve your project. Check my reviews and chat with me. greetings

Hi: I have few questions: What format will the data be in (Excel file or text file)? Will the raw data be cumulative (all checkins) or periodic (only for a particular period)? Do you want a summary sheet as the final output where you can see the member name, number of check-ins and his status? Please note that I have 100% completion rate and 5-star feedback on projects. Please connect with me to discuss more.

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav

I am an ACCA(UK) professioanal , APA and Mcom finance. Your project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am fully competent in doing said assignment/job, . i have more than 8 years of experience in advanced excel hire me at fordable cost with best results, readily available for said task........ regards javed

Dear Sir/Madam, I'm happy to help you on this task. I am an expert in advanced excel features and have already developed lots of excel based tracking models for various businesses. If you are comfortable with all above along with my ratings and reliability, please send me the information to confirm. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal

Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work. Rgds Rohit Pithisaria

Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that I have not disappointed ANYONE TILL date. I have done more than 130 projects. In fact my reviews will speak for myself... One thing I can assure you that if you work with me once, you will always work with me for these kind of projects :) Please note that there are lot of time wasters here. If you do plan to select me then I would request you to please explain or give me a sample so that I can give you a demo which will ensure that your time and my time is not wasted.. :) Hope to work with you. Regards Sid

Hello, I'm Excel and VBA programmer with over 5 year of experience. I have written many different applications for Excel in recent years. I am confident that I can perform this task. I am currently working in a large trading company in Europe. Thank you very much Jan Krzyzak

I am willing to discuss further about the project specifications and deliver the same to your needs .

I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. If you send me a sample file, I'm ready to create a free draft pilot for you. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards

Hello, Not knowing the exact structure of the data makes it difficult to outline my proposed solution in detail but based on the brief I would envision something along the lines of the following: 1) Each branch location would have a spreadsheet tool where they collect their user information on a daily basis. 2) Within this spreadsheet there would be code that would enable the user of the branch location to press a button and export their data and send via an Outlook email to a defined email address. 3) There would be a separate Master tool that would allow a user to press a button and select the file they would like to import and the code would import that data into predefined areas in the workbook that have reporting tied to it. Some things to keep in mind would be the users' availability to Outlook as well as what version of Excel is being used.

Hi, We are a group of analysts working in excel based tool and dashboard design for last 10 years. We can very well do the job. Here is what we can provide based on your requirements. 1. An Excel based worksheet which will have the option to take information from other work sheets from same workbook, collate and will process the information based on logics, and finally will produce the report you want. 2. As a pre-requisit you need to however bring all the input sheets ( raw data from managers) into the interface workbookmanually At this tage if you can provide us with a sample raw data and the calculation details you want,we would send a detailed design plan and then you can decide on the bid. Kindly message for any further details. Regards, Pal

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio images to see few pieces of my kind of work. I am a professional and I can do a very good job. Also fast and accurate. Do not hesitate to contact me for further details. Kind Regards, Jon

Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office. I will submit a more detailed proposal after having a look at the data.

I have gone through your requirements as specified in the project description and would like to confirm my ability and availability to assist you in this assignment. I am an excel professional with a proven record of preparing excel project per customer's specifications. My performance on previous such projects can be gauged from customer's testimonials on my profile page. I am looking forward to hearing back from you on this! Kindly send me a PM in case you have any questions/concerns. ============================================================================= Brief info About me ------>>>>> I am a multi-faceted professional having 4 years of experience, starting from working as a research assistant at Georgia Tech, Logistics Analyst at Nokia, Sales & Operations Manager at Sandisk to starting my own company which provides consulting/freelancer services. I have a Masters in Supply Chain Management (IE) from Georgia Tech.

I have 20+ years of experience of Spreadsheet modelling using Excel & VBA I have developed Retirement Fund Application that serves 7,500 employees of a company. This application handles individual accounts, operational matters, cheque printing and complete accounting. Understanding on your task: 1) Each manager will submit data , either directly or through email 2) That data will be merged with old data 3) Customers will analysed and they will be oferred rewards as per their commitment with GYM What the solution will look like: 1) Standard format file , that each Manager will send through email and saved in a specific folder 2) A main program will consolidate data from different Managers 3) identify customers eligible for certain compensation 4) Letter/email to respective customer for his status 5) Record of benefits availed by customers 6) Analysis / Dashboard reports on benefits availed and benefits lapsed.