Vba excel insert sheet仕事
System Overview The System is a comprehensive data collection and analytics platform built around EasyFor...supports: API uploads to connect external websites. Live database connections for seamless data transfer. File uploads (CSV, Excel, SQL, WHONET/FTP) with field mapping. Dashboard for monitoring connection status and data transmission. DASHBOARD – A visual analytics platform for managing and analyzing collected data. Features include: Sector & Subcategory Management – Organize data by category. Indicators & Custom Scripts – Define custom calculations and display results in charts or tables. Advanced Form Builder – Supports Skip Logic & Repeatable Elements for dynamic form behavior. Real-Time Alerts & Reports – Automated notificat...
I need 4 modules of an online dental educational course converted into separate, professionally designed PDF files. The purpose of these files is primarily for information dissemination. The ideal freelancer should be able to: - Use the attached Excel sheet that outlines the course agenda as a guide for creating the PDFs. - Model the design on the attached previous PDF, using the same colours and themes. - Incorporate specific design elements such as Graphics/Illustrations and Branding elements (logos, colours). - Convey a Professional and formal tone throughout the designs. Skills and experience in graphic design, branding and creating educational materials are essential.
...deadlines. So my budget is $5/video (5-20min long), $5/5 short 2-3 min videos,, we will need more than 500 such a video work, so I hope you can be working for a long-term with us. Budget is not negotiable, until we get enough customers to our website and/or monetized our YouTube channel by that mean I will need at least 1M subs and/or 1M views in each of the video ---- Please check in this google sheet, if you have no past work review, please send me draft version of unmade video edited video according to the step in tab 'Standard Guideline', if you can do it accordingly, then I will send award to you for the rest of the other videos : ;
I'm looking for a professional to help enhance my e-shop. The task involves updating various sections of the website, adding physical products (specifically herbs and tinctures), and ensuring all links work correctly. Key Responsibilities: - Update the Homepage, Product pages, and About Us page - Add new physical products (herbs and tinctures) - Insert appropriate pictures and accurate product descriptions - Organize the e-shop for better navigation - Remove broken links and non-functional pages Ideal Skills and Experience: - Prior experience with e-commerce platforms - Strong attention to detail - Basic understanding of product categorization - Proficiency in website management and troubleshooting - Good communication skills The project needs to be completed in less than 1 ...
tôi cần lập trình file nhập liệu ex cho tổ chức, chủ yếu là sổ sách thu chi của tổ chức, và xuất báo cáo trực qua bằng đồ thị để dẽ dàng quản lý hơn
I'm looking for an Excel expert to help me set up a task tracking sheet in Excel 2010. The sheet will be used to track team assignments and should include color coding based on team members. Ideal candidates will have: - Proficiency in Excel 2010 - Experience with creating task tracking systems - Ability to work with Arabic language settings - Creativity in color coding systems The final product should be a functional and visually clear task tracker.
I'm looking for a professional to convert my Microsoft Excel project schedule into MS Project. The excel schedule has 675 rows, including headers. The purpose of this conversion is to enable better tracking of the project. 500 rows are the same 4 or 5 tasks with a different identifier and schedule start/end. Not entering any resources or predecessor or successor but need the columns available for me to add later. Looking to have a 2-5 hour turn around. Details: - The current Excel schedule is moderate, repetitive task structure - This is a one-time conversion, I don't need to update the schedule in MS Project regularly. Ideal Skills: - Proficiency in Microsoft Excel and MS Project. - Attention to detail to ensure all tasks and dependencies are accur...
De un archivo pdf de buena calidad con 10 - 14 hojas que este en una carpeta llamada pdf y se tiene que extraer solo las tablas y pasarlas a otra carpeta llamada procesadas a un archivo Excel con el nombre de la primera hoja 1.- Scripts en Python pdf a excel 2.- pdf en la carpeta llamada pdf 3.- extraer las tablas y hacer un archivo Excel con nombre de la primera hoja del pdf en la carpeta procesadas Si requieres el archivo para poder ver mejor el detalle mándame un mensaje. Puede ser otro lenguaje de programación y también Google sheets
I need a Google Sheet set up with drop down lists that are based on a Xero template. The sheet needs drop down boxes that automatically select other information for other columns that usually stays the same. Requirements: - Use of existing data from Xero that includes products and prices. - Creation of drop-down lists that include product details, service details and expense categories. - Auto-filling of columns based on drop-down selections, specifically pricing details and product descriptions. - No need for calculations or formulas to be triggered by drop-down selections, only static data. Ideal Skills and Experience: - Proficient in Google Sheets and familiar with Xero. - Experience in creating automated spreadsheets with drop down lists and static data. - Attention to ...
I have an Excel file containing 248 medical records. I need a freelancer to compute and add three new columns: BMI, BMI Category, and bp_category (blood pressure). Your Responsibilities: - Use the existing weight and height data to calculate BMI. - Research and apply the standard BMI categories. - Utilize the systolic and diastolic blood pressure data to create the bp_category. - Ensure the output file is in Excel (.xlsx) format. Ideal Skills and Experience: - Proficiency in Excel. - Understanding of health metrics and categories. - Experience with data analysis. - Ability to deliver high-quality work promptly. I am looking for a quick turnaround on this task. The successful completion of this project could lead to further opportunities.
De un archivo pdf de buena calidad con 10 - 14 hojas que este en una carpeta llamada pdf y se tiene que extraer solo las tablas y pasarlas a otra carpeta llamada procesadas a un archivo Excel con el nombre de la primera hoja 1.- Scripts en Python pdf a excel 2.- pdf en la carpeta llamada pdf 3.- extraer las tablas y hacer un archivo Excel con nombre de la primera hoja del pdf en la carpeta procesadas Si requieres el archivo para poder ver mejor el detalle mándame un mensaje. Puede ser otro lenguaje de programación y también Google sheets
I need a Python script that can transform data from one Excel sheet with multiple rows into another Excel sheet. The output should create one individual sheet per row. There is a certain format in the output excel sheet. Key requirements: - The ideal candidate should have extensive experience with Python and Excel. - Knowledge of data manipulation and organization is crucial. - able to work immediately with tight deadline
I'm looking for a skilled professional to design a Gable roof for my residential home. The selected material for the roof is metal sheets, so experience with this material is a plus. Key Requirements: - Expertise in designing Gable roofs - Experience with metal sheet roofing - Ability to design for residential scale - Understanding of structural integrity and aesthetics Please provide examples of similar projects you've completed in the past.
...introduction clips to hook the user, check the note F below. Ex: 5 """Find the most suitable vibe trending copy righted free music in youtube/google, if you still can not, then copy paste the transcript from the Google Sheet, then ask chatgpt as follow ""According to the video transcript below, what is the best fit trending free copy righted music in capcut ?"", then paste the transcript below it." 6 For short videos, you must insert the thumbnail in the video for at least 1s somewhere you think most suitable --------- Budget is $5 for 5 short videos with length 2mins videos and $5 for 1 long videos with length 5-20 min videos. But then if You have no review here, you need to make one sample of the short video or send
I need a freelancer to create 5 reports in an MS Access Database as per pdf and implement a data entry option as per excel. database, pdf and excel sheets are attached
I am seeking a data expert with strong experience in exploratory data analysis (EDA) and predictive modelling. The primary goal of this project is to identify key patterns in my data. Ideal Skills: - Expertise in EDA and predictive modelling - Proficiency with data analysis software (e.g., Python, R, Excel) - Strong statistical background - Excellent problem-solving skills - Ability to interpret complex data sets Please note that some details about the data types and visualization methods have not been determined yet. Flexibility and adaptability will be key in this project.
I have a corporate profile document for an incubator center that needs to be filled out. The document is in both Arabic and English. The task involves: - Filling out sections related to financial projections, balance sheet, and marketing plan - Completing both the English and Arabic versions, although assistance with just the English version is acceptable if you can do it professionally. - Using a provided template to ensure consistency and professionalism. Please note: - The document requires in-depth financial information, so expertise in finance is essential. - Experience in completing similar corporate documents is a must; bids from freelancers without this background will not be considered. - Understanding of both the Arabic and English versions of the document will be advan...
MAGENTO 2 EXPERT MAGENTO 2 ATTRIBUTES EXPERT MAGENTO 2 "ATTRIBUTE SET" EXPERT MAGENTO 2 PRICE RULE EXPERT PRODUCTS IMPORT EXPERT EXCEL EXPERT Please do not bid if you're not a genuine expert that can import thousands of products every week. Tasks and Responsibilities: - Be super organized. We will be sending you documents: please sort them in a way that will make it easy for you to revert to these documents whenever needed. We use Office 365 / OneDrive to organize our documents. - You will be importing using excel or CSV or, if you're a true expert: you may even use XML. You will need to maintain these files. If we find out that an attribute was not defined, we want to make sure it will be easy for you to add the attribute and reimport the pro...
Looking for Virtual Assistants who has the following skills: - Good with excel - High attention to details - Is smart & fast in their work - Self learner & able to follow user guides - Meet deadlines - Proactive & willing to go the extra mile - Freshers can also apply Job Responsibility: - Data Entry & basic admin tasks - Do some research jobs related to products and purchase - Online search for suppliers/ whole sellers/ manufacturer who can give quality products at a very competitive price If you are interested, then Please carefully review the provided information and add the word "Rainbow" at the beginning of your cover letter. Also, share your response to the below questions. 1) What commitments do you have right now? Are you employed? Student? Freela...
I'm looking for a professional who can help me create a YouTube ad from an original video that I will provide. The ad's primary goal is to gain subscribers to my website. Key requirements: - Insert a clear, compelling "Call to Action" encouraging viewers to click a link after watching the ad. - Ensure the tone of the ad is friendly and casual, resonating with a broad audience. Ideal skills: - Video editing and production - Script writing - Understanding of YouTube's platform and audience - Ability to convey a specific tone through video editing.
I'm seeking a freelancer to design a Google Sheet that serves as a weekly time tracker and project manager. Key Features: - A dedicated tab listing tasks and projects, arranged by priority. - A time tracking tab where team members can log their hours, tasks, and project details. - A pie chart summarizing how work hours are allocated. - The ability to add a new week seamlessly. Essential Information on Time Tracking Tab: - Date and hours worked - Task description Ideal Skills: - Proficient in Google Sheets - Experience in project management tools - Ability to create visually appealing and functional spreadsheets
...issues before they affect users. Key Requirements: - Proficiency in Java and Selenium is mandatory - Prior experience in performing regression tests - Capability to conduct tests on Chrome browser - Understanding of data creation through API - Proficient in data writing and extraction from excel/CSV - Ability to utilize Data Provider - Familiarity with Page Object Model - Familiarity with version control systems like Git Testing Focus: - Functional tests - UI tests Data Interaction: - API responses - Excel/CSV files The ideal candidate will be detail-oriented, capable of developing comprehensive test cases, and able to communicate findings clearly and effectively. The regression testing needs to be completed within 1 week. Automated reports post-testing: Already exte...
I'm in need...designed to have the following features: - Integration with an email marketing platform to engage with potential customers and keep them updated on new products and promotions. Additionally, I require assistance with loading data from an Excel spreadsheet, which will contain product details, pricing and other relevant information. Ideal candidates for this project should have: - Extensive experience with Shopify and e-commerce website development. - Proven track record in creating platforms for digital product sales. - Proficiency in data migration from Excel to a web platform. - Knowledge and experience in integrating email marketing tools into e-commerce sites. Please bid if you are capable of delivering a high-quality, user-friendly website tailored...
I'm looking for a modern-styled real estate sign and logo. The color scheme should predominantly be blue, with some red and white incorporated. The design should include my company's tagline or slogan, as well as contact information. Telephone number of 10 digits. I prefer space on signboards to insert a Qr code sticker for individual properties Ideal skills for this project: - Graphic Design - Branding - Signage Design - Logo Design Experience in creating modern, minimalist designs is highly desirable. Please provide a portfolio of relevant work when bidding.
...and defence organizations, industrial and manufacturing companies, and retail and wholesale businesses. Collect key company details, including business name, industry category, business size, location, business website, key contact person, phone number and email, current container supplier if known, and potential container needs such as hire, sales, or modifications. Data Format: Preferably in Excel. Data Sources: Online research using Google, LinkedIn, and business directories, as well as industry databases if accessible. Ideal Freelancer: Experience in lead generation, data scraping, or business research. Strong attention to detail and ability to verify accurate contact information. Ability to organize data clearly and logically. This will be an ongoing project, so there is...
...neutral tones to keep the flyer visually appealing yet minimalist. Focus strictly on product details and contact information. Focus solely on product details and contact information without any extra taglines. Include "different glass insert designs" to enhance the flyer. "Call/Text us for a consultation and many more designs!" For more details or to place an order, call or text us! Rectangular sections to enhance the visual elements of the flyer. Primary call-to-action: Book a consultation to see more designs! I have a pdf catalogue where the original insert designs can be taken from, pdf is 102MB, cant upload it here. Will share with designer. I have a layout in mind which I have also attached. It is just off the cuff to get my vision out. The colour...
I'm seeking a professional who can develop a database that...develop a database that automates the creation of quotations. The database will need to include product type, description, purchase cost, and selling cost. What I can provide: - My existing purchase invoices, all in Excel. This data will need to be extracted and included within the database. - The database should be set up to allow for the automated import of new product data from Excel. What the automated quotations should include: - Product details - Total cost - Client information Ideal skills for this project include: - Expertise in database creation - Proficiency in Excel - Experience with automation - Understanding of quotation systems - Ability to extract and interpret data from invoices I lo...
I require an experienced Excel expert to develop an equipment finance calculator for me. The calculator must allow for adjustments to be made on the following parameters: - Interest rate - Brokerage fee - Loan duration - Balloon payments - Principal amount: Input field to specify the initial loan amount. - Payment frequency: Option to select how often payments are made (e.g., monthly, quarterly). - Down payment: Input field to specify any upfront payment made at the time of purchase. The calculator will be used on a Windows operating system. Therefore, it should be designed accordingly. Ideal candidates for this project should have a strong background in finance and excel, with experience in creating finance-related tools on Excel. Please ensure your bid reflects yo...
I have a Microsoft Word file that requires professional formatting. Some titles are incorrectly positioned at the bottom of pages and need to be moved to the next page for better layout. The current editing is loose and requires improvement. Additionally, I have a PowerPoint presentation, and I need its content integrated into the same Word file. Please insert the Notes view from each slide after the corresponding session in the document. Ensure the Table of Contents is updated accordingly. This task is urgent, and I need it completed within the next 2 hours. The work is straightforward and should take an expert about an hour to complete.
I'm a seasoned logo designer with extensive experience in crafting distinctive and meaningful logos that mirror a brand's mission and ethos. I've had the privilege of working with diverse clients, aiding them in establishing powerful brand identities. My portfolio can be accessed here: [insert portfolio link]. For your project, I will generate three bespoke logo concepts and refine them according to your feedback. I am certain we can develop a logo that accurately embodies your brand. I'm ready to commence immediately and can wrap up the project within [X] days for [X amount]. Don't hesitate to contact me if you have any queries or wish to discuss the particulars in more depth. Eagerly anticipating our collaboration! Best regards, The logo will feature ...
I'm a seasoned logo designer with extensive experience in crafting distinctive and meaningful logos that mirror a brand's mission and ethos. I've had the privilege of working with diverse clients, aiding them in establishing powerful brand identities. My portfolio can be accessed here: [insert portfolio link]. For your project, I will generate three bespoke logo concepts and refine them according to your feedback. I am certain we can develop a logo that accurately embodies your brand. I'm ready to commence immediately and can wrap up the project within [X] days for [X amount]. Don't hesitate to contact me if you have any queries or wish to discuss the particulars in more depth. Eagerly anticipating our collaboration! Best regards,
I need a professional-grade brochure detailing the specifications of a woodworking machine. - The primary purpose of the brochure is to provide detailed specifications of the machine. It's not just ...types of wood the machine can process and any limitations regarding wood types and sizes. - Provide information about the machine's operating speed and any adjustable speed settings. - Highlight all safety mechanisms included in the machine, ensuring user safety during operation. - Detail the maintenance procedures, frequency, and tools required for upkeep. Brochure to fit on an A4 single sided sheet. Ideal skills for this job include graphic design, technical writing, and understanding of woodworking machinery. Previous experience creating product specification brochures ...
...need of a skilled professional who can assist me with an urgent task tonight involving Excel spreadsheets. The project consists of mail merging my Excel spreadsheets into PDF forms. The PDFs will require incorporation of web links and images, specifically, logos embedded in the PDFs and web links incorporated into the PDFs as QR codes and bar codes generated for each entry. Ideal Skills: - Expertise in Excel - Proficiency in PDF conversion - Ability to meet tight deadlines - Attention to detail - Proficiency in Mail Merge - Experience in generating and embedding QR codes within PDFs. -Experience in importing graphics - Experience generating bar codes The PDF forms should include specific fields from the Excel spreadsheet. The QR codes should link to the web...
I need an Excel expert to organize and combine two Excel sheets, approximately <2K rows each, containing contact information (Names, Emails, Phones, Addresses). Key Requirements: - Cleanup and organization of two Excel sheets - Incorporate an 'Address 2' column: Move apartment/suite numbers to 'Address 2' - Create copies of rows with a secondary email, using the text before '@' as the first name, while keeping other contact details consistent - Data deduplication across 20 existing columns - Sorting the data in an Alpha Numeric order by Company Name post-cleanup - Ensuring column titles remain consistent - Combine records with identical names, ensuring that the most complete information is retained. - Standardize the format of phone n...
I'm looking for a professional engineer to design a concrete floor plan for a garage games room. The plan should incorporate an open layout that accommodates various elements and activities. Key requirements: - The garage games room should have space for car parking and storage. - It shou...must include provisions for plumbing and laundry facilities. Ideal skills for this job include: - Expertise in engineered floor plans. - Experience with residential building designs. - Ability to create open floor layouts. Please, only bid if you have relevant experience and can deliver a comprehensive and practical floor plan. The dimensions of the garage games room should be specifically [insert dimensions here]. 40x60 The floor plan should utilize a concrete flooring material throug...
Hi, We have a relatively straight foward issue, we use a spreadsheet as a total hour tracker f...employees as they need to maintain 38 hours per week, but will do different each week, so we just keep a running balance the formula just takes the total balance from the last week, adds on total hours worked this week, etc =O166-[@[Total Hours]]+38 Now its an absolute mission to add new employees or additional weeks into this chart, I would like a button (Marco?) at the top where we could insert a new employee and where we can add additional weeks into the spreadsheet. See attached for what we are using - my formula that I am using could probably be made better. if we could have a running total somewhere that we could pull data off that would be nice - as currently we just look at ...
...Examples: clients would be able to link to such information as: their contract with me, their end of the month investment returns, our recent meeting notes, investment strategy currently in place, etc, etc, etc. …modifications by me monthly. • Files would be downloadable or just content that I might paste into WordPress as a “custom post type” • Upon clicking on the hyperlink, a PDF or possibly Excel file would pop-up • I would upload these updated documents myself – as stated, regularly. 3. Enable me to upload other general (not client specific) documents, such as monthly newsletters, easily. I have never been comfortable with the WordPress facility for this. In connection with the above, I desire the developer to instruct me how to do th...
We are looking for a Virtual Assistant who can manage tasks that we have pending for some assignments to facilitate the proper functioning of our guidelines. Requirements: - Speak Spanish -Have basic computer knowledge. -Excel Basic. -Puntuality. We offer stable work, since we have a good list of tasks to perform an. Whatapp no: +1(289)535‑3721
...UI/UX, and mobile responsiveness. Experience with SEO and site optimization. Knowledge of modern eCommerce design trends and best practices. Deliverables: A fully redesigned Shopify store with improved UI/UX. Documentation on the changes made, any apps integrated, and any customization work. Post-launch support for bug fixes or minor adjustments (optional). Timeline: Expected project duration: [insert your preferred timeline]. Open to discussing the scope if you think the timeline is tight or unrealistic. Please share examples of previous Shopify websites you have worked on and let me know how you would approach this project. Looking forward to collaborating!...
I need a professional photo editor to crop two photos for me. This is for my grandmother’s funeral, one for the program sheet, other for the picture next to the casket. The main goal is to remove background distractions while keeping only essential elements of the environment. The focal point in these photos is a person or group of people, which should be retained. Ideal Skills: - Proficient in photo editing software - Keen eye for composition - Experience in removing background distractions
I'm in need of an expert in MS Power BI who can help me create a das...me create a dashboard tailored for customer insights analysis. This dashboard will primarily connect to various Excel/CSV files, so proficiency in handling and integrating these data sources is crucial. Key Requirements: - Expertise in MS Power BI - Experience in creating customer-centric dashboards - Proficiency in connecting Excel/CSV files to Power BI - Ability to customize subsets and output data as needed Visualizations: The dashboard should predominantly feature bar charts and pie charts. Therefore, experience and skill in designing these specific types of visualizations in Power BI is important. Ideal Skills: - MS Power BI - Data Analysis - Visualization Design - Excel/CSV Data Handl...
I need a solution to automatically save all my WhatsApp messages into a Google Sheet. Key Requirements: - Capture all messages from WhatsApp, regardless of sender - Log messages into the Google Sheet every hour - Record the sender's name, the message's timestamp, and the message content , and the chat group - Use a normal WhatsApp number (not a business account) Ideal Skills and Experience: - Proficient in using and scripting for Google Sheets - Experience with WhatsApp automation - Skills in Python or javascript programming language - Familiarity with APIs and web automation tools - Capable of setting up a real-time logging system - Please note, this project requires a high level of attention to detail and consistency. Please use reliable me...
...involving Excel spreadsheets. The project consists of mail merging my Excel spreadsheets into PDF forms. The PDFs will require incorporation of web links and images, specifically, logos embedded in the PDFs and web links incorporated into the PDFs as QR codes. This is a very easy task and if done well much more work will follow. Ideal Skills: - Expertise in Excel - Proficiency in PDF conversion - Ability to meet tight deadlines - Attention to detail - Proficiency in Mail Merge The PDF forms should include specific fields from the Excel spreadsheet. Please, bid only if you can deliver step 1 tonight. Thank you. The QR codes should link to the website. The PDFs should follow custom branding guidelines provided by the client. The PDF forms should include t...
I'm looking for a modern and sleek design for a tradeshow bag and t-shirt, both aimed at promoting my brand. The designs should predominantly feature my company's colors. The concept and the text are attached. The design needs to be circular as shown in the concept along with different graphics related to copy along with the text from the copy in the design. Please take the copy and insert any company logo, and I will provide the actual logo to the qualifying people only. I'll be needing editable & layered PSD / Illustrator files. No AI please since I'll be needing completely editable files.
I'm looking for a developer to create a tablet-compatible calculator for estimating residential lighting jobs. The calculator will need to factor in various costs and should be compatible with a set of specific lighting products. Key Requirements: - A calculator that allows users to input different Alliance Outdoor Lighting Products (as determined by a PIM data sheet) and computes an estimate based on the inputs. - The estimate should include the cost of the lighting products, labor costs, and maintenance packages. - The calculator should have a user-friendly interface that allows easy input and output of data. - The calculator should perform real-time calculations as the user inputs data. Ideal Skills and Experience: - Software development with experience in creating calcula...
I have a large Excel spreadsheet that needs some reformatting to get it ready for a regression analysis. The data is currently in a single sheet, and the task involves a significant amount of copy-pasting. This project involves: - Merging and aggregating various data points - Ensuring the data is correctly formatted for analysis Ideal candidates for this project will have: - Strong proficiency in Excel - Experience with data preparation for statistical analysis - Attention to detail to ensure accuracy during manual data handling. Stat knowledge is not necessary but helpful. It's about 800 rows of company data that need to be manipulated from wide to long for regression tools.
I'm seeking a PowerShell expert who can create a script to read data from an Excel file, update variables in a sample plain text template, and save the text file with the variable name and date as the filename in a different folder. Key Requirements: - The saved text files should be named using the variable name from the specified Excel column. - The specific Excel columns containing the variable names and the data to be updated will be provided later. - The script needs to work with a provided plain text file template. Ideal Skills and Experience: - Proficient in PowerShell scripting. - Experienced with Excel data manipulation. - Familiar with working with plain text file templates. - Able to deliver a flexible script that can accommodate custom specific...
I need a seamless integration between Fortnox and Excel to manage 80k products. The integration should allow me to update product info, stock and price information from the same Excel file to Fortnox on request. Additionally, I need to export orders and purchase orders from Fortnox in CSV format, containing only product info, number of products, and stock availability. Ideal skills and experience for the job include: - Proficiency in Excel and Fortnox - Experience with data integration - Ability to create custom solutions for specific needs - Familiarity with CSV format - Strong attention to detail to ensure accurate data management. You need access to Fortnox Rest API.
