Hi
I sell online and after every transaction that I do I put in excel the model number, selling price, the merchant fees, the cost, the profit margin and profit markup each in a separate cell, and In a separate page I have the totals of each day and also each weeks total
What I am looking to do is instead of putting in each transaction manually I want to put it in once and have it saved and when I paste in that model number excel will do the rest and updating all the data
I also would like to know how many pieces I sold each month, week or day for future reorder
I have attached a sample of the information I did manually
As you can see in the daily page in the excel it keeps records of every days transaction but I don’t want it I need to be able to erase the daily transaction without losing the data
I just need to know the totals of all the daily information
Hello sir, I am PREFERRED freelancer in excel and related skills on this forum with 200+ five star reviews. I have understood your requirement and I am ready to start the implementation immediately. Looking forward to discuss with you about the project.
Hello,
I'm assuming others have said this as well but your bid range is probably too high for this scope of project. I could do it for $125USD (can't be lower on Freelancer since the bottom of the range is $250) if you are willing to change a little how the data is structured. By changing the structure you will be able to easily use pivot tables to summarize and analyze the data in a wide variety of formats. I look forward to lending a hand, let me know if you have any questions.
Dear Sir, very first within short time .Experts and experiments team here auto also Manually Collect Data Entry Work. Please check my profile. I have done similar projects. I know some beater knowledge how to scraping website companies, Email, address, Person name, What you want So I can do the work acquired perfect in time. Please see first my work sample and if you like my sample then award me. Waiting for your reply. Thanks
Hi,
I'm web scraper and excel VBA developer
I will provide you scraper which will download all sku's with their pricing details in excel daily and create database for future reference
1) Sheet 1 - It will download all data from website
2) Sheet 2 - It will be database which will be updated daily after downloading data from website
3) Sheet 3 - This will be dashboard which will show you data Monthly, Weekly & Daily for all sku's
Thanks
Hi,
I would love to work on this project. I have 8 years of experience in MS-Excel.
Please contact with further details if interested.
Regards,
Raghav Bansal
Hello Sir, Would you like to discuss with me.....we negotiate about price and time.....I have much of experience for this project. my expertise lies in quality service and delivery on Time i guarantee you 100% satisfaction. kindly if you wants high quality work then as soon as possible contact me.
Plz See my profile..https://www.freelancer.com/u/rajafaizan.html# .
Thank u!
Dear, i can complete this task well in time with 100% accuracy. It need some formulas, an pivot and good representation of required information. Hope I 'll never disappoint you.
Hi sirs,
I am Kalpesh Parikh from India. I an engineer in Information Technology.I have been working on EXCEL projects since year and above.I understood your requirement and can assure you timely completion of work if given a chance.
Thank You!
Hi there- My name is imran.I am highly Expert in this field.
I'll provide you satisfaction. So your time and money will be
safe when you will award me project. take a look at my Freelancer Portfolio
HEllo sir
I have read the project and I think it would be nice to come out of excel for the job and we can create one simple form for you which would be stores on your pc only and connect to a database . That way hOh never ever lose data and you can view data or ads data only for particular day no problem
It would be easier and less cumbersome than excel
Please feel free to discuas if you have any doubts
Regards
Aditya
Navya Infosolutions
I am an Economics and Mathematics graduate, with 8 years experience in finance analysis and database programming. I am hardworking and i would be interested in a colaboration with you.
Thank you!
Sorina