Macro to protect sheetproiecte

...profesionalismul și fluiditatea muncii mele, am nevoie de un specialist bine versat în Foi de calcul Google. Sarcinile tale principale vor fi modificarea unui sheet deja functional, crearea de formule de înaltă funcționare și îmbunătățirea designului, respectând în același timp o estetică profesională și corporativă. Este imperios necesar ca datele sa fie protejate, se folosesc celule needitabile, se preiau date din sheet-uri diferite, se actualizeaza formule pe masura ce se introduc date Proiectul constă modificarea unui google sheet cu 4-5 sheet-uri dependente, astfel incat sa fie pregatit pentru un utilizator fara experienta in Google sheet. Responsabilitati cheie: - Reproiectarea foilor care reflectă un aspect profes...

Doresc pe cineva care stie sa modifice in Photoshop pozele facute unor bijuterii cu un aparat Sony Alpha 3 cu obiectiv Macro, asa incat sa arate la final ca cele de la Bijuteri Teilor. Va multmesc si astept un raspuns!

Se da urmatorul scenariu: Incazari in data de x,y sau z la locatia x, y sau z cu un echipaj variabil de 1, 2, 3 sau mai multi. Am nevoie sa extrag(copiez) informatia si sa o pun la fiecare om din echipaj in sheet separat. am incercat cu filtre si macro dar imi copiaza doar informatia de la prima coloana de echipaj. se poate cu alta formula sau cu VBA (cod)

Salut - m-ar interesa un Excel macro pentru a lua cateva fields (7 mai exact) dintr-un Excel si a le pune in unul csv-delimited. Sunt formate diferite si ordinea de fields nu va fi aceeasi in cele 2 documente. Ce ma intereseaza e script-ul in sine ca sa pot face eu conversia de cate ori am nevoie. Iti pot trimite samples cu cele 2 documente dar nu stiu cum aici

Avem nevoie de o conexiune API intre site facut pe o platforma Saas si Google Sheet. Site-ul pune la dispozitie toata documentatia pentru API si Webhook -uri de care ar fi nevoie pentru integrare. Am dori ca intermediar intre aceasta conexiune sa fie Zapier, dar nu este obligatoriu. Multumesc!

Dorim creerea unei ,,baze de date" de tip data entery form (google sheet). Urmatoru pas: pe baza informatiilor din aceasta baza de date, dorim sa generam si sa salvam sub forma pdf ordine de productie. Aceste ordine de productie v-or avea un layout predefinit, si tot o data trebuie sa contina coduri de bara.

Se dă un Google Sheet conținând 850 de site-uri. Fiecare site trebuie accesat, verificat că functioneaza si colectate 3-5 informatii punctuale din fiecare site, usor de accesat - care trebuie trecute inapoi in Google Sheet. Timp estimat: 3 min/site * 850 siteuri = ~ 42 ore

Cautam un developer care poate dezvolta un sistem web based de gestiune a clientilor. Functii esentiale: posibilitate de preluare date din Google Sheet; generare rapoarte si salvare in PDF si Excel generare contracte PDF dupa un model; gestiune clienti, documentele lor, situatie plati.

Buna ziua, Ma intereseaza o modalitate/aplicatie care sa extrag datele de contact, filtrate, postate pe site-urile de anunturi ( vezi ….) si sa le prelucrez in Google Sheet. Merci, G

O Aplicatie care sa: * foloseasca camera telefonului plus permita setarea dimensiunii: 10%, 20%--100% din dimensiunea pozei * faca poza inainte * permita salvarea cu numele pozei in google sheet/excel sheet in cell specificata * faca poza dupa * salveze numele pozei in google sheet in cell specificata * introduca date in coloanele specificate pe acceasi linie cu numele pozei inainte si dupa Salveze documentul la inchiderea aplicatiei

Colaborare de lunga durata pe email marketing pentru domenii precum: vanzari, ecommerce (fashion dar si alte industrii), ONG (proiect de informare nationala), iar pe viitor tot mai multe. Activitatiile ar fi ca urmatoarele: - crearea autoresponderelor - creare continut pentru email-uri - creare concept - structura - plan de emailuri - putina gr...Activitatiile ar fi ca urmatoarele: - crearea autoresponderelor - creare continut pentru email-uri - creare concept - structura - plan de emailuri - putina grafica - stabilire strategie cu echipa + lucrul in echipa si colaborarea cu ceilalti Cunostinte si experienta: - experienta de redactare pe acest tip de proiect - photoshop & Illustrator (basic) - mailchimp & wordpress & - Google G Suite (doc, sheet, forms, hangouts) -...

A4 Sheet Leaflets 2 Nos

In 12 fisiere lunare xls sunt sheeturi cu NIR-uri (in medie 30 sheet-ui a cate 6 produse) intrare produse comercializate. Fiecarui sheet ii corespunde un NIR cu produse de la un furnizor. Cele mai multe produse se repeta in anumite NIR-uri (sheet-uri) functie de furnizor. Este necesara introducerea intr-un soft de contabilitate a produselor ce apar in NIR-uri. Cele mai multe produse se repeta, dar daca apare unul nou acesta se introduce in softul contabil. La introducerea datelor este importanta doar valoarea de gestiune (de vanzare), cantitatea. Ex: pentru furnizorul A care poate avea 10 Nir-uri in fisierul xls, se va crea doar un nir global pentru toate nirurile din luna respectiva, cu produse repetitive. Pentru rapiditate si mai ales corectitudinea introducerii...

Avem trei useri care introduc datele in acelasi sheet Excel. Fiecare user introduce aproximativ 15-20 linii de informatie pentru fiecare proiect. Pentru fiecare proiect se face un fisier Excel separat. Se doreste dezvoltarea unei aplicatii care sa preia datele introduse de useri, si sa dezvolte grafice comparative. Bugetul este flexibil si poate fi crescut cu usurinta daca se observa rezultate multumitoare, avand in vedere ca se doreste obtinerea unei solutii customizate pentru societate.

I want to develop a management application for GSM service! -inputs and exits from service with issuance of documents (entry sheet, notice note, guarantee certificate, etc.) -posts of repair -localization of products in service or outsourcing -Guest of customers -stage store - product management - invoice issuance, proforma, house register, management report, non-fiscal receipt -marketing - sms, mail -all import / export data vcf. csv I also have some application models of this type that can be used as an example!

In 12 fisiere lunare xls sunt sheeturi cu NIR-uri (in medie 30 sheet-ui a cate 6 produse) intrare produse comercializate. Fiecarui sheet ii corespunde un NIR cu produse de la un furnizor. Cele mai multe produse se repeta in anumite NIR-uri (sheet-uri) functie de furnizor. Este necesara introducerea intr-un soft de contabilitate a produselor ce apar in NIR-uri. Cele mai multe produse se repeta, dar daca apare unul nou acesta se introduce in softul contabil. La introducerea datelor este importanta doar valoarea de gestiune (de vanzare), cantitatea. Ex: pentru furnizorul A care poate avea 10 Nir-uri in fisierul xls, se va crea doar un nir global pentru toate nirurile din luna respectiva, cu produse repetitive. Pentru rapiditate si mai ales corectitudinea introducerii...

In 12 fisiere lunare xls sunt sheeturi cu NIR-uri (in medie 30 sheet-ui a cate 6 produse) intrare produse comercializate. Fiecarui sheet ii corespunde un NIR cu produse de la un furnizor. Cele mai multe produse se repeta in anumite NIR-uri (sheet-uri) functie de furnizor. Este necesara introducerea intr-un soft de contabilitate a produselor ce apar in NIR-uri. Cele mai multe produse se repeta, dar daca apare unul nou acesta se introduce in softul contabil. La introducerea datelor este importanta doar valoarea de gestiune (de vanzare), cantitatea. Ex: pentru furnizorul A care poate avea 10 Nir-uri in fisierul xls, se va crea doar un nir global pentru toate nirurile din luna respectiva, cu produse repetitive. Pentru rapiditate si mai ales corectitudinea introducerii...

In 12 fisiere lunare xls sunt sheeturi cu NIR-uri (in medie 30 sheet-ui a cate 6 produse) intrare produse comercializate. Fiecarui sheet ii corespunde un NIR cu produse de la un furnizor. Cele mai multe produse se repeta in anumite NIR-uri (sheet-uri) functie de furnizor. Este necesara introducerea intr-un soft de contabilitate a produselor ce apar in NIR-uri. Cele mai multe produse se repeta, dar daca apare unul nou acesta se introduce in softul contabil. La introducerea datelor este importanta doar valoarea de gestiune (de vanzare), cantitatea. Ex: pentru furnizorul A care poate avea 10 Nir-uri in fisierul xls, se va crea doar un nir global pentru toate nirurile din luna respectiva, cu produse repetitive. Pentru rapiditate si mai ales corectitudinea introducerii...

Introducere si verificare transfer date dintr-o baza de date in mai multe sheet-uri dintr-un fisier xls. a.i sa nu apara greseli de calcule si toate campurile sa fie completate cu preturile unitare din baza. Totul se intampla in xls.

Actualizare/reparare sablon scriere tipizate in EXCEL folsind functii macro. Folosesc in prezent un tabel in care sunt introduse date, acesta contine functii macro si genereaza niste sabloane care apoi vin tiparite pe niste tipizate. Doresc repararea unor functii care nu mai genereaza anumite campuri si actualizarea intregului sistem prin care sa creasca usurinta de utilizare si functionalitatea.

Accounts, cut & Pasting, sum, Sheet setting

Ma intereseaza sa convertesc un cod VB in Java script, folosit de google. Acesta este unul mic care aduna datele din mai multe fisiere excel intr-unul singur. Doresc sa folosesc google docs si foloseste in loc de macro script-ul java.

Se da: Un fisier pe google drive - foaie de calcul - Am site-ul - cu pagina de produse - Se cere: Sincronizarea Sheet-urilor din google drive cu produsele de pe site Fiecare sheet din foaia de calcul contine cate un tabel pentru fiecare produs, shet-ul se va numi cu numele produsului respectiv Aceste tabele din foaia de calcul trebuie adaugate pe paginile de produse respective. Asa arata originalul - Acesta este site-ul care trebuie sincronizat - Aceasta este foaia de calcul -

The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strate...

For this project, I'm needing a well-rounded expert proficient in both Xano and Adalo platforms. Here are the specific functionalities to be focused on: Xano: - Database setup: We aim to have a foolproof data structure. - API endpoint creation: For smooth communication and data transfer. - User authentication: To protect user privacy and retain trustworthiness. - UI/UX: Must be user-friendly and intuitive. Adalo: - User interface design: Needs to be visually appealing and easy-to-use. - App navigation setup: To ensure a smooth user journey. - Data integration: Must ensure seamless data sharing and retrieval. Ideal freelancers are those who have proficient experience both in Xano and Adalo with prominent skills in database setup, API ...

I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus wil...upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth analysis so your attention t...

I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for K...

...thorough on-page SEO help. Keywords and metadata are required to be organized suitably. 2. Speeding Up: The site currently suffers from slow load times, which can negatively impact the user experience and SEO. 3. Increasing Security: Foremost, the site needs to be thoroughly secure to protect both admin and users. Additionally, I plan to expand the range on my site by including digital products. So, I need the designer to arrange these products on the site in an appealing way. Experience in developing online stores would be appreciated. Lastly, I need content (both text and media files) from another website to be moved to the new site. It's crucial that the layout and formatting remain consistent during the move. In su...

I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.

...main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are confident in your ability to handle complex tasks such as carrying over formulas efficiently, ...

As someone needing assistance with managing data in an Excel sheet, my ideal freelancer would be highly proficient in Excel and able to work accurately and efficiently. The role includes: - Adding new entries to the Excel sheet including the fields: Name, Email, and Phone number - Updating existing entries with the same data fields - Removing any outdated entries The data should be organized into separate columns for each field for straightforward visibility and access. Besides Excel work, this role involves effective email management related to this data. The ability to multitask while maintaining a sharp eye for detail will be vital for this project. Experience in data management and email handling will be advantageous.

I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .

I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.

As the project owner, I'm looking for a skilled professional to create detailed AutoCAD drawings for the electrical services of a building. The level of detail required is macro-level, focusing on building wiring. This project is for a college assignment. The project requires the preparation of the following AutoCAD drawings: Containment Drawing: Showcasing the paths and management of electrical conduits and other containment systems. All containment will be mounted on suspended Unistrut brackets, with a minimum of 800mm of space above the false ceiling. Single Line Schematic: A detailed schematic for the main distribution board, illustrating the arrangement and connections of switches, fuses, circuit breakers, and other electrical components. Layout Drawings: These ...

I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and h...

We need a simple marketing sheet to email potential customer about our company. I have attached a rough drawing of what we would like and some graphics to be used. Below is what text needs to be added. There is an image for paint2 that needs to be the background with an opacity so its not too loud. Final file should be Photoshop. Dimensions - 8.5x11 Text box 1 - Quality Repairs With Lifetime Warranty Text box 2 - Can Start Repairs Immediately Text box 3 - Locally Owned and Operated Text box 4 - Excellent Google Reviews Text box 5 - 2 Convenient Locations Location 1 540 Charles Hardy Parkway Dallas, GA 30157 770-966-2845 Location 2 1350 South Marietta Parkway Marietta, GA 30067 770-795-0323

...an experienced and reliable accountant to assist me with my accounting needs on a weekly basis. Key Responsibilities: - Bookkeeping: This includes keeping track of all financial transactions, such as purchases, sales, receipts, and payments. - Financial Statements Preparation: You'll be responsible for preparing my financial statements, including my balance sheet, income statement, and cash flow statement. - Tax Preparation: You should be well-versed in tax laws and regulations, and be able to prepare and file my taxes in a timely manner. Additional Details: - Accounting Software: I'm currently using QuickBooks. Proficiency in this software is required for this role. - Frequency: Your services will be needed weekly, so you must be able to commit ...

NEED URGENT AND WILL ...Key Responsibilities: - Develop backend systems to support our web application - Implement frontend interactions and interfaces with the backend Custom Feature Development: Details about this will only be revealed via direct messaging to protect the uniqueness of our project. However, a proven record in creating custom features will be highly considered. Design: There are no specific design requirements as it was not a priority for this project. However, a general sense of good design principles is still beneficial. Ideal Skills: - Laravel Framework expertise - Front-end and back-end Development - General understanding of UI/UX principles. Proven experience in handling similar projects is preferred, but not mandatory. I am looking forward ...

I'm in need of a professional who can design labels for me. I have the file in JPG and just needs to be copied. The labels are to be designed in two different sizes: - 96 x 50.8 Labels per Sheet - 10 Avery Template - L7113 Product Code: AV980019 - Single file - Size to be confirmed I prefer to receive the final design in HiRes PDF. The design should be minimalist and consist of only 2 colours. I do not have a specific color scheme or branding guidelines, so the designer has the flexibility to choose. Ideal skills: - Label design experience - Proficiency in graphic design - Ability to work within the specified dimensions - Creative thinking to achieve an appealing design with only 2 colours.

I am looking for a skilled Data Extraction/Lead Generation Specialist to assist us in compiling a list of project leads. A specific website containing the all the information we need will be provided. The task is about collecting the information and storing them into a structured Google Sheet or Excel spreadsheet of about 500-1000 entries. Please submit your proposal with your rate for the project.

I am looking for professional css, html, and js developer who is familiar with djan...professional css, html, and js developer who is familiar with django. Mostly interested in CSS. Knowlaage of SEO is required. I need to make my website look professional and add a few things to it such as map and others. I will give you my intial design and you need to work on it on your own. Intial design means htmls, css only but I will not provide any backend code. After you get done with the design you will remote into my machine and plug everything in so I can test it. Important: My remote computer is monitored from the server, any try to copy any code will be immediately blocked. Sorry I am trying to protect my work. If you have the skills and willin...

...a plus. 5. At least two of the KOLs must be males aged between 23 and 28. Information required when requesting quotes from KOLs: 1. Travel to Taipei for a 5-day, 4-night trip during August to September 2024. We are an agency and will provide flights and accommodation. 2. Posts on social media promoting Taipei tourism before and after the trip are required; inquire how many posts can be made. 3. At least one YouTube video needs to be posted after the event. 4. Please provide quote price in PHP or USD. Acceptance Documents: 1. Google Sheet, which we will provide in English for the freelancer to fill out. 2. The Sheet should include, but is not limited to: basic KOL introduction (name, brief description, reasons for choosing this KOL), cha...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I am creating a photo collage for an event I am hosting tonight. I will need to print this collage on an 8.5 x 11 inch sheet of paper. So it will have to fit inside a printer's borders. I will end this contest today as soon as I have a winning design I can use.

...It's a great opportunity to gain foundational knowledge in these exciting industries. Does this sound interesting to you? If you're interested, please respond to this message, and I will provide you with more detailed insights into this assignment. Task Bucket - Sprüth Mager ZFL research 1 Please research and identify additional companies in each category to expand our target company list to between 75 and 100. 2 If you discover any new and relevant categories during your research, please note them down for discussion in our next meeting. 3 For each company identified, please fill out the basic information including the headquarters' location, additional office locations (if any), and the number of employees. 4 Identify and docume...

I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via macro automation.

... I want users to be able to input a large list of company names and receive an output in a downloadable Excel sheet. Although I initially explored utilizing an [API from ](), I encountered difficulties with downloading data or obtaining an API key, possibly due to issues with their website. but was able to find [this csv file on kaggle]() containing information of companies from 1857-2020. My initial approach is to use appwrite for backend and react for frontend. populate the appwrite db with information from the csv file. then build the react frontend. however I can't help but wonder that there must be an easier way to do this. How would

I need a comprehensive, professional business plan tailored to the Transport industry. The main focus is to help me secure funding, hence it should be well-structured and detailed. Key elements to include: - Clear, succinct executive summary - Detailed market analysis of the transport industry, focusing on current trends and future projections - Competitor analysis with a clear understanding of how we differentiate - Financial projections including a profit and loss statement, balance sheet, and cash flow forecast. - A solid marketing plan that showcases our approach to acquiring and retaining customers - A SWOT analysis, identifying any potential risks and how we plan to mitigate them. I am seeking someone with previous experience in writing ...

Please quote for the production of a set of architectural construction drawings for four (4) new terrace houses using AutoCAD. Refer to the attached schedule of drawings that need to be completed. Please find attached: - an example of the level of drawings and detailing that is required - our current set of plans, elevations + handmade sections. Once the job is assigned, further details, architectural drawings + structural drawings will be provided to assist. Payments will be processed over 4 milestones with a submission and review at each stage: Milestone 1 – 40% of the package: Details wall, roof, windows, internal scale 1:10 Sections scale1:50 sections Milestone 2 – 65% of the package: w...

I'm looking for help in combining multiple Excel slicers into one for our data analysis needs. The requirement is, I want to use same Slicer for multiple data. Detailed description is as follows: I have a accounting sheet. Where in one separate sheet I have captured Incomes along with the date and amount and other sheet I have put Expenses along with Date and amount. Now in summary sheet I am using Income pivot table, where I am using Slicer on Date (Merged for Months and Years). I want the same slicer to be used for Expense pivots as well. The ideal freelancer for this job should be proficient in: - Excel - Slicers and PivotTables - User experience design - Data analysis techniques Your input and expertise in this project can help stre...