I need you to fill in a spreadsheet with data. I have a excel file which is an address book for my client.
It has columns such as Store Number, Address, City, State, Phone Number
I want to be able to create new spreadsheets using that address file like a data base
So when I create a new spreadsheet. I enter Store Number and it auto populates all their information for that store.
So let’s say the address book has 200 stores
Now I want to create a new spreadsheet. I am only going to be shipping to 18 of the 200 stores.
I want to just quickly enter Store Number. Hit return and it fills all their info in.
Enter another and it fills it all in.
On the new spreadsheet after it auto populates. I would manually enter in a dollar amount for each store for the total price I am shipping them.
After I enter the price for each store on the new spreadsheet.
I want the report to show total amount shipping to all the stores
I want a report that totals up the amount for each State.
So I can see how much Value In goods is going to each state for tax purposes.
So would have 50 cells. One for each state. The total of each state would go in the appropriate cell
36 freelancers are bidding on average $120 for this job
Greeting, I have understood your data entry task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel
DEAR SIR / MAM , HI I AM VINNY FROM SPAIN . AS PER YOUR JOB WE HAVE THREE PEOPLE TEAM HERE IN OUR OFFICE WE ALL HAVE MORE THAN 10 YEARS EXPERIENCE M .OFFICE
I could give you two options: 1. I could make this project in vba or... 2. I could make this project in spreadsheets. Please let me show you my experience and acknowledgements in excel