Create Lookup and Compare Excel Speadsheet

Completed Posted Mar 10, 2016 Paid on delivery
Completed 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.

Excel

Project ID: #9893760

About the project

38 proposals Remote project Active Mar 10, 2016

Awarded to:

prameswara

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

£20 GBP in 0 days
(390 Reviews)
7.4

38 freelancers are bidding on average £20 for this job

khushh07

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

£20 GBP in 1 day
(306 Reviews)
7.2
priyal1997

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

£50 GBP in 1 day
(188 Reviews)
6.8
rakeshwadhwani

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

£20 GBP in 1 day
(42 Reviews)
6.0
gokulanand

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

£25 GBP in 0 days
(115 Reviews)
6.1
vw7209238vw

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.

£13 GBP in 1 day
(56 Reviews)
6.0
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 55+ are complex VB/VBA projects, hence i can definitely deliv More

£15 GBP in 1 day
(77 Reviews)
6.0
macroPOL

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

£33 GBP in 3 days
(93 Reviews)
6.0
archanaoswal

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

£30 GBP in 1 day
(81 Reviews)
5.8
ashoksharma1

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

£18 GBP in 1 day
(7 Reviews)
5.2
mahisha123

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

£20 GBP in 1 day
(24 Reviews)
4.3
VinayOnTask

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

£19 GBP in 1 day
(9 Reviews)
4.1
mukes72

Hi i am interested to work for this project. i have good skills of using VLOOKUP() function. Please let me know interest. Mukesh

£13 GBP in 1 day
(9 Reviews)
4.1
tkannanid

Hi... I would like to work on this I can correct the formulas in excel file as you mentioned. thanks!!

£16 GBP in 1 day
(13 Reviews)
3.1
Rajendra1887

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.

£18 GBP in 1 day
(5 Reviews)
2.7
jpablocar

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

£15 GBP in 2 days
(4 Reviews)
2.0
BharatKoshti

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

£23 GBP in 1 day
(0 Reviews)
0.0
Tarun22sh

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.

£19 GBP in 1 day
(0 Reviews)
0.0
alam141184

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

£18 GBP in 1 day
(0 Reviews)
0.0
reshmadarisi

I'm ready to work on this project..

£15 GBP in 2 days
(0 Reviews)
0.0
adrianalvior

A proposal has not yet been provided

£18 GBP in 1 day
(0 Reviews)
0.0