Excel vba rename files subfolders jobs

I'm experiencing issues with my Excel. The Copy/Cut/Paste functions are disabled, and I need someone to troubleshoot and assist me with these functions. Ideal skills for this job would include: - Expert knowledge of Microsoft Excel - Troubleshooting skills - Data entry experience Please help me get my Excel functioning properly again. Thank you!

I'm looking for a freelancer to assist with data entry from spreadsheets into Microsoft Excel. The data is mixed, consisting of both text and numerical values. Ideal Skills and Experience: - Proficient in Microsoft Excel - Attention to detail - Experience with data entry from spreadsheets - Ability to handle mixed types of data (text and numerical)

I have several transactions that need to be compiled into a billing statement. You will receive: - Transaction details in an Excel/CSV format - A template to follow for the billing statement Your task: - Convert the transactions into a Word and PDF billing statement using the provided template - Include all details I provide, such as client details, billing period summary, and payment instructions Ideal skills: - Proficient in Excel - Experienced in Word and PDF document creation - Attention to detail to ensure all supplied information is accurately included

...subscribing to Sales Navigator (cost covered by me), researching through LinkedIn and the web to locate the Melbourne Office and headcount located in Melbourne and populating an Excel spreadsheet with relevant data. Key Responsibilities is to research Melbourne businesses and fill in the following: - Fill in the spreadsheet with the Melbourne office address - Fill the number of staff located in Melbourne (details provided) The workload is anticipated to be about 400 hours. The ideal candidate for this project should have: - Excellent research skills - Familiarity with LinkedIn and Sales Navigator - Proficiency in Excel - Ability to work independently and manage time effectively Please note the list will provide a link to the LinkedIn page which will make it quicker to...

I need assistance with modifying two Excel files. The modifications include: 1. Separating headers into individual cells (e.g., Serial Number, Last Name, First Name, etc.). 2. Ensuring the header row is consistent across all pages. 3. Removing empty rows. 4. Deleting duplicate words while preserving the main data integrity. 5. Maintaining the serial number and data alignment. The headers follow a specific format, which is a combination of uppercase and lowercase letters. I can describe this format to you, but I will need your assistance to determine it in some cases.

I have three PDF drawings that need to be analyzed and converted into a Bill of Quantity (BOQ) in an Excel format. The scope of the project includes: Ideal candidates for this project should have a strong understanding of construction and engineering principles, experience in BOQ preparation, and proficiency in Excel. Attention to detail and the ability to accurately interpret engineering drawings are essential for success in this task. BOQ should include the following: construction electric electronic works mechanic earth works site works railway perimeter security civil/mechanical/electrical infrastructure The 3 PDF drawings to be downloaded are in the link below under ATT_13: ATT__13_Drawings_HN_COMBINED

I need assistance in organizing my credit card statements. The ideal freelancer would have experience in data consolidation and categorization. Key tasks include: - Consolidating credit card statements from the last 12 to 24 months - Organizing the statements by expense category - Delivering the final product as a well-structured Excel spreadsheet Skills required: - Proficiency in Excel - Data analysis and categorization - Attention to detail

I have a static brochure site with hundreds of photos. Many of these photos are duplicates, just in different sizes and shapes. I need someone to go through the photos and create a new folder with only the largest photo of each. Specific Instructions: - Organize the unique largest photos by their original name in the new folder. - Rename each photo to match its main name. For example, "PLANE-body-of-page-1-700x500" should be renamed to "PLANE-body-of-page-1". - Save the final photos in JPG format. - Keep the first encountered photo when dealing with duplicates of the same size. Ideal skills include: - Proficiency in file management and photo handling. - Attention to detail to ensure duplicates are not mistakenly included. - Experience with photo editing softwar...

I need a professional Excel file for comprehensive inventory planning. This includes stock level monitoring, demand forecasting, order management, and raw material safety stock. The Excel file will need to integrate with SAP, specifically for seamless data transfer and process alignment. Key functionalities I need in the Excel file include: - Automated data import: I want the data to flow into the Excel file automatically from SAP, without needing manual input. - Custom reporting: The ability to generate tailored reports based on specific parameters or needs. - Data visualization: Incorporating graphs, charts and other visual aids to help interpret the data. Ideal candidates for this project should have: - Extensive experience with Excel, particularly...

I'm looking for an expert Excel specialist who can set up a comprehensive spreadsheet for me. The data I will be inputting is a combination of financial and sales tracking information. Key Requirements: - Design and setup of an Excel spreadsheet tailored to track both financial and sales data. - Incorporation of automatic calculations and formulas to facilitate data processing. - Implementation of data visualization tools within the spreadsheet, such as charts and graphs, to illustrate trends and patterns. Ideal Skills: - Extensive experience with Excel, particularly in setting up complex spreadsheets. - Strong understanding of financial and sales data tracking. - Proficiency in creating automatic calculations and data visualizations in Excel.

...Contact details (email, phone, address, etc.). • Any other publicly accessible, relevant information. 2. Data Format: • Deliver all extracted data in a well-structured Excel/CSV format (with clear headings). • Images and files (e.g., PDFs) should be organised in folders and linked to their corresponding rows in the spreadsheet. 3. Requirements: • Ensure data accuracy and completeness. • Follow ethical web scraping practices (only scrape publicly accessible data). • Avoid causing disruption to the website’s operations. Deliverables: • A completed dataset in Excel/CSV format. • A folder containing all associated images/files. • A brief summary of the process and any challenges encountered. Budget: ...

I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.

I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.

I'm looking for an Excel expert to develop a program that calculates various real estate market trends. The program should specifically focus on analyzing general market tendencies. It should be a program that can be used numerous times with different data sets. Key Skills: - Advanced Excel skills: You should be proficient in Excel and able to create complex formulas and functions to analyze the data. - Real estate knowledge: A background or understanding of the real estate market would be a plus as it would help you comprehend what data is relevant and how to interpret. Please provide examples of similar projects you have completed.

I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.

I need someone skilled in data entry to help with inputting mixed data (numerical and text) into an Excel sheet. The data needs to be organized in chronological order. I will provide a PDF with data that contains 4 fields to be entered on Excel document. Ideal skills for this project include: - Proficiency in Excel - Excellent attention to detail - Strong organizational skills Please note, there will be no specific date or time formats involved in the data entries.

As a law firm, we're looking for a developer who can create an application for real-time analysis of Twitter, Facebook, and Instagram posts from a specific area. The app should categorize posts by theme, and generate an Excel file detailing demographic information such as age, gender, location, interests, and the profiles of followers and followees for each segment. The ideal candidate for this project should have: - Extensive experience in app development, particularly for social media analysis. - Proficiency in data segmentation and Excel file generation. - Ability to implement real-time data processing. - Skills in understanding and analyzing demographic data. Your work will help us conduct a market analysis to better orient our services.

Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective - drop lis downts. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.

We are seeking a skilled language expert with a strong background in medical and clinical terminology to handle the conversion of case studies and hospital reports into major global languages for international medical research. This position requires a professional with a deep understanding of medical practices and terminology in both the Italian healthcare system and global medical research standards. You will play a crucial role in ensuring that Italian medical documentation is effectively adapted for use in global research initiatives, supporting advancements in healthcare on an international scale. The focus of this role is the precise and accurate conversion of clinical and hospital reports into English, French, Spanish, or other widely spoken languages. The documents in question inv...

I need a PowerApp developed that handles mixed data types (text and numerical). The app should be able to connect to an Excel spreadsheet, as this will be the primary data source. Key Requirements: - The PowerApp should store data for manual calculations, which will primarily involve basic maths. - Finally, the processed data should be able to enter into SharePoint. Ideal Skills: - Proven experience in developing PowerApps. - Familiarity with SharePoint and Excel integration. - Basic understanding of mathematical calculations for data processing.

I'hankm looking for a pPDF, Word. T y Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft Excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective drop-down lists. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.

respond with vocaroo audio recording stating your experience in order to be considered ...each hour. Maintain accuracy and timeliness in all reporting tasks. Schedule: 9:00 AM to 5:00 PM EST, Monday to Friday. Requirements: Basic understanding of bookkeeping (no extensive experience necessary). Strong attention to detail and time management skills. Ability to follow a structured schedule and meet deadlines consistently. Reliable internet connection and proficiency with tools like Excel, Google Sheets, or similar. What We Offer: Supportive team environment with opportunities for growth. Training and resources to help you succeed in the role. Competitive pay for your time and effort. If you’re organized, dependable, and ready to commit to a full-time schedule, we’d love...

I need assistance with an Excel spreadsheet. The project involves data analysis, particularly performing statistical analysis. Ideal Skills: - Proficiency in Excel, particularly with formulas and data analysis tools. - Experience with performing statistical analysis in Excel. - Ability to assist with sorting and filtering data, as well as creating pivot tables.

Dear Freelancers We need someone who can make a quick database for us We have invoice where you need to take infos from the client: -First name last name adress phone number -how much they spent over...someone who can make a quick database for us We have invoice where you need to take infos from the client: -First name last name adress phone number -how much they spent over the years -number of the invoice and how much invoice they paid over the years too Invoices are .doc (so you can copy/paste) easily We give access to our Dropbox From 2020 to 2024 there is around 1300 invoices You can do it on excel or something else if you have an other idea, we need something designed and easy to look at please Write elephant in your bid to show us that you've read what we need Need it...

I'm looking for an experienced Excel professional to create a comprehensive spreadsheet for tracking my stock trading activities. This spreadsheet needs to be efficient and effective, capturing all relevant data points. Key Requirements: - Proficiency in Microsoft Excel (preferably with experience in creating financial spreadsheets). - Ability to efficiently track and calculate critical metrics such as purchase dates, sale dates, and profit percentages. The ideal candidate will have a keen understanding of stock trading and can translate this into an effective tracking tool.

I need an expert to help me organize my Excel file containing employee attendance data. Key Requirements: - Setting up filters for my analysis on employee attendance - Creating specific filters for different aspects of the data - Ensuring the file is user-friendly and easy to navigate Data Types: - Employee attendance data which includes number of days off, late comers, and early leave. Ideal Skills: - Advanced Excel proficiency - Experience in data organization and analysis - Attention to detail - Ability to create user-friendly spreadsheets

I need to delete multiple rows within a Word table. I have an Excel showing which rows should be deleted. Afterwards, some page breaks and formatting work might be needed. Skills needed: - Proficiency in Microsoft Word - Attention to detail I have two print screens attached. The word document has 102 pages with 675 rows. 326 rows need to be deleted. All work in the word document needs to be done twice: There is an English version of the document, and a German version.

I'm looking for a freelancer who can help me scrape text content from a specific website and deliver it in an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in web scraping tools and techniques - Experience with data organization in Excel - Attention to detail to ensure all relevant text content is captured Please note, the specific sections of the website to be scraped have not yet been determined, so flexibility and adaptability will be key.

I'm...Keeping track of appointments and deadlines - Email and communication management: Handling correspondence in a professional manner - Research and data entry: Conducting basic research and inputting data as needed - Performing marketing tasks such as SEO work - Performing customer service Essential Skills: - Proficiency in Microsoft Office Suite: Basic level is sufficient, but familiarity with Word, Excel, and PowerPoint is necessary - Good communication skills: Able to handle correspondence professionally - Basic research skills: Capable of conducting simple research tasks Ideal Candidate: - Previous experience as a Personal Assistant or in a similar role is preferred - Familiarity with basic research techniques and data entry tasks - Good organizational skills and atte...

...Data Entry Specialist to assist with organizing and entering new contacts into an Excel format. The ideal candidate will have excellent typing skills, a keen eye for detail, and the ability to deliver high-quality work within specified deadlines. Project Details: Scope of Work: Cognito will provide a list of companies. Using this list, the specialist will research and identify relevant Marketing and Media & Communications contacts in the US, UK, Netherlands, Germany, Hong Kong, Singapore and Australia, including their job titles (and email if available). Requirements: o Proven experience in data entry or similar roles. o Ability to conduct accurate online research to source contact details. o Proficiency in Excel and/or Google Sheets. o Tools knowledge such as Linke...

Please Sign Up or Login to see details.

I need a Tally coder who can automate data entry from various sources into Tally in real-time. Key tasks include: - Automating data entry from Excel spreadsheets, a Database, and Manual entries into Tally. - Ensuring that the data is updated in real-time. Ideal skills and experience: - Proven experience with Tally and data automation. - Proficiency in working with Excel spreadsheets and databases. - Ability to manage and automate manual data entries. - Excellent attention to detail and commitment to accuracy.

I'm looking for an expert with advanced Excel skills to help me set up and manage an inventory system using Excel. Key Responsibilities: - Design an Excel-based inventory management system - Analyze customer data within this system - Integrate Excel with external databases Ideal Skills: - Proficient in Excel, particularly in its advanced functionalities - Experience in setting up inventory management systems - Strong data analysis skills - Familiarity with customer data analysis The inventory system will manage a small to medium-sized inventory.

I'm looking for a Power BI expert to analyze my sales data for me. The data is stored across Excel files and Cloud storage, so familiarity with these sources is crucial. Your tasks will include: - Importing and cleaning the data from Excel and Cloud storage - Conducting in-depth analysis to uncover sales trends and insights - Visualizing data in a clear and engaging way Skills and experience ideal for this job: - Expertise in Power BI - Strong data analysis skills - Experience working with sales data - Proficiency in using Excel and accessing Cloud storage - Ability to present data in a clear and engaging manner

I'm in need of an expert data scraper who can help me gather contact information from a Business Directory website. The focus will be on local businesses. I require comprehensive details including: - Email addresses - Phone numbers - Mailing addresses - Company names - General contact information Ideal Skills: - Proficient in data scraping - Familiar with Excel for data formatting Primary Deliverable: - A neatly organized Excel spreadsheet containing all the scraped data. Please note, the website is quite extensive and would require someone with expertise in data scraping.

I'm looking for a script that can find photos of generic product categories from e-commerce websites and add them to an Excel file. The images should be saved in JPEG format. Ideal Skills: - Proficient in scripting languages (Python, JavaScript, etc.) - Knowledge of web scraping techniques - Familiarity with Excel automation Please include your relevant experience in your bid.

I'm in the process of conducting medical research aimed at identifying risk factors, and I require assistance with my statistical analysis. Key Responsibilities: - Conduct statistical analysis on my data - Design Kaplan curves - Create descriptive tables Deadline: All tasks need to be completed within 2 days. Skills and Experience Required: - Proficiency w...- Create descriptive tables Deadline: All tasks need to be completed within 2 days. Skills and Experience Required: - Proficiency with statistical analysis - Experience with Kaplan curve design - Ability to create descriptive tables - Medical research understanding is a plus Software: You can use any statistical software you're comfortable with. But at the end you provide me with a word and excel file so I can ...

...approximately 900K lines, into smaller text files of 10K lines each. Each of these smaller files should contain the headers from the source file. Additionally, the solution should automatically submit all the created files to a designated FTP location. Key requirements: - The solution can be created with Python, Node.JS, Powershell, or and exe program but will need to be triggered using a Windows batch command or VBA. Original source txt file is built from an excel worksheet, so an alternate solution can be building files as described via excel VBA from existing excel spreadsheet as long as it includes a PUT command to the FTP location for all built files. Ideal skills for this project include: - Proficiency in wri...

...Marketing Manager from India with proven experience in the online gaming industry. This role is commission-based, offering unlimited earning potential for high-performing individuals, as there is no salary cap. The ideal candidate should be motivated, results-driven, and comfortable working on a flexible schedule. We welcome applicants of all ages—if the candidate has the talent and ambition to excel, this opportunity is for them. Company website: Commission-Based Income Potential: Up to 20L in six months, 50L in one year, no earning cap Role: Drive traffic and player acquisition through affiliate partnerships in the online gaming industry. Manage affiliate relationships, optimize campaigns, and report on KPIs. Ideal Candidate: Sales experience with s...

My macros are not functioning on my Mac and I need an expert to troubleshoot this for me. Ideal candidates for this job should have: - Deep understanding of Excel VBA - Experience with Mac versions of Excel - Problem solving skills to troubleshoot why macros aren’t running and resolve code, where required branch code into mac or pc subs/functions.

Need an excel Expert to compare Multiple files

I'm looking for an experienced Excel professional to create an Excel spreadsheet tailored to analyzing sales data. The spreadsheet will need to incorporate various Excel formulae and features, specifically drop down lists and data analysis tools. Key Requirements: - Ability to create effective drop down lists - Strong understanding of Excel formulae for data analysis Ideal Candidate: - Has a proven track record of creating complex Excel spreadsheets - Previous experience in sales data analysis would be a plus - Excellent attention to detail and problem-solving skills

I am looking for an experienced Excel professional to create a dashboard for visualizing my sales data. The primary focus will be on utilizing charts and graphs to present the data in an insightful and clear manner. Key Responsibilities: - Develop an engaging and easy-to-navigate Excel dashboard - Use charts and graphs to visualize sales data Ideal Skills: - Proficient in Excel with extensive experience in creating dashboards - Strong understanding of data visualization techniques - Ability to present complex data in a simple, engaging manner

I need a C# program that can update the creation dates on files in SharePoint Online. The program should get datetime from an Excel (or CSV) file that I will provide. This Excel file will contain 2 columns : files path + datetime values (that should be set as the creation dates). Requirements : - Extensive knowledge of C# programming - Knowledge to connect to SharePoint Online (OneDrive) - Full source code must be release at the end of the project - All the intellectual property will be transferred, without any reserve, to the project owner (databird sàrl)

I'm seeking an Advanced Excel professional capable of creating comparative analysis charts and graphs for financial data, specifically comparing work progress. Key Requirements: - Remote work capability - Expertise in Excel chart/graph creation - Experience with financial data - Strong understanding of comparative analysis - Excellent ability to visualize complex data Ideal Skills: - Advanced Excel skills - Financial analysis experience - Data visualization expertise - Strong attention to detail - Excellent communication skills for remote work

I'm in need of an experienced MIS Executive to assist with a variety of tasks including data analysis and reporting, database ma...tasks including data analysis and reporting, database management, and automation process improvement. The primary focus of the data analysis will be assessing operational efficiency. Key Responsibilities: - Analyzing operational data to identify areas for improvement - Managing and maintaining databases - Implementing automation for process improvement The ideal candidate should be proficient in Excel, as this is the preferred tool for sales data analysis. Experience with other data visualization tools such as Tableau or Power BI is a plus, but not a requirement. Your expertise should help drive operational efficiency and contribute to overall bu...

I have a sales rate sheet on paper that I need converted to Excel. I also need additional columns showing discounted rates, with the discounts calculated automatically at 12.5% and 15%. Ideal skills for this project include: - Proficient in Excel - Data Entry - Ability to work with physical documents - Experience with creating automated calculations in Excel

I'm seeking assistance with formatting an Excel spreadsheet for the reconciliation of an Employee Loan account. Key Requirements: - Expertise in Excel, particularly in spreadsheet formatting. - Experience with conditional formatting, table design and layout, and cell styles and fonts. - Understanding of account reconciliation processes. The successful freelancer will help me present the data clearly and effectively, allowing for a smooth reconciliation process. Your input will be crucial in organizing the data and highlighting key figures.

I need someone with access to Refinitiv Eikon DataStream to download data for all UK listed companies over the last 6 years. List of variables will be shared to the selected candidate. The ideal freelancer for this project should have: - Prior experience with Refinitiv Eikon DataStream - Expertise in financial data analysis - Proficiency in Excel Data Format: - I would like to receive the downloaded data in Excel format. Please provide your previous relevant experiences when bidding for this project.

I need an Excel expert to help me modify and randomize my data. The tasks include: 1. Changing all dates in the “Proc Date” column to only Tuesdays and Wednesdays from July 2024 to December 2024, excluding Christmas Eve, Christmas Day, and New Year’s Day. The dates can be random, in no particular order. 2. Updating the phone numbers in the “Phone” column to: (908) 730-8880 for the entire column. 3. Changing the address in the “Address of the Facility” column to: 1630 NJ-31, Clinton, NJ 08809 for the entire column. 4. Altering the ages in the “Ages of the Patients” column to random numbers between 12-89 for the entire column. 5. Modifying the name in the “Facility Name” column to: North Hunterdon Dental Associates for...