How to filter data in excel using macro jobs

I'm in need of an Excel expert with experience in Visual Basic scripts for a data extraction project. Here are the specifics I require: - Ability to handle 10-50 Excel files - Proficiency in extracting text, numeric, and date/time data - Creation of scripts for automating said data extraction Ideal candidates must have a strong understanding of Excel data manipulation and the ability to automate tasks using Visual Basic scripts. This project's success relies on your seamless extraction of diverse data types and transformation of Excel datasets into efficient, automated processes. Let's boost productivity together!

I am seeking a dedicated freelancer with relevant skills and experience in data entry to help me enter text data from multiple Excel spreadsheets. Here are the project specifics: - Data Source: The data needing entry is sourced from digital files, specifically Excel spreadsheets. - Data Type: The core of this task is the entry of text data. Ideal Experience and Skills: - Proficiency in Excel - High-speed typing - Accuracy and attention to detail - Confidentiality and trustworthiness Your responsibility will be to meticulously enter the text data from the given Excel files. As thoroughness and accuracy are key in this project, I would appreciate a freelancer who can ...

I am looking for someone to assist me with data entry and related tasks in Excel and Word. I need some typing, copy and paste type of data, that needs to be entered in systematic way. Skills and Experience: - working in Excel/Word - Attention to detail - Experience with data entry or typing - Ability to follow instructions and work independently Preferred Format or Template: While I don't have a specific format or template in mind, I have a rough idea of how I would like the data to be arranged. I am open to suggestions and willing to collaborate on finding the most useful format for the data. If you have experience in data entry and ar...

I'm on the hunt for a proficient typist with an eye for detail. Your task will be to manually convert a PDF document into a Word file. The document is less than 10 pages long, but your accuracy in transcribing it is paramount. The requirements include: * Transcribing basic text from the PDF to Word. * Using a specific font style and size, to be exact, Times New Roman size 12. Ideal candidates will have a good record in data entry, Excel, PDF, and Word tasks. A fast typing speed, a sharp eye for detail, along with a strong grasp of English spelling and grammar are crucial for this job. Please bid if you're ready to start immediately, and able to deliver accurate work swiftly. Looking forward to your ...

...The first task will be to detect and segment objects in images using traditional computer vision methods. It will be necessary to automatically separate the balls from the background and evaluate the accuracy of the segmentation. This task has been completed. Only a report will be written. Feature Calculation: The second task will be to extract texture and shape features. By using appropriate algorithms to calculate the shape attributes of the balls, it will then obtain textural attributes with gray level collaborative matrices. Object Tracking: The third and final task will be to track the movement of a ball by applying a Kalman filter. Working with real and noisy coordinates, it will create a tracking algorithm and compa...

I'm looking for someone who can convert my handwritten sheets into an Excel spreadsheet. - Purpose: This is purely a data entry task. I don't need any analysis on the data, just a simple data entry from the sheets to Excel. - Detailed Formatting: I only require basic formatting. This means simple lists or tables, no need for any formulas, data sorting, or complex formatting. Please note: I will provide physical copies of the sheets to be converted. Ideal skills and experience: - Proficiency in data entry, specifically using Excel - Attention to detail and accuracy - Ability to follow clear instructions - Previous experience in similar tasks would be an advantage.

I am in need of a skilled Excel expert capable of understanding and applying advanced conditional formatting. The project entails: - Data analysis related tasks - Comprehensive use of both pivot tables and Excel formulas/functions - The main focus will be on setting conditional formatting based on both cell values and any contained text Here’s what you’ll need to do specifically: - Configure Excel to change the text color if certain conditions, related to cell value or text, are met - Set Excel to change the background color under the same conditions Ideal skills for this job would include: - Previous work with complex Excel functions and data analysis - Hands-on experience with conditional...

I am seeking a detail-oriented freelancer with experience in data entry and Excel to assist with a daily task of analyzing company data. Requirements: - Daily data entry in Excel for each company, including: - Financial statements - Stock prices - Market trends Ideal Candidate: - Proficient in Excel and data entry. - Experience with financial data analysis. - Ability to perform the task daily with accuracy and consistency.

We have an automated program with few bugs So we are looking who have experience with the following task 1) The program must work with Mobile OTP verification 2) Captcha Bypass using our API 3) Multi windows Run 4) Run on VPS 24/7 5) Windows Compatible 6) Telegram Notification Required 7) Auto Selection 8) Auto Payment 9) Better if you can include AI commands For more details you can discuss with us, Any Automated response will be Ignored

In need of a skilled professional who can help me with an exciting object detection project using LiDAR data. This project primarily involves: - Implementing object detection algorithms on LiDAR datasets. - The detection should be detailed, focusing on specific models like car models and tree species. - The detected object data will be used for research and development, aiming to refine and improve current detection algorithms. The ideal candidate for this project should have: - Strong background in LiDAR data processing. - Proficiency in object detection algorithms, particularly for LiDAR data. - Experience in working with detailed object detection, such as specific models. - Ability to use the detected obje...

...experienced developers to create a custom solution using the Google Maps API. The goal of this project is to implement specific functionality to meet my unique requirements: • Directions and Routing: This is a key feature, as the solution should provide seamless and efficient routing options. • Place Search: I want to include locations on the routes. • Use of Places API, Map Tiles API, and Dynamic Maps API to further enhance functionality. The project should be developed using the Dart or React programming languages. Therefore, significant experience with these languages is crucial for this role. I am also looking for someone with a keen eye for design who can create a custom map interface drawing users in at f...

...professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in...

I have a bulk of printed documents containing textual information that need to be accurately entered into Excel spreadsheets. Key requirements: - Input textual data from printed documents into Excel spreadsheets. - Ensure data accuracy and consistency. - Formatting of text to fit Excel cells may be needed. Ideal skills and experience: - Proficiency in data entry. - Strong attention to detail. - Familiarity with Excel spreadsheets. - Prior experience with similar data entry tasks is a plus. - Ability to work with printed documents is essential. Please provide an estimate of the time required to complete this task.

I'm looking for a Python expert who is able to automate the trading process for me. This script must be capable of placing trades automatically and executing it smoothly. I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Note: I dont know about coding, If you insta...

I'm seeking assistance with a aspect-based sentiment analysis project. I have an Arabic dataset with less than 10,000 entries in an Excel format. The goal is to train this dataset on the araBERT model for ABSA aspect-based sentiment analysis. Key Requirements: - Implementing Machine Learning: You should have a strong background in ML and experience with training models, particularly in the context of aspect-based sentiment analysis. - Expertise in NLP: Familiarity with Natural Language Processing techniques and Arabic language processing would be a significant asset. - Data Handling: Proficiency in handling Excel datasets, processing text data and preparing it for ML model training. The dataset is ready, Your role...

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

I need help with entering simple text-based data into Excel. Additionally, I need data validation to ensure the accuracy and integrity of the data. Key Requirements: - Expertise in Excel data entry - Ability to handle simple text-based data - Proficiency in implementing data validation - Attention to detail to ensure data accuracy This is a straightforward task, but accuracy is of utmost importance. Please only apply if you have experience in Excel data entry and data validation.

Hi Md I., I have another data scraping job, I need a list of all the address - seperated by street number with street name, suburb, state and postcode in excel. The suburb is Hope Island QLD 4212 in australia. Are you able to assist?

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

I require an expert in Excel to assist with the reformatting of dates in one specific column of my spreadsheet. The current date format is MM/DD/YYYY, and I need to modify this to DD/MM/YYYY (01/05/2024). The project involves approximately 150 records. The ideal candidate for this task would possess strong Excel skills and attention to detail. No additional modifications are required. Some 150 records.

...around 70-80 tabs in excel that have projects and some other tabs that it’s not projects and I don’t need them . If I can give you list of tabs that I need to combine they all have same format but first 3-4 rows there is miscellaneous things that I don’t need to combine I’ll combine starting row 5 as example , is there a way to do that and if so what’s the best way ? Knowing that I might add new tabs in future or if a project is done , the person who maintain the excel will replace tab name and put new information . In combined sheet it will give a column at end or beginning of the information I’m combining . What’s the best way to do that ? The main tasks required are: - Merge the...

I'm in need of a talented web designer to create a user-friendly real estate website for my business. Key Requirements: - The site should primarily focus on showcasing and facilitating the purchase/rental of properties. - It must have a property search feature, with the ability to filter by location. Ideal Skills and Experience: - Proven experience in designing interactive and engaging websites, particularly in the real estate sector. - Proficiency in creating intuitive property search functionalities. - Understanding of user experience principles, particularly in relation to property search features. - Strong communication skills to ensure a smooth collaboration and understanding of the project's needs.

I'm in need of a VBA Excel expert to assist with generating weekly financial reports. Key Requirements: - Weekly Reporting: The expert should be able to create efficient and accurate VBA scripts that will automate the generation of excel charts based on our csv files reports downloaded from our service management software on a weekly basis. The chart is basically to display the Technician's daily sales of labour and material sold (shown in separate charts. - Financial Data: These reports will be based on our financial sales data, so the expert should be comfortable working with and manipulating this type of information. Ideal Skills: - Proficient in VBA for Excel: The ideal freelancer should have a dee...

...skilled data analyst to delve into 10,000 Blackjack hands for comprehensive statistical analysis. Key Requirements: - Analyze win rate and dealer's advantage: I require in-depth insights into the win rate and dealer's advantage across these hands. - Excel expertise: The data is in Excel format, therefore proficiency in this tool is essential. Desired Experience: - Statistical analysis: Extensive knowledge and experience in statistical analysis is crucial to provide accurate insights. - Gambling or gaming industry: Background in the gambling or gaming industry would be advantageous to understand the context of the data. The goal is to extract valuable statistical insights to...

Will develop tool in Python (with GUI), to extract images from excel file, based on user input. Will feature log system as well. More details as discussed. Expect quality work as always. Thanks for choosing me once again!

...require a proficient Excel expert to develop a comprehensive yet easily understood dashboard. The dashboard should encompass data on Order Intake, Sales, Revenue Forecast, and Customer Information. - Key Details: - Data Source: The relevant information is already available via APO SAP and BW. You will only handle the design aspect. - Frequency: The dashboard needs to be configured in a way that it's updated every month. - Detail Level: Preference for an Overview Summary level that will make it easy for my boss to grasp the key trends and metrics at a glance and for each BU Manager. - Skills Required: - Strong knowledge and experience with Excel dashboard design is essential. - Familiarity with handling APO SAP...

...proficient programmer to develop a scraping application for the purpose of extracting text data from websites. This project is sensitive, considering that the targeted websites demand API keys for access. Accordingly, the ideal candidate should be familiar with both GET and POST methods as well as API integration and management. Experience with data extraction and web scraping from API authenticated websites is a must. Skill requirements: • Web scraping • HEADERS • CUSTOM HEADEARS • STRINGS • URLLIB • Working knowledge of GET & POST methods • Experience with API authentication • Exceptional skills in data extraction, especially text. • loliscript • SilverBullet i need to get a netflix mass ...

I'm seeking an advanced Excel professional to create a dynamic Excel tool that possesses several automatic functionalities. The Excel should be capable of: - Creating ledgers automatically based on the input of transactions and account types - Generating separate sheets for final accounts immediately after creation of ledgers. - Computing balances and totals automatically, providing real-time financial tracking and analysis. In terms of data input, the Excel should comfortably accommodate both manual input by the user and importing data from external sources. Finally, the dynamic tool should be capable of creating financial statements, including a Balance Sheet, Profit and Loss Statement, and Cash Flow Statement. Ratio analysi...

I'm in need of a professional in data visualization specific to Excel. Tasks include: - Translating complex data into easy to understand, static visualizations It's imperative that you have extensive knowledge of and experience with MS Excel. A background in statistical modeling will be beneficial, ensuring the ability to embrace and effectively illustrate our data.

I want you to help me create a calendar in Sigma, Please note: the Budget is 10 USD The calendar should look like this: Link I want it for "November 2024" Please note: the Budget is 10 USD Please take a look at the attached calendar because I want it to include: Monthly P&L ( like in the attached example) Number of weeks for the month. ( like in the attached example) Note: I want to delete red numbers or red days. Also, you have to add the amount of dollars like in the attached example Delivery, sigma link ****Please note:*** Please note: the Budget is 10 USD This budget is fixed. If you cannot accept the allocated funds for this task, kindly

Objective: Convert actual images into realistic renderings using the Midjourney platform, maintaining the original poses (side and front views). Gender Variations: Develop two versions for each pose: one with a male model and another with a female model. Attire: Female Model: Should be wearing appropriate gym attire, including a sports top and leggings. Male Model: Should be wearing gym shorts; an option to be shirtless should be included. Quality Expectations: The images must be highly realistic and detailed, faithfully capturing the essence of the original poses. It is crucial that the proportions and physical characteristics be natural and precise. Delivery: The images should be provided in high resolution, suitable for use in marketing materials and dig...

I'm looking for a skilled Perl expert to help me remove duplicates in an Excel dataset. The removal process should be based on multiple columns, ensuring a thorough cleanup. Ideal Skills & Experience: - Strong proficiency in Perl programming - Proficiency in data analysis - Expertise in Excel and handling large datasets - Prior experience in removing duplicates from Excel based on multiple columns Communication: I prefer to have project updates through video calls, so please be comfortable with this form of communication. Your ability to walk me through the process will be highly appreciated.

Please Sign Up or Login to see details.

I would like the face reconstruction from a skull at the age when the person died using the CCFR program. It's for a project at the dental school.

As discuss in chat '

...information is required to detail how a website would display SportsBet odds for specific games, how is it done. After the above details have been determined, we will then want information on whether the following odds can be retrieved and displayed on a website from SportsBet: - Game Head to Head Odds - Game Line Odds - Player Over # of Points Odds - Player Over # of Rebounds Odds - Player Over # of Assists Odds - Player Over # of Threes Odds The next item that needs information to be researched and understood is to find the SportsBet Affiliate Program. The information we would like to know on this is: - How do you register with the affiliate program - What does the affiliate program offer? What are the advantages of signing up?...

I need to enhance 50 audio files, which are mostly 5 to 10 seconds long, with an audio filter replicating the atmosphere of an Air Traffic Control communication. Key Requirements: - 4 distinct effects are required depending on which file of the 50. - The first effect should mimic the ground communication with the tower. It should have a Radio AIR traffic control effect, but not as strong as the airborn communication with the tower. . - The second effect should replicate a more amplified Air Traffic Control communication (airborn). - Third effect on a couple of files is to sound very garbled (inaudible sort of). - Fourth effect is totally garbled and cannot hear properly. Expectations: - The final audio files should have a clear distinction between var...

I am seeki...program for me. This program will be responsible for certain data manipulation tasks, following specific rules and functionalities. This is quite an interesting and challenging project which may involve the following: - Writing a Python program that will filter or block specific tags. - Implementing a tag hierarchy, ensuring correct relationships and positions. - Applying formatting rules based on the tags. The ideal candidate for this project should have a strong expertise in Python, as well as a good grasp of data manipulation and structuring. It would be favorable if you have experience with similar projects involving tag-based data handling. Your efficiency in coding, attention to detail, and problem-solving skills will be...

...are seeking a freelancer to undertake a project involving a database of 3,905 online games, primarily available on Steam. The task involves researching and providing valid EAN numbers for each downloadable game version listed in our Excel file. The current file includes titles and other relevant details, but lacks the EANs, which are crucial for our inventory management and logistics processes. Your task will be to fill this gap by identifying the correct EANs for these digital products. This project has the potential to expand in the future to include more games and other platforms. Therefore, we are looking for someone who can perform this work efficiently and accurately. If you have experience in retrieving specific data...

...an expert in Excel spreadsheet design to create a comprehensive and user-friendly accounts receivables sheet for my business. Key Features: - Calculation of total receivables - Aging analysis of receivables - Customer-wise summary of receivables - Report by department - Aging report - Total Sales - VAT report - Report by month Specific Formulas and Calculations: - Sum - Average - Count - Xlookup Data Organization: - By customer name - By invoice date - By payment due date - By month - By department Ideal Skills: - Proficiency in Excel and experience in creating complex spreadsheets - Strong understanding of accounting principles and reporting - Attention to detail to ensure accuracy in formulae and data or...

Urgently require a proficient Excel whizz who can efficiently perform financial calculations and analysis, especially pertaining to crypto sales and purchases. Aside from these, I require assistance in creating bespoke reports and summaries that will aid in decision-making among other business aspects. - **Financial Analysis**: Ability to perform rigorous financial analysis is crucial for this project. This includes but not restricted to calculations of various crypto sales and purchases. - **Report Generation**: Need customized, detail-oriented reports and summaries of all crypto activities in a coherent, easy-to-understand manner. Ideal candidates should have: - Extensive experience and knowledge in managing and analyzin...

I have a project where I need someone to extract data from PDF files and input it into an Excel spreadsheet. Key Requirements: - Extracting data from PDF files - Inputting the extracted data into an Excel spreadsheet Ideal Skills and Experience: - Proficiency in data entry - Experience with data extraction from PDF files - Advanced Excel skills - Attention to detail and accuracy

I am in crucial need of a highly skilled MS Excel professional who can deliver moderate complexity tasks within a tight deadline of 10 days. The project consists of 72 individual tasks involving: - Data visualization - Spreadsheet formulation - Creation and implementation of advanced formulas and macros I am looking for someone who works efficiently, pays attention to detail and is highly skilled in all aspects of MS Excel. A proficient understanding of data analysis and visual representation is definitely a plus. The job demands the combined ability to work rapidly without compromising on quality. The ideal candidate should be ready to start as quickly as possible, adhering to the constraint of a strict timescale ...

...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features a...

...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features a...

I need to scrape base salary information from Glassdoor for about 2000 companies. Key project requirements: - Scraping Glassdoor for base salary and range info only for every job function/title. - Compiling this data into an Excel spreadsheet Ideal skills include: - Proficient in web scraping techniques - Experience with data analysis Website: (it is free but need to register and complete the profile to see the information)

Please Sign Up or Login to see details.

...guys, we have an excel contact list. In that list we have persons & companies with their contact details. We coded an script wich monitors an gmail inbox. When emails are sent from specific mails to this inbox the python script should read the body and depending on the request in mail syript should send requested Excel back. There are 8 different excel saved locally wich the script can take and send back. So depending on the contect of the mail script should choose the right excel file and send this with an text like "here your requested Contact List Periskop in attachment. kind regards" If its help. in attachmend an little python script we wrote to send back an mail

As an entrepreneur, I'm swamped with a ton of tasks and need a hand to get things done efficiently. I'm on the lookout for a professional virtual assistant who is not only fluent in English but also skilled in email management, appointment scheduling, light accounting, and spreadsheet tasks. Here's what the job entails: - Managing my emails and scheduling appointments - Helping with light accounting and maintaining spreadsheets - Entrusted with some data entry duties The ideal candidate would have: - Proven experience in similar roles - Exceptional command over English - Strong skills in using spreadsheet and email tools You should expect to work around 10-20 hours a week. This job requires professional-level En...

I'm seeking a proficient Excel expert to create a master file for our NDT inspection reports. This master file will centralize all our reports and serve as a robust tool for analysis and reporting. Key Task Requirements: - Integrate worksheets from a master worksheet using advanced Excel formulas and functions, ensuring seamless data pulling. - Design needed features including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functio...