Cut columns excel vba jobs

I have a database that I need to extract specific textual information from, in a one-time extraction. The data needs to be structured in an Excel file. Key Requirements: - Extracting Textual Data: You'll need to retrieve text from the database. - Data Structuring: The extracted data should be organized and presented in an Excel format. Ideal Skills and Experience: - Database Scraping: Experience in extracting information from various types of databases. - Data Structuring: Proficiency in organizing and presenting data in Excel. - Attention to Detail: Ensuring that all relevant text is accurately extracted and included in the final Excel sheet.

In the zipped folder, it contains - sample of 2 months dummy data - ea...the zipped folder, it contains - sample of 2 months dummy data - each file contain IND and ENT sheets, some files may only contain either or - "consolidate" excel file is the sample outcome for reference The VBA should work as per below - an input to insert month (free text) e.g. 202301, 202302 etc - choose destination folder and files (in some of the months it contain unnecessary files) - IND sheet to consolidate only IND data from selected files - ENT sheet to consolidate only ENT data from selected files - 'Summary' sheet to provide number of rows overview for both Challenge - whether consolidation outcome can be done in 1 excel - whether it would work with a password en...

I'm looking for a skilled freelancer to create a custom Cashflow forecast template in Microsoft Excel. The template should be specifically designed to provide an intermediate level of detail - think monhtly breakdowns and categorized expenses. Key Responsibilities: - Develop a comprehensive, user-friendly cashflow forecast template in Excel - Ensure the template can handle a monthly breakdown of cashflow - Categorize expenses in a clear and structured manner - Make the output visually appealing and easy to read Ideal skills: - Proficiency in Microsoft Excel - Experience in creating cashflow forecasts - Ability to design and structure data in a logical and visually appealing manner - Attention to detail in categorizing expenses - Understanding of financial conce...

I need assistance in managing my customer data effectively. The ideal candidate needs to set up a system that allows me to keep track of my customer data and generate Excel reports based on this data. Requirements: - Set up a system for me to input and manage customer data - Ensure the system generates Excel reports with the necessary fields - Ensure the system is user-friendly and easy for me to use The ideal candidate will have experience in: - Database management - Excel report generation - User interface design for data management systems Please only apply if you have demonstrable experience in these areas.

...steal banking information from elderly people, often by posing as municipal officials or by robbing them directly in front of tellers banking." [Cut to images illustrating the theft of a bank card.] Narrator: "They then transfer the money to the accounts of young men or women, the mules, who have been recruited on social networks with the promise of earning easy money." [Transition to images of young adults on social media.] [Section 2: Mechanism of fraud] Narrator: "Once the money is transferred to the mule's account, the fraudsters instruct them to transfer part of it to other accounts, often using online money transfer services ." [Cut to online banking transactions.] Narrator: "A small percentage of this is usually g...

...problems. Experienced in the creative design and delivery of social media campaigns Strong attention to detail and accuracy in managing event logistics, budgets, and administrative tasks. Exceptional written and verbal communication skills, including drafting professional emails and event materials. Excellent IT skills and ability to confidently use PowerPoint, Canva, Word and Excel to quickly pick up new programmes....

I'm in need of a skillful web designer to craft an engaging and f...transactions. 3. Product Review System: Customers should be able to leave, read, and respond to product reviews. 4. Ease to track stock count [Critical] 5. Ease to add and remove products [Critical] Special Requirement: 1. Excel Sheet Collation: The site should be programmed to automatically update Excel sheets with appropriate site data. The ideal candidate will be proficient in eCommerce website design, have a solid understanding of secure payment systems, experience in integrating product review systems, and a track record of creating dynamic data collation functions. Proficiency in Excel and related coding specifics will be a significant plus. Your portfolio and past experiences will signifi...

15x48x6, with 6 m between columns, snow load of 1 kn and wind 0.5 kn. Shed will design according euro code.

I need a freelancer preferebly someone with experience in Zoho books. I need to you to add some data from excel to zoho books. You can use the bulk upload feature or do a manual entry. Just need to make sure you are not doing thing in a hurry & adding wrong entries. Each transaction has to go to some expense segment/vendor, must have some experience of doing accounting work. The whole work might take 2 full days, please bid accordingly, you should be able to work between 11 & 8 PM IST & available on call & with remote desktop view.

Hi Denny R., I need to get another cut scene together. The scene will be the priest inside the village talking to a small crowd of villages. He should be standing on a stage talking to the crowd. I have some sketches for you to get an idea from along with the way teh village should look in the image files in the project. I will need these images to be given separately as you did before.

We want the freelancer to understand our requirement and complete it on time

I’m currently in need of a top-notch professional who is skilled in data entry, particularly in Excel. Key responsibilities will include: - Data entry into Excel from Word - Regular upkeep of the database I require someone with the following skills and experience: - Proficient in using Excel and Word - Attention to detail - Data management skills - Dependable and reliable Experience with data entry in Excel is crucial for this project. It's important that you can efficiently transfer data from Word. If you meet these requirements, I’d love to hear from you.

As an established Amazon UK seller, I'm looking for an experienced professional to list my Home and Kitchen products on the platform. i am looking with someone with great knowledge of amazon seller central, list process and product creation using excel spreadsheets and xml imports we have a lot of data and a bank of 50k products we really need an individual with great knowledge of amazon any selro knowledge will be a bonus Key Responsibilities: - Accurate and detailed listings for a range of products within the home and kitchen category - Ensuring that all product details are correctly populated - Adherence to Amazon's guidelines and policies for product listings - Regularly updating and managing existing product listings Ideal Skills and Experience: - Proven experie...

...and considerations for this project are: - **Primary Focus**: The main reason for this conversion is to allow for easy editing of the text in the Word file. Therefore, maintaining the integrity of the text layout, including font size, style and positioning, is crucial. - **Complex Layout**: The PDFs I need assistance with have a mixture of content, including text, images, and tables arranged in columns. - **Image & Table Handling**: It's important that the images and tables within the PDF are editable once converted to Word. So, the freelancer must have the capability to convert these elements in a way that preserves their structure and allows for easy editing. The ideal candidate for this task should have prior experience in PDF to Word conversions, particularly with...

I need a new Excel flowchart that's designed to include symbols like the ones in the attached Visio file. I just wa The ideal freelancer should be proficient in: - Excel: Demonstrated experience creating complex flowcharts in Excel is a must. - Technical Illustration: Capable of replicating and customizing symbols from a provided example. - Attention to Detail: Able to create a clear, legible flowchart that can be easily understood by others. Your application should include: - Examples of your past work, especially any Excel flowcharts or technical illustrations. - Relevant experience that demonstrates your capacity to complete this task. - A detailed project proposal outlining your approach to creating this flowchart.

I'm seeking a PDF editor tool that primarily focuses on basic text editing and supports documents with complex layouts. Key Features: - Bas...text editing and supports documents with complex layouts. Key Features: - Basic text manipulation: The editor should allow me to add, delete and modify text in a straightforward manner. No need for advanced formatting or integrated spell check. - Complex layout support: While the primary focus is on text within paragraphs, the tool should be able to handle PDFs with complex layouts including columns and tables. Ideal Freelancer: - Proficient in PDF editing tools - Experience with handling complex PDF layouts - Strong attention to detail I'm eager to find an efficient and capable freelancer who can deliver a tool that meets my ...

I need a savvy and insightful expert to review and clarify the executive summary and objectives of my project proposal (oil and gas). This task primarily involves: - Proposal has been made, i just need Clarification - Read the whole file that i've been made, and give me an input. - Detailed examination of the executive summary section - Clear-cut understanding and clarification of the project objectives - Specifically, breakdown of the involved tasks The ideal candidate will have a strong background in technical writing and in-depth knowledge of drafting project proposals, with exceptional attention to detail and comprehension. Familiarity with the rigor and structure required in a top-notch proposal is a must. Your task will not involve an overall review of the entire prop...

Please Sign Up or Login to see details.

I want to design a vba code where i can send text or whats app message

I'm seeking an individual proficient in copying and pasting data from various sources into an Excel spreadsheet. While the complexity of the data isn't explicitly defined, a basic understanding and familiarity with Excel are a necessity, so you can format and organize the data accordingly. Key Responsibilities: - Transferring data from different sources to Excel - Basic manipulation and organization of data in Excel Ideal Skills and Experience: - Proficiency in Excel - Previous experience in data entry - Excellent attention to detail

I'm looking for a professional data entry specialist to assist with the input of textual data in an Excel format. The key requirements of this task are as follows: - Experience in carrying out text data entry tasks. - Ability to methodically input less than 1,000 entries. - Knowledge and proficiency in using Excel for data input. - High attention to detail and accuracy for data input. Please ensure that your bid includes an estimation of time required to complete less than 1,000 text data entries in Excel.

Hello Everyone! I need to improve the design of my page created with Elementor. Currently need it it for desktop version. Please note: I am not looking to rebuild, redesign, install new themes, or anything similar. Please refrain from se...These small changes should make the page look nicer and more professional without drastic alterations. I need someone with a good sense of style who can refine my page to look more professional. Please respond if you have experience in stylishly enhancing Elementor pages. Example of my page (please open on desktop version) 1 column version 2 columns layout version I can stay with any layout (1 column or two) if you will be able to make it nice. Thank you!

I'm seeking an experienced Microsoft Excel professional to assist with visual data representation in my Excel sheets. - My primary need is for the successful candidate to help me create clear and comprehensive visual representations of my data using Excel's charting and graphing capabilities. - The ideal candidate should have a solid understanding of various data visualization techniques and be able to recommend the most appropriate type of visualization based on the nature of the data. - Experience with Excel's chart customization features is a plus.

ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)

Seeking skilled debt consolidation professional to address my business's current financial challenges. Currently, we are grappling with over $100,000 in business loan and credit card debt. Our primary approach has been to cut expenses, which helped to a certain degree, but hasn't fully addressed the problem. We are open to other strategies, including debt consolidation, to find a practical solution. Ideal freelancer should have: 1. Proven background in Financial Planning or Debt Management 2. Experience dealing with business loans and credit card debt 3. Strong problem solving, strategic, and planning skills 4. Previously demonstrated success in helping similar businesses minimize and manage their debts.

My Food & Beverage venture needs a talented designer to create a fun & vibrant logo that can perfectly embody our brand. The right candidate for this job would have experience in branding and a strong portfolio that demonstrates creativity and an understanding of the Food & Beverage industry. Key Points: - Design of a unique and memorable logo that reflects the f...- The logo should be versatile and suitable for a variety of uses, from packaging to online marketing. - Understanding the Food & Beverage industry and being able to translate this into the design is crucial. - Proven experience in branding and logo design is a must. This job may also open up further opportunities for future branding and design projects. If this sounds like a project you can excel in, ...

I have a PDF document containing numerical data that I need entered into an Excel spreadsheet. Ideal skills and experience: - Proficiency in data entry - Experience working with numerical data - Familiarity with Excel and PDF - Attention to detail and accuracy

I am looking for a skilled video editor who can help me cr...who can help me create engaging YouTube videos for my cashcow/ automated channel. Key Requirements: - Editing: The videos will need to be edited in a way that captivates viewers - keeping them engaged and coming back for more. - Length: The final video should be between 5 and 20 minutes long. Ideal Skills & Experience: - Proficiency in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro, etc.) - Experience in editing YouTube videos in a way that increases audience retention. - Creativity to come up with engaging visual content. - Understanding of the YouTube algorithm and video SEO would be a plus. If you're a talented video editor and understand the nuances of successful YouTube content, I'...

...and considerations for this project are: - **Primary Focus**: The main reason for this conversion is to allow for easy editing of the text in the Word file. Therefore, maintaining the integrity of the text layout, including font size, style and positioning, is crucial. - **Complex Layout**: The PDFs I need assistance with have a mixture of content, including text, images, and tables arranged in columns. - **Image & Table Handling**: It's important that the images and tables within the PDF are editable once converted to Word. So, the freelancer must have the capability to convert these elements in a way that preserves their structure and allows for easy editing. The ideal candidate for this task should have prior experience in PDF to Word conversions, particularly with...

We need to fetch data from the website to excel sheet in desired format. Its a quick job. Someone with experience can apply.

Hello, I am looking for an experienced data analyst to help me out with a project. I am hoping to find someone to do a statistical analysis on my data set which consists of 1000-10,000 records. The analysis needs to be completed in Microsoft Excel. I am looking for someone with extensive knowledge and understanding of data analysis, as well as the software. Ultimately, I need accurate information to make informed decisions. If you think you have the skills and knowledge to help me out, please reach out! Thank you.

... • Blog section - All type of Users can read, like, share on multiple social media platforms, and add comments on posts (only logged in user), - Admin: content creators can login to write and publish blogs in their desired design and format. Blog contents could be videos hosted on YouTube and other platforms • University data and pages - Admin: o can update university data in bulk using excel or other supported file formats o can update individual university data from university page (separate login for data entry operators, data is published online once validated by a proper assigned user on the admin side) - Public users (no login required) o Can search universities based on key factors such as country, program name etc., - Registered student users (have an a...

I'm looking for a skilled developer who can create a program that will facilitate the sending of multiple emails from an excel spreadsheet, with a PDF attachment. Key requirements include: - Using Gmail as the email service provider. - The emails will be sent to multiple recipients with the same content. - The frequency of sending emails is irregular. The main responsibilities of the program are: - Extracting email addresses and any other necessary information from the spreadsheet. - Attaching a PDF to each email. - Sending out the emails. Ideal skills: - Proficiency in Python or similar programming language. - Experience in working with Gmail API. - Proven track record in developing email automation tools. Please note that while personalization is not currently required, t...

I'm seeking a freelancer skilled in Excel, Numbers, and Constant Contact, to collaboratively prepare and execute a one-time mail merge email campaign. Key Requirements: - Use the provided Excel list to create a mail merge email. - The purpose of the email is to promote a product or service. - Assistance in designing the email content is needed. The ideal candidate should have: - Proficiency in Excel or Numbers for mail merging - Experience with Constant Contact, particularly in executing mail merge - Ability to design visually engaging email content Your role will be paramount in ensuring a successful email campaign. Please include examples of previous work, particularly in email marketing, in your bid.

I have a sizeable amount of data that I need inputted into Excel to generate reports. This data is a mix of textual information and numerical data. There are numerous columns that this data needs to be sorted into. The ideal candidate for this job will have: - Proficiency in Excel and experience in data entry - An understanding of how to organize mixed data into clear, readable reports - Strong attention to detail to ensure accuracy of the entries - Good time management skills to complete the task in a reasonable timeframe. I need the output to be organized, coherent, and easily understandable, so please only apply if you have a strong background in Excel and data entry.

I'm looking for an experienced video editor to work on a video of more than 5 minutes for entertainment purposes. Key Requirements: - Proficiency in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro) - Previous experience editing long videos - Ability to understand the entertainment aspect and create a visually engaging video - Creative skills to potentially suggest improvements or add-ons to enhance the video's entertainment value The video will need to be cut, trimmed, and potentially have text and/or titles added. I'm open to ideas and suggestions for making the video more engaging. Experience in editing entertainment content, or at least a strong understanding of what makes a video entertaining, is a big plus. Please share any relevant wor...

I'm in need of a video editor to cut down and edit a video for my new website. The video is less than 5 minutes, and I'm looking for a clean and engaging final product. Key Requirements: - Duration: The video is less than 5 minutes, and I need all pauses and unnecessary fluff removed. - Style: It's a website introduction video, so the editing should be clean and professional. Nothing too fancy or dynamic. - Specific Instructions: I do not have any specific instructions or preferences for the final video. Ideal Candidate: - Proven experience in video editing, particularly for website introductions. - Ability to create a smooth and engaging final product, through cutting unnecessary parts and pauses. - Attention to detail to ensure the final video is professional an...

I am in search of creative designers who excel at crafting whimsical, cartoon-style characters, specifically, rubber hose characters. While I have skipped specific details about design features and character attributes, I will be open to your individual style and interpretation. Key Requirements: - Proficiency in cartoon-style character design - Strong creative instincts - Ability to incorporate your individual flare while balancing the foundational aesthetics of rubber hose characters Please share your portfolio when bidding, especially any work related to cartoon style characters. This will help me assess if your style could be a great fit for this project.

I need a professional who can help me recover a password for an Excel XLSM file. Key Requirements: - Recover a lost password for an Excel XLSM file - Ensure the process is secure and compliant with standard security practices - Maintain the integrity and functionality of the document post-password removal Ideal Skills: - Proficient in password recovery methods for Microsoft Excel - Experience in data security and encryption - Strong knowledge of Excel XLSM file structure

I'm seeking a skilled professional to create a comprehensive loan statement on an Excel spreadsheet. Key Project Details: - I need all transactions included in the statement, ensuring the document is fully up-to-date. - The statement should not only present the transactions but should also include complex calculations such as interests, balances, etc. - As I'm looking for this as a one-time service, the statement should be designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all transactions are accou...

I'm in need of a proficient designer with experience in SVG file creation for both laser cutting and etching purposes. The project entails transforming my hand-drawn sketch design into an SVG file format, showcasing simple yet specific shapes. The following are the project specifications: - The SVG file will be used for a medium-sized (1-3 ft) project, meaning attention to detail in scale factor is essential. - The material targeted for laser cutting and etching is acrylic. Hence, prior experience working with this material will highly be considered. Ease in following instructions, excellent communication skills, and the ability to creatively interpret sketches into clean digital designs will be key in picking the ideal candidate. I’ve attached a file with an example of one o...

I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. This row 10 need to be deleted to make the spreadsheet work for my import

...as players progress through the endless waves, keeping gameplay engaging and unpredictable. - Design dynamic environments that evolve and present new obstacles or opportunities as players face more difficult waves of zombie pets. - Introduce periodic challenges and special events within the endless mode to shake up the gameplay and provide additional objectives or rewards for players who excel in their survival efforts. 5. Art and Sound Design: - Create visual cues and feedback that convey the increasing intensity and complexity of each successive wave of zombie enemies as players persevere. - Develop audio cues and immersive sound effects that enhance the tension and excitement of facing relentless zombie onslaughts in the endless mode. - Design striking visual e...

I'm in need of a freelancer who can help me parse my VCF file and convert it to a different format. The main goal of this task is to extract the genotype information from the file. input will be VCF file (from ONT whole genome run) and csv file with columns containing rsID, chromosome number, position. output will be same as input csv file, with extra column showing genotype from VCF at the given position can run on Mac shell so either perl or python would be fine. Ideal Skills & Experience: - Proficient in parsing VCF files and understanding genotype data - Experience in converting files to various formats like CSV, TXT, and XLS - Attention to detail to ensure accurate extraction of the data - Knowledge of any data validation methods would be a plus. should be a simple t...

...scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as per the attached excel file. Go to the website Go to Horse Index A-Z Starting with letter A all the way through to the letter Z Most of the fields will be self-explanatory. Some have been separated. Eg 1st 2nd 3rd Starts

..., only certain locations or only scheduling). Teacher Management Teacher Data Upload: Module to add and update teacher information, including: First and last name Email Phone number Subjects taught (both theoretical and practical) Hourly and daily availability Locations where the teacher is available to teach Intuitive interface for quick data entry with the ability to import data from CSV or Excel files. Tabular view of teachers with search and filter functionalities. Hourly and Daily Availability: Interactive calendar to set daily and hourly availability of teachers. Drag-and-drop functionality for easy time adjustments. Ability to set recurring availability (e.g., every Monday from 9:00 to 11:00). Option to add notes or comments for each availability block. Selection of loca...

I'm looking for someone to curate text and image data for me and compile it into an Excel document on a monthly basis. The successful contractor will have experience with using the Internet to collect data and be able to present it in a structured and organized manner. This data needs to be sourced from reliable sources, checked for accuracy, and edited for quality. The contractor must be able to take initiative and use their own discretion in order to create the best results. Additionally, the contractor will be expected to act in a timely manner, ensuring that the data is updated and ready to use on a monthly basis. This project requires attention to detail and good communication skills.

I'm in need of a skilled video editor who can help me with my social media accounts. The videos I create for my two brands usually last between 1 and 10 minutes, and they are posted on a weekly basis. Occasionally I will need a longer video to be cut down into several shorter videos. Key Responsibilities: - Editing of social media videos: The editor will be responsible for cutting, adding transitions, audio, and other necessary elements to produce engaging and high-quality content. - Understanding the brand: As I make videos for two different brands, it is crucial that the editor is able to grasp the unique style and tone of each brand, and tailor the videos accordingly. Ideal candidates will have: - Proficiency with Capcut and Experience with Social Media. These are real vi...

...seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notifications. Familiarity with han...

...harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By Date, Purchase Date, Ship Date, Payment Method, Fulfillment Methods, ASIN, Quantit...