Create Lookup and Compare Excel Speadsheet
£10-20 GBP
Paid on delivery
SUMMARY
• We need a spreadsheet with 3 sheets inside
• 2 of these sheets will have sales data inputted by ourselves and the main sheet would be a summary.
• Columns we need included are listed below
- Title
- SKU
- Sessions
- Page Views
- Buy Box Percentage
- Units Ordered
- Unit Session Percentage
- Ordered Product Sales
- Total Order Items
• Our data will be sorted in ascending order by “SKU”
• After the first two sheets are inputted with our data, our third sheet will compare the data.
• We’d like the difference between Sheet 1 and Sheet 2 to be shown for each of the columns listed in bullet point 3 which is shown in our example on the next page.
• The difference between Sheet 1 and Sheet 2 will be shown with a + or - in front of the figure to signify whether there was an increase or decrease.
• If there’s an increase, the cell will be highlighted in green.
• If there’s a decrease, the cell will be highlighted in red.
• On top of this, on the columns “Sessions”, “Page Views”, “Units Ordered”, “Ordered Product Sales” and “Total Order Items” a percentage figure will also need to be calculated and shown in the same column in brackets, this is shown in our example on the next page.
Project ID: #9893760
About the project
Awarded to:
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel Sir, inlcude make vlookup formula Sir :) please give me a chance for doing your job and im able to start doing your job right now :) T More
38 freelancers are bidding on average £20 for this job
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
Dear Sir/Madam, I’m happy to help you on this task. I’ve read your brief and happy to discuss the project in more detailed. I am highly qualified for this project and have already done lots of similar excel data sorti More
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and More
Hello I can get you this task done in the next 2 to 4 hours using VBA Macro. Also please provide me a sample spread sheet with the product details if you are interested. Thanks
Hi, please send your ffiles, I have all skills needed to do that. You can see my profile and comments from my clients as a reference.
Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on projects
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a reservation system - Build a complex shift allowance c More
Dear friend I can help you with in making excel spreadsheet of your requirement. I have done many tasks like that. In addition, I can write macros to automate some operation system routines for Windows and Unix. More
Hi, I’ve gone through your requirement; I am very much interested to work with you on this project. I do have expertise in the specified area. I can start the project right away and can complete as soon as possible More
Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, dat More
Hi i am interested to work for this project. i have good skills of using VLOOKUP() function. Please let me know interest. Mukesh
Hi... I would like to work on this I can correct the formulas in excel file as you mentioned. thanks!!
Hello, How are you? I am good at Excel and can do this task for you. Please let me know if we can discuss regarding the same.
I am proficient in excel and have experience in VBA, you would get your job in a short period of time, with any corrections you may want
Hello Sir , You are at the right platform for your Project I am running my business in the name of BKOS Business Solutions , providing the Consultancy for Accounts , Audit , Financial Mgt , Human Resources & Rec More
I worked on excel reports most of the time so I am pretty comfortable with your requirement. I have to compare two sheet and show results with conditional formatting. I can do it in a day.
Dear Hiring Manager, I will create an excel spreadsheet in which 2 sheets are input by your data and 3rd will be the comparison of these two. I will display all factors which we will have to compare on the sheet. More