Combine sheets file vbacông việc

I'm currently looking for a skilled individual who can assist with managing my Quickbooks and client files for a Department of Transportation-related business. The responsibilities would include: - Data entry and organization - Invoicing and billing - Generating financial reports To be successful, the ideal candidate ...managing Quickbooks and client files for DOT Transportation. - Proficiency with a custom software specific to our industry. Experience, reliability, and a keen eye for detail are key for this role. You'll be handling crucial business information, so discretion and professional handling of sensitive data are paramount. Let's collaborate to streamline our financial processes, improve our client file organization, and maintain accurate records for s...

...Microsoft Excel to execute intricate modifications to an existing Excel file. Key changes I need include: - Data validation: I want the data entered via the arrows online and calculated for AQL. The freelancer must be adept in managing flexible data entry and control measures. - Formula adjustments: The selected professional will have to be skilled in making and tweaking formulas. - Formatting changes: I'm looking for an aesthetic refit of my Excel sheet. The freelancer needs to have a good eye for layout design and detail. - The file should lock unused cells for consistency and error avoidance. - I'd also like to have a clear button included for the easy cleaning of specific data or cells. Lastly, the file should be able to auto-update ...

I require assistance with linking multiple Google Sheets documents - extracting certain cell values and incorporating them into different documents. I have tried to use the IMPORTRANGE function, however, I'm encountering difficulties connecting to the second Google Sheet. The specific error message I'm receiving states: "You do not have authorisation to access this worksheet.". I need this issue resolved, and the linkage between sheets established smoothly. Ideal Skills: - Expertise in Google Sheets and its various functions. - Problem-solving skills - able to troubleshoot the IMPORTRANGE issue. - Excellent understanding of document authorisation and permissions on Google Drive. This task requires a good understanding of Google Sheets, i...

I'm urgently seeking an Excel and VBA professional who can overhaul my current workflow. Key tasks will involve: - Automating a series of repetitive tasks to significantly increase efficiency. - Optimizing a range of statistical formulas in existing spreadsheets. While the complexity of the statistical formulas in the project isn't certain, you should comfortable dealing with both simple and advanced computations. The ideal freelancer for this project should be proficient in Excel and VBA, have a solid understanding of statistical formulas, and a knack for optimizing work processes. An ability to execute tasks quickly without compromising on quality is critical.

I have a 54 minutes long audio file mostly in English that need to be transcribed in a word document. The audio has some Arabic speeches also (only about few minutes) that need to be translated into English as well. I hired a person earlier who did some transcrip already but it's not complete. I need someone who can complete the transcript asap. I'm looking for an experienced person who is experienced in transcription works to do the job. I prefer to hire an Arabic person for the job as there are some parts in Arabic which requires translation in English. Deadline: 12-14 hours Price: 22 Euro fixed Please bid only if you accept the price and deadline. Thanks!

I'm seeking a freelancer who possesses both exemplary data entry and photo editing skills. Main responsibilities will include: - Completing data entry tasks, specifically typing. I'll require you to input data into Google Sheets. Experience with Google Sheets is a must. - Performing various types of photo editing. This involves color correction, background removal, and image retouching. Proficiency in this area is a necessity. Ideal skills and experience: - Fast and accurate typing abilities. - Expertise in Google Sheets. - Prior photo editing experience, specifically in color correction, background removal, and image retouching. Please provide examples or relevant work experiences in both data entry and photo editing when submitting your bid.

More details: Which platform are you using to open Power Apps through Power BI? Power BI Desktop What is the primary functionality you want the Excel file upload to accomplish? Update existing Power BI visual What is your preferred way of triggering the Excel file upload? By clicking the file uploading button it will upload the visual automatically

I am searching for a skilled graphic designer who can help me create an easily editable JPEG image file. The starting point will be an image provided by me. The project's main components are: - Generation of a JPEG image file that can be edited effortlessly - Adding and removing text regularly - Altering objects in the image from time to time If you have proficiency in creating dynamic JPEG images, mainly focusing on text modification and object alteration, feel free to bid. Completed project delivery is needed ASAP.

I'm in need of an adept Excel specialist with exceptional skills to develop a multi-sheet spreadsheet capable of handling textual and date or time data. Though there was no specific need for complex functions, your ability to create logical and easy-to-follow spreadsheets is paramount. Key Requirements: - Develop an Excel Spreadsheet with multiple sheets and columns - Make sure the spreadsheet can easily handle and manipulate textual and date or time datasets While programming skills and knowledge of financials or statistical analysis aren't necessary for this project, a firm understanding of Excel and its basic capabilities is ideal. Successful completion of similar past projects would be advantageous.

I need a skilled Excel/Google Sheets wizard to create a comprehensive tool for tracking operating expenses. Our primary focus is on monitoring our operational expenditure in a concise, easy-to-use spreadsheet format. Ideal skills for the job would include: - Proficient understanding of Excel or Google Sheets. - Experience in building financial tracking and forecasting tools. - Great attention to detail. - Good understanding of operating expenses categorization. Your task will be: -Develop a user-friendly dashboard for inputting expenses, including options for date selection, currency selection (USD, GBP, EURO), recurring expenses (monthly/yearly), tags (e.g., marketing, operating), description, and notes. -Design and implement a dynamic dashboard that displays year-to-date ...

Hi, I'm in search of someone skilled in Excel& Crypto sheets to assist in creating a spreadsheet that tracks real-time Bitcoin prices, network difficulty/hash rate, and estimated mining rewards based on hash rate. The goal is to correlate this data with my estimated mining rewards, watts used per miner, and ultimately calculate ROI and the bottom line. If you're interested, please send me a private message. I'll provide further details and data once we connect. Looking forward to hearing from you!

Read before bidding, verification test included. This should be a 30 min project for an expert in google sheets. I have a google sheet with 18 lookup tables in tab "lookup" in other tabs I need to use each of these 18 tables as dropdowns to show the options (with descriptions) but when an item is selected, I only need the number put into the field. Each table is used for 2 cells in 1 row (Now & Goal) See screen shot which shows the data tab (left) and the first 2 lookup tables in the lookup tab (right) No time to waste. To prove you read this posting, put the name of your favorite food in all CAPS as the absolute first word in your bid. Auto bids will be deleted. Your bid is your bid, don't ask budget AFTER we start chatting. I will ban you from all my p...

We are looking for an individual who can efficiently go through 2000 PDF files, just need to perform few clicks for each file. Very simple, repetitive task. Diligent person who does not make mistakes. We may have more tasks for successful candidate. Will leave you excellent feedback.

I am looking for an Excel expert who can create an easily understandable and navigable sheet that can efficiently track Diesel fuel consumption with particular emphasis on calibration error analysis. This would allow me to both track fuel usage and monitor discrepancies in fuel consumption. Key functions include: - Tracking fuel usage: Allow me to manually input and monitor t...any differences in actual and expected fuel consumption. - Track excess and shortages: Clearly indicate any discrepancies or unusual patterns in consumption, logged on a monthly basis. Ideal candidates for this project should have: - Excellent knowledge of Excel and its computational capabilities - A good understanding of calibration error analysis - Proven track record of creating similar Excel sheets and ...

I have an Excel VBA simulation program that I require recoded into Python. This project is not about merely translating the existing code, but about enhancing it to extend its capabilities and improve performance. Key elements of the job: - Recoding: You must be experienced in recoding from VBA to Python, translating the existing script flawlessly. - Simulation Presentation: I require an advanced 2D flow chart with interactions. Familiarity with graphic representation and data visualization in Python is required. - Detail: I expect comprehensive details of all operations. Experience in complex project mapping will be beneficial. This project will suit a developer with deep expertise in both Excel VBA and Python, accompanied by a robust understanding of data visuali...

I need an After Effects (AE) specialist and video editor to create an engaging 3-5 minute comix music video with a focus on motion graphics. Desired Expertise: - Proficient in Adobe After Effects - Extensive experience in video editing - Strong ...focus on motion graphics. Desired Expertise: - Proficient in Adobe After Effects - Extensive experience in video editing - Strong understanding of motion graphic animation Key Responsibilities: - Create compelling and innovative motion graphics - Develop a 3-5 minute comix themed music video - Edit video to meet aesthetic and technical standards This project provides an exciting opportunity to combine visual artistry with technical prowess. The ideal freelancer is one who thrives in creating immersive visual storytelling through motion...

I'm in need of someone with expertise in Google Slides and Microsoft PowerPoint to turn my 290mb .PPT file into a Google Slides file. Google has a 100MB upload limit and I don't have a Microsoft 360 subscription, so you will need to open it in Power Point, save it into 3/4 smaller presentations and combine them in google slides. Key project details: - The Google Slides file should adhere to the existing design of the .PPT file. No new designs required. - The .PPT file may or may not contain interactive elements like hyperlinks or animations. Please ensure these work properly if present. - All sections of the PowerPoint are important and should be treated equally in Google Slides. No particular emphasis on any section needed.

Avrei bisogno della costruzione di un file excel che risponda alle seguenti necessità: individuare il prezzo corretto di una struttura ricettiva in funzione dell'andamento del tempo. Di seguito le caratteristiche: 1) Al giorno X (es. oggi) abbiamo un riferimento specifico come prezzo di base (prezzo standard) per il quale la struttura deve uscire a mercato. Ad esempio, oggi 09/03/2024 il prezzo di base nella prima settimana di Luglio 2024 è 100€ a notte; 2) Ci sono delle fasce temporali tali per cui il prezzo di base cambia in diminuzione. Ad esempio se ci troviamo al Giugno 2024 il prezzo di base dovrà scendere sotto di una determinata percentuale, perchè probabilmente il prezzo di base non incontra la domanda di mercato, ed in poche parole il...

My LOGO is in png file, if any one can covert it in CDR file.....and share....

...with experience in Squarespace and Google Sheets API to create a program that can automate my daily tasks. This automation will allow information from orders I receive on Squarespace - including Customer details, Order details, and Payment details - to be sent directly to a Google Sheet of my choosing, and it needs to update automatically on a daily basis to account for new orders (or just manually on program run). The ideal freelancer for this job would have: - Solid experience in Squarespace and Google Sheets API programming. - Understanding of order management and payment processing. - Proven track record in automation or systems programming. Key Features required in the solution: - Daily transfer of data from Squarespace to Google Sheets. - Ensuring data ...

I am looking for a talented graphic designer to create a captivating logo for my beauty business, SXM beauty lab. The logo should not only reflect the essence of the beauty artistry we offer, but also stand out in the beauty market. Here are the specifics: • Desired Colors: The logo should embrace gold, black, grey, and white shades. I am open to several forms of design that combine these colors in an aesthetic and appealing format. • Business Focus: My business primarily focuses on makeup artistry and other beauty services – the logo should clearly communicate this through imagery or design style. Required Skills & Experience: • Graphic design • Experience in logo or brand design • Understanding of color psychology in branding • Knowledge...

I need a macro specialist who can work with Excel VBA. Key responsibilities: - Creating Excel VBA macros Ideal Candidate: - Demonstrable experience in Excel VBA - Strong analytical skills - Task focus: macro creation The specifics of the function the macros will perform are still undecided. I'd appreciate your expertise and input on this.

A bespoke digital solution is required to manage product data sheets for clients and employees. An elegant and easy-to-use landing page will allow registration through a secure form, with authentication and administrator approval mandatory before files can be accessed. Only certain domain names will be permitted for registration. The successful candidate will develop a structured library where registered users can browse, download, print and view a populated collection of PDF data sheets organized into product folders. Access to us as a business adding further data and information is essential as this will only grow. (ie BIM files, Line Drawings 2D/3D etc. Comprehensive reporting functionality is essential to capture user profiles containing names, email addresses, locati...

Buongiorno, ho un forno costituito da 4 alberi verticali rotanti, su ogni albero possono essere montanti più piatti. I piatti contengono lungo la circonferenza degli utensili per essere rivestiti. Il tipo di piatto dipende dal diametro dell’utensile scelto. Un piatto per utensili di diametro 3mm ha 50 posti, per diametro 4 ha 50 posti, per diametro 6 ha 36 posti, per diametro 8 mm ha 30 posti, per diametro 10 mm ha 25 posti, per diametro 12 ha 20 posti. Il forno ha un’altezza interna massima di 465 mm. L’altezza di ogni piano è data dall’altezza del tipo di utensile più alto contenuto all’interno del piatto, dall’ altezza del piatto (10mm) dalla distanza di sicurezza al di sopra degli utensili data dalla formula (1.5 x diametro + 30 ...

I'm seeking a seasoned developer well-versed in Flutter web form and PDF generation. This project involves developing a Flutter web form with the resulting output as a read-only PDF file, which should include both text and images. ------------------- Please read the attached proposal file carefully. Besides, before establishing a milestone, we will continue to revise and update this proposal along with its specifications within the discussion threads. Prior to accepting the milestones, please ensure to review all the most updated proposal details and specifications. Let’s confirm we have the same proposal with the same modification time before accepting milestones. -------------------- Key responsibilities for this project include: - Creating a form in Flu...

I have a VBA code that's currently running into issues on Microsoft Excel. The problem lies in the code not interacting properly with the correct data, causing it to function incorrectly. Key Requirements: - Understanding of VBA code interaction with data - Specific experience in troubleshooting code functionality - Familiarity with VBA for Microsoft Excel Your role will be to diagnose the problem causing the interaction failure and apply comprehensive fixes. In your proposal, please share relevant experiences of VBA troubleshooting and data handling. Efficiency and effectiveness in resolving the issue will be highly appreciated.

You - Have interest in start-up and investing subjects so you understand what you are doing - Can do web research very well - Fill in Excel sheets to complete work, but also add/remove columns as you see make sense - Like you do work to help teach others I have a site which teaches entrepreneurs and investors nerdy things. Your role can vary to need and your ability. If you can do more, you get opportunity to do what you are capable of (including manage people if you can scale up work). Have a few things to do now. E.g.: - Update a collection of links as to why investors invested in startups - If you are able, to extract asset management presentations from government websites - Youtube videos of the first startup from famous startups made If you are a nerd this is a fun job. Can ...

More details: I need a Logo for a new website. simplesax.com. The logo should just be simplesax. Its a site for learning how to play the saxophone. Please also provide the font name used, layered file (psd) and png file.

I'm seeking a talented designer to create a logo for my company, Stoica Global Trade . This is what I envision: Logo Parameters: - Incorporate white and black colors - Proactively create a combination ...designer to create a logo for my company, Stoica Global Trade . This is what I envision: Logo Parameters: - Incorporate white and black colors - Proactively create a combination of symbolic and text-based design Ideal Candidate: - Has a knack for creating eye-catching, memorable brand logos - Understands color theory, especially how to make white and black dynamic and visually appealing - Can combine symbols with text to make a striking, non-generic logo Please include your portfolio or examples of similar work in your bid. I look forward to seeing your creativity unfurl o...

As the project initiator, I require someone skilled in data entry to transfer numeric data from the online databases I specify, into Google sheets. Previous experience with online databases is preferred, along with accuracy and attention to detail. Basic understanding of managing Google Sheets is a must. You will also need to practice integrity when handling potentially sensitive data. Skills & experience: - Prior data entry experience - Familiarity with online databases - Proficient in Google Sheets - Attention to detail - Discretion with sensitive data

...constructing a high-quality, captivating fantasy sports application. We will release our product on both major platforms, Google Play Store and Apple App Store. - UI Design: We have reference sketches prepared for all screens that will guide you in creating a sleek and attractive user interface. - API Integration: Our team will provide the preferred API for this project. We expect you to seamlessly combine this API with our app infrastructure. - Deployment: We are aiming for a dual-platform release. Proficiency in deploying apps on both Google Play Store and Apple App Store is a prerequisite for this project. Ideal Candidate: - Expertise in Flutter development - Strong portfolio showcasing past app deployments on multiple platforms - Knowledge of dynamic app design and ...

I'm in need of an experienced website developer who has expertise in creating e-commerce websites speci...elements should include: - Customer review section: This should be easy to navigate and allow users to not only rate but also leave comments on their purchases. - Wish list functionality: Users should be able to save and track their must-have items for future purchases. Ideally, you have previous experience with creating pages that resonate with discount shoppers. Looking for someone who can combine functionality, usability, and aesthetics into a cohesive site. There may be future opportunities for project extension, primarily in maintaining and updating the website according to user feedback and changes in market trends. Please show past e-commerce website portfolios whe...

We are seeking a skilled Google Apps Script Developer to assist in enhancing our Google Sheets-based management system. Our system currently consists of 8-10 tabs, with data synced from Notion, serving various tracking and management purposes. We aim to develop a custom script that can efficiently aggregate and display this data on a dashboard within Google Sheets. Key Responsibilities: - Participate in a 30-minute Google Meet discussion to understand the structure of our Google Sheets and the specific requirements for the dashboard. - Develop a custom Google Apps Script that can automatically populate the dashboard with information aggregated from the existing sheets. - Ensure the script is optimized for performance and is easily maintainable. Required Skills...

I am in need of a website designer who is proficient in setting up and designing an engaging, user-friendly property listing website. The website's main function will be for both buying and renting properties, and it should cater to a wide range of property t...showcase multiple images of the property. Bids are welcome from experienced professionals preferably with prior work in the real estate industry or similar marketplace platforms. Knowledge in UI/UX strategies will be a significant advantage. The freelancer should also possess a solid understanding of SEO principles to ensure maximum visibility of the website on search engines. Your expertise should combine creativity with an understanding of the latest digital design and functionality trends to ensure a seamless experi...

*** This is a VERY SIMPLE minimum work request. Only cosmetic changes/ NO MAJOR or functional design changes. *** I am seeking to modify existing open source STEP file. The central task of the project is to remove logo from design and replace with a simple textured design on both the face that hosted the logo and to opposite face of the part. The potential freelancer should have: • Excellent skills in dealing with CAD / 3D modeling software to efficiently execute required cosmetic design changes. • A good understanding of how to create a functional and tactile texture on an existing design. The task is to: • Remove/Replace the logo from the specified part location • Replacement of logo with tactile texture on both the face that previously hosted the log...

...professional, and convey the cybersecurity theme. It should be versatile enough to be used on various platforms (website, business cards, social media, etc.). Color Scheme: I do have some colors in mind, but I would really appreciate your professional input to ensure we choose colors that not only appeal to me, but would also be attractive and engaging to my potential clients. So, your ability to combine technical expertise with creativity is highly required. We are open to suggestions but prefer a palette that communicates trust, security, and technology. Font: The font should be clear, readable, and modern. It must convey professionalism and be applicable across different mediums. Symbolic: Incorporation of elements that symbolize cyberspace, digital protection, or cybersecu...

APK and exe file project I'm going to work on.

I'm searching for an experienced programming freelancer who can efficiently create a simple script to organize my files. Primarily, this task includes: - Designing a script to specifically move files with the extension ".VAR". ...output an easily readable log of what was done, e.g., "Moved XYZ.abc.1 to XYZ folder" or "Created XYZ folder", as in the case where the folder didn't exist previously. - No undo functionality needed. - Should run as a standalone without an install package. The ideal candidate for this job would have a strong background in building file management scripts and savvy knowledge of programming languages. A keen attention to detail is crucial to ensure the accuracy of file organization. The quicker you can complete...

I'm searching for a skilled video editor to create YT tutorials. An example has been attached. If you have the following qualities you can jump on-board! - Excellent English - Basic video editing skills For the rest of this task, I will be doing some simple training sessions. The video editor is usually provided with a voiceover. Their job is to then record screen, while demonstrating the steps in action. This is a sample project for which the selected candidate will be paid $10. This payment will be processed upon successful completion of the first video.

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

I'm looking for an experienced coder who can...Calculations: The project requires intermediate level formulas and calculations. This includes but is not limited to: averaged data, percentages, counts, etc. Familiarity with these kinds of Google Sheets operations is needed. Ideal candidates for this project will possess excellent coding skills, thorough experience in Google Sheets and Google Docs, and a fine understanding of dynamic data visualization within these platforms. Utilizing your knowledge of Google Suite, you'll provide a smooth, efficient user experience within the Google Doc without the need to constantly switch between the Doc and Google Sheets. Efficiency, attention to detail, and commitment to maintaining the integrity of the document's d...

I'm seeking a well-versed freelancer capable of customizing Airtable forms for my business. These forms should collect answers, create a record in the appropriate Airtable bases, and email me about the new entry. . They will be used for efficient data...seamless data collection integral for our ongoing business assessments. Please note that this project will not involve manual data entry but instead requires understanding of systems integration. The collaboration of form and data management should mirror our current business methods. Current form collection site The forms are currently Google forms leading to sheets. We believe Airtable is a better solution but are open to a Google solution Example form collection

I'm looking for a skilled designer to create an engaging and informative sell sheet template for educational purposes. Primarily, the sell sheets are intended for IT Directors and their staff. Key Duties: - Incorporate significant information about specific topics into the design - Ensure design supports clarity and easy comprehension Ideal Skills: - Strong graphic design skills - Experiences in educational content design - Understanding of IT-related topics. Your designs should enhance the delivery of in-depth content and make it compelling to the target audience. Expertise in balancing visual appeal with content clarity is a huge plus.

I am in need ...formatting, analysis and reporting, as well as data entry and updating. The specifics and volume of the sheets or data files, along with the project deadline, will be discussed later: - Skills and Experience: An ideal candidate should have advanced Excel skills, precision in data entry, experience in data cleaning and formatting, and know-how in data analysis and reporting. Related work experience is highly preferred. - Responsibilities include but are not limited to: cleaning and managing datasets, transforming and formatting data to make it analyzable, updating the data inputs regularly, and generating reports based on the analyzed data. Please note that the final number of Excel sheets or data files and project completion timeline will be clarified upon ...

I have several macros that were created by someone else that needs modified. Basically, the macro runs and the outcome is 90% of what I need it to be. However, I need to take the data the macro creates, turn it into a table, filter one of the columns, then provide some cells to total the amounts. That's it. I am new to VBA and I just to someone to make the aforementioned changes to the macro.

...• Research abilities • Proficient in email management Though the specific tasks were skipped during the question phase, I expect your application to include details about your past work experiences where you carried out similar tasks. A comprehensive project proposal will also be beneficial. SOFTWARE PROFICIENCY It would be a plus if you have proficiency in tools like Microsoft Excel, Google Sheets, or any CRM systems. While these tools were skipped during the initial question and answer phase, they still play a valuable part in performing your duty effectively. Kindly ensure your bid reflects your skillset and experience within these domains....

I'm looking for a talented graphic designer to merge two of my photos into one. Here's what you'll need to know: - Purpose: I intend to combine different elements from the two photos to create a unique image. - Preservation of Original Colors: It's key to maintain the original color schemes in each of the individual photos. I don't want a unified color theme; I like the distinctness the original colors bring. - Emphasis: Ensure that the background elements of both photos stand out in the merged image. The ideal freelancer for this job would have a keen artistic eye, experience with photo editing tools like Photoshop or GIMP, and a knack for maintaining color accuracy. Additionally, competence in managing the intricacies of image fusion whilst respecting th...

...create an engaging box design tailored for health and wellness influencers. - Desired Aesthetics: I am envisioning a bold and colourful design that will immediately grab the attention and ignite interest. A creative application of colors and a visually captivating layout are crucial elements for this project. - Content: The design should integrate images of fruits and vegetables. I'm seeking to combine wellness and fresh produce in an engaging and attractive way that resonates with influencers and their audiences. - Ideal Skills and Experience: Experience in packaging design or related fields is required. A strong portfolio showcasing your ability to work with bold, vibrant color schemes and graphics would be advantageous. Your understanding of current design trends i...

I'm seeking an experienced logo designer who can seamlessly combine text and symbols to create a unique logo. Our brand leans towards a modern and minimalist aesthetic. Im looking to integrate the Pareto-Principle => getting 80% done with 20% effort Key Responsibilities: - Design a logo merging both text and symbols - Stick to a minimalist, modern style - Primarily use black and white, eggshell, grey, color palette maybe with one warm color tone (orange, red, yellow) Skills and Experience: - Extensive experience in minimalist logo design - Awareness of current logo design trends - Portfolio showing ability to integrate text and symbol elements efficiently. I look forward to seeing how you can brand our identity. Please include previous relevant work in your proposal. ...

I am after a creative scriptwriter with experience in crafting engaging and educational documentary series. Your task will be to write compelling scripts in the style of James Jani for a series focusing on business and entrepreneurship. Our topics will combine crucial aspects of personal finance - from Innovative Investing Strategies, Astute Money Management, to Understanding Debt and Credit. The ideal candidate will: - Have proven experience creating engrossing and insightful scripts for documentaries or other long-format productions. - Strong grasp of personal finance and entrepreneurship concepts, or the dedication to thoroughly research them. - Assist in weaving together a wide range of information to craft a coherent, engaging narrative. - The ability to inject educational ...