Google Sheets ****Script Editor***** for formatting
$10-30 USD
Closed
Posted over 3 years ago
$10-30 USD
Paid on delivery
if you do not know how to use script editor in great detail, do not respond to this ad.
Requirement 1) I have 50 tabs in one worksheet, i need the script to create a separate worksheet for each tab, each worksheet named by the tab name
Requirement 2) I need you to format with: column width, row height, font family, font weight, font size, font color, background color, merging, centering text - for my rows -- but this isn't ''every row'' or ''every other row'', for example, ''every 5th row, background color black'', then ''every 5th row, the 3rd cell, font family xzy'' .. that's just an example but that's what im looking for.
I have absolutely no coding skills, and i have been able to achieve some of the things i need, and ive been trying to study coding for months - i am hiring someone becuase i have 20 projects to complete, and becuase i'm not experienced , i don't have the time to do it.
i know that this will take you 30 minutes at the maximum. so please don't ask me ''what is your budget'', and please don't tell me it will take 3 days. i have found there are some amazing people on this website, but also a lot of people that believe scamming and being dishonest is ok. well, my advice: if you're an honest person, you make more money long term. so don't try to get an extra 20 dollars from a deal when the person accepts it, they know you are not honest, and they never hire you again.
i have many projects i need now. so if i find someone that is honest, and that genuinely cares and wants the outcome to be beautiful, you will receive a lot of work from me.
thank you.
Your requirements seems basic enough so I can do it today itself in few hours. I had used Google Scripts for an automation task in college and am quite well-versed in Javascript so I am confident that I could complete your task. I have even written a script very similar to your first requirement where I created new tabs based on the column names in one tab. You just need different worksheet based on different tabs. Would love to chat more if you're interested. Thanks.
Experience in google formulas, google scripts, google webscraping conditional formatting, pivot tables & charts. I have experience in automation tools & templates. Link sheets, distribute data or converge data from multiple sheets.
Experience in Accounts, Formulas, Stocks, Performance and statistics.
HI There, I understand the task. I can complete the task according to your requirement within a short time. Please, share your files to start the task. Lets discuss in chat.
Thanks
Hello,
I have understand your requirements and I am not the guy that is here to scammer, I am here for serious work.
I can handle this project, if in doubt, I can give you sample before you hire me. You need not to worry about your coding skill, I can make the project easy for you and also form a long term relationship.
I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship.
Please, let me know what is needed to secure this bid!
Thank you for your consideration. Abdulmalik
I am a professional computer operator developer and I have been working experienc. I had completed computer science and engineering courses.
So I can do this correctly, honestly and completely. I have well knowledge about computer science.
im looking to work with you in a long term. this how the finish product will be : each tab will be created as a new worksheet along with all the formatting and it will be placed in the designated folder. And you can choose which tab to be generate into a new spreadsheet or bulk process.