I have a Google Sheets file that I need a formula for.
Please see the attached images.
I need a formula that will copy the data on the sheet labelled "All Ongoing Cases" and put it on the correct sheet depending on the value in Column "I"
For example you can see that the data in Rows 3&6 has been copied to the "DIP ACCEPT" sheet because in Column I on the "All Ongoing Cases" sheet the data is "DIP ACCEPT".
Please only bid if you know how to do this.
Any questions please ask.
This is a very simple task for the right person so please make sure your bids reflect this.
T
Hello
I would be able to help you. This is quite simple fix once you’ve seen it once and can be used in multiple situations.
Please let me know if you would like me to explain and I will do so ASAP.
Kind regards
Steve
£20 GBP trong 1 ngày
5,0 (9 nhận xét)
4,3
4,3
18 freelancer chào giá trung bình £17 GBP cho công việc này
Hi there,
I have read your project description you want "Google Sheets Formula Help". I can definitely help you with your project. Once knock me so we can discuss more.
Thanks!
Hi, I went through your description and images. You need to copy entire row if the "I" column has "DIP ACCEPT" and this should be done through a formula. I will you give you a of formulas and you need to paste them A2 to I2 in "DIP ACCEPT" sheet. Then select these formulas and draw them down. The down rows will show the data is column "I" is equal to "DIP ACCEPT" and if not, the rows will be empty even though they are filled with formulas.
Greetings!
The best option for your requirement would be the use of macros. I can develop the macros that would automatically copy data to the appropriate sheets from the main "All Ongoing Cases" sheet.
Have a Great Weekend!
Srinivasan
I have excellent command on Google Sheets and know the formula to copy over data into respective fields based on the selected values. I have completed complex projects before. For instance
- Get live cyptocurrency data and create dashboard using coinmarket API
- Upload and Manage Videos in Vimeo using JSON API in google sheets
- Extract mails and attachments from gmail to google sheet and drive respectively
- Twitter functionality like retweet, auto-tweet, and so on
- Integrated Google Sheets, Forms and docs to create a dashboard and tracking system to track health data of individuals for a health care organization
You can see the reviews of the same in my profile
Have the formula in your Google Sheet customized while YOU FOCUS ON OTHER IMPORTANT MATTERS.
RELAXED! Entrust this to a professional that gives your interests utmost importance.
Hi, my name is Reggie, during my decade-long back office experience in full-time setting, I had been in situations that I had to delegate some urgent tasks to others because of more important matters at hand, only to find out at end, that the job I delegated was neither accomplished, turnaround on time nor as specified. FRUSTRATING! Isn’t it?
You may see some of my work here:
https://www.freelancer.com/u/IgeS
That experience has motivated me to have expertise in my craft so I can deliver to others what some couldn’t provide to me – ON TIME AND 99.99% ACCURATE TURNAROUND.
My service, not only SAVES YOU MONEY because of its competitive rate but also SAVES YOU TIME dealing with back jobs (if there’s any).
“nice guy to work with” - alexlexa
“Regginald did a superb job… He did the job quickly and it looked great. I'd use him again.” - hdwillis
“verygoodlogo” - hassnalajmi
LET’S WORK together NOW
Hi,
I hope my experience with Programming and Advanced Excel skills will help you consider my application. Let me know if you have questions
Thanks
Roel
Hi,
This sounds like an extremely easy task for me. I have done similar tasks many times. My bid is low just because I don't have any experience on this platform, but I have vast professional experience as a Data Analyst using mainly Excel to automate reports.
To do your task, I'll need to add 1 or 2 supporting column(s) on sheet 'All Ongoing Cases". Then I'll replicate formulas on the other sheets. In this way every time you add a new row on sheet 'All Ongoing Cases' or modify any of the existing information, data will be automatically added or updated on the respective sheet, depending on stage.
Hi,
I can perfectly do the project.
I have been working on such projects.
I deliver quality, commitment and make sure there is no Plagiarism.
I am familiar with all sorts of reference styles.
Please send me a message! and let's start working
Dear,
I majored in mechanics and have the qualification of Master of Mechanics.
And I am a talented Google Sheets expert.
I have 10 years of experience and a good history in Google Sheets.
I can do your task well and accurately.
I will wait for your good reply.
Thanks.
I will also teach you the right way to do this by yourself.
Hi,
I'm Oussama from morocco i'm an expert of excel and data entry, i can do this job for your with the correct way and I will also teach you the method so you can do this by yourself .
best regards