Google sheets
- or -
Post a project like this- Posted:
- Proposals: 16
- Remote
- #3114678
- Awarded
Description
If you are experts in google sheet, let me know and will share details with you.
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can you please share more details? Is it manually work or automation using formulas?
Welcome Translation Experts LTD30 Dec 2020I have a client who is running franchise website and is charging its chain of takeaways percentages for the sales and a fee for each card transactions.
He also charges the takeaways franchise fees and other fixed fees i.e., admin etc.
The client also pays for some of the services to third party for managing the orders, card fees etc.
When a customer places an order for food, they pay (if its a card payment) for the order online and the payments come to third party account and then to my client. My client deducts his fees and refund the rest to respected takeaways at the end of the week.
Based on the above the client wants have a sheet where one tab is filled, and the rest of the tabs filled in.
The client has a basic idea and have started this into google sheet but struggling to complete it.
There are VLOOKUP’s and some addition formulas but I am sure they can be enhanced i.e.; he would prefer the VLOOKUPs are are pointed at the name of the column rather than the number of columns this is if he ever delete or add any column the rest of the tabs are not affected.
The main problem is that when he enters the details in the main tab, the current tabs are filled with information okay, but for the following weeks he has to override this information to update the rest of the tabs or copy and paste the main tab, which is not what he wants.
Realistically, you may need a formula or two to achieve this, so shouldn’t be too long too complicated.
We can share the sheet with you to modify or you can create a new sheet, as long as it’s presentable and easy to understand.
If you can do this, lets discus how long this will take you to finish.
Please let me know.Abdul Rauf K.30 Dec 2020Thanks for the reply,
Can you please share the sheet? for more understanding. -
Hi,
Do you want to entry data Manually into google sheet from other sheets?
RegardsWelcome Translation Experts LTD30 Dec 2020One tab to be filled manually and the rest automatically
Qaiser D.30 Dec 2020Thanks for your reply.
can you share sample data?