I'm looking for an Excel expert to do a few things to my spreadsheet, and to explain to me how you did it (so I can learn).
Note: I use Excel for Mac (version 16.6.7)
I have a large Excel file (~7 mbs, ~74,000 rows). The file contains many different web page URLs, along with SEO metrics (e.g. domain rating, organic traffic, etc) for each URL.
I need help doing these three things with the file:
1) Filtering the master sheet by criteria for two columns, then automatically transferring the filtered data into a second (new) sheet
2) From the second sheet, automatically copying and pasting rows that contain specific data (unique instances of URLs) into another (third) sheet
3) In the third sheet, automatically removing characters from cells (specifically, removing the web page extension from each URL, so only the root domain URL is left).
I would like the freelancer I hire to do two things: (1) do the work in my Excel file (if that would include writing macros to do the work, that would be fine); and (2) tell me (or show me by recording a screencast) how you did the work, so I can do it myself on other sheets.
I can share the spreadsheet and a quick video showing exactly what I want done. PM me if you're interested.
I'm willing to pay a good fee to an Excel expert who can get this done AND explain to me how they did it.
Interested bidders MUST briefly explain what makes them an Excel expert.
33 фрилансеров(-а) в среднем готовы выполнить эту работу за $131
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Sure. Willing to take up your project. Thank you, Regards.
Hi, I'm an expert in Data Entry and excel. I understood your all requirements. I have done many projects like this. I'm ready to start now. Regards, Noor
Hello Sir I have a team. My team is always active for work. If you give me a chance and give direction for the job, I will do this. Regard's Blood Freelancer Team
Available Immediately | MS Excel and VBA Expert | Assured quality of the work and timed delivery | You can check my jobs history for the same. Looking forward for your message.