Excel macro to hide columns based on criteria punët

I am seeking a professional developer to create a website for my business. Majority of Functions in user dashboard will interact with DB only

I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + ...

I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry

I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!

...looking to develop a comprehensive golf course review platform that is akin to IMDb but dedicated exclusively to reviewing golf courses in depth. Key Functionalities: - User registration and login: Enabling members to create and access personal accounts. - Course search and filtering: Letting users perform refined searches based on different criteria. - Course rating and reviews: Providing users an outlet to leave their feedback and ratings on various golfing courses. - Live world and regional leaderboards: Offering up-to-the-minute rankings of the best golf courses worldwide and by regions. - User profiles: Granting users a personal space where they can view and manage their reviews, handicap, location, and golf cl...

I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.

...seeking a designer to create a stylish/modern, text-based logo for my beard butter brand. The name of the company is Bearded Bully. Our slogan is My Beard Is Bigger Than Yours. I want both the name and slogan on the logo. The chosen logo will find use across various platforms including product packaging, website, and social media profiles. Skills & Experience: - Proficient in logo design - Good sense of typography - Ability to create visually appealing text-based logos - Experience in working with a black and gold color scheme Requirements: - Deliver a text-based logo - The color scheme should feature black and gold to convey elegance and sophistication - The logo should be versatile enough to fit well on product pac...

...an experienced WordPress professional to create an informative website. This site will primarily focus on showcasing product and service information. Ideal Skills and Experience: - Expert proficiency in WordPress. - Strong experience in building informational websites. - Comprehensive understanding of producing effective UX/UI. - Ability to incorporate crisp, well-organized product/service pages. - In-depth knowledge of SEO trends. You will be tasked with: - Designing an easy-to-navigate, engaging website. - Ensuring all product/service information is well-presented and easily accessible. - Incorporating responsive design for mobile and tablet users. - Following SEO best practices to maximize site visibility. The perfect candidate should be able ...

...been done for reference but there are still around 500 products still needing to be done. The focus will be on using the Yoast Plugin to enhance Product titles. Increasing the word count of Product descriptions to around 230 words (sometimes creating from scratch using other sites as reference and or using AI to help), then creating search engine title and focus keywords and repairing URL structures if needed. If working through CSV is easier, a data export can be sent with relevant data columns. Key Responsibilities: - Enhancing product descriptions for improved SEO performance - Optimizing meta tags to drive more organic search traffic - Restructuring URLs to align with best SEO practices - Utilizing Yoast Plugin to ensu...

As a business looking to expand into the Chinese market, I am in need of a reliable and skilled individual to act as my agent there. Your responsibilities will include: - Sourcing manufacturers: You should have experience in identifying and working with manufacturers of stuffed animals. - Quality Control: Ensuring that the products meet the required standards prior to shipping. - Logistics: Managing the transportation and distribution of the soft toys effectively and efficiently. I am particularly interested in tapping into the market for children's toys in China and so the ideal candidate should have a good understanding of the Chinese consumers and market trends in this segment. Your role will be pivotal in establishing our brand and products in China, so I...

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

I'm seeking a skilled developer to design a bespoke, web-based remodeling software that utilizes my specific product. This software should offer: - 2D and 3D visualization capabilities: Freelancers should be experienced in incorporating such features into software programs. The software doesn't need to support room measurement tools or product catalog integration at this stage. Please note, the software will be completely Web-based, so experience in this field will be preferred. Prior background in developing design software is a plus.

The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector would be an advantageous, b...

...need a skilled Wordpress expert to address a migration issue I'm facing with my website. Here's what I need: - **Migration Issue:** The problem I'm experiencing is related to theme and plugin compatibility following the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding...

I'm in ...sponsors to businesses for an international exhibition. This requires strong sales skills, and fluency in either English or French language, or both. As the campaign's main objective is closing sales, the person should be able to confidently pitch and close deals on the phone, ultimately translating these efforts towards achieving the business targets. The ideal freelancer for this job: - Has a successful track record in telemarketing sales - Has experience in the exhibition industry - Strong business acumen - Has excellent written and verbal communication skills in English and/or French - Has in-depth understanding of B2B sales. Take your place among our dedicated team and lend your telemarketing prowess to our international exhibiti...

I'm looking for an experienced developer to integrate a payment plan feature to my website. Currently, I accept credit card and PayPal payments through PayPal gateway. The website is running on Shift4Shop. Key Requirements: - Implement a payment plan feature on the website that allows customers to choose 2 or 3 payment installments. - Ensure the payment plan is processed smoothly and securely, utilizing the existing PayPal payment gateway. The ideal freelancer for this project should have: - Proven experience in integrating payment plan features on e-commerce websites. - Proficiency in working with Shift4Shop and the PayPal payment gateway. - Strong understanding of e-commerce user experience and security considerations.

I'm looking for a versatile graphic desi...Purpose: The primary focus of this project is branding. You need to be able to create visuals that will help build and establish my brand identity. Communication: I prefer to communicate my design ideas and provide feedback through written descriptions. Ideal Skills and Experience: - Proven experience in photo editing, logo design, video editing, social media graphics, motion graphics, and product packaging. - Strong portfolio showcasing successful branding projects. - Excellent communication skills and ability to translate written descriptions into high-quality designs. - Experience working with a variety of design software. - Creativity and a keen eye for detail. If you're a graphic designer who meets t...

...assign you based on your results. So, you can easily earn $750 weekly if you provide quality appointments. --- We are looking for a long-term partnership. We have demand for multiple locations in the US, Canada, and Australia. --- You need to have your own dialer and leads (We have ppl working with us using Google Maps and --- Qualification criteria --- A business with the REAL possibility of becoming our client: NOT pushing appointments, NOT people just looking to compare prices, NOT people happy with their current services. They need to provide a reason on the call why they want the appointment, for example: "I'm not satisfied with my current company." "I'm doing the cleaning in-house, but I would like ...

...experience in DeFi app development, particularly related to Liquidity pools, Yield farming, and Staking rewards. Key requirements for this project: - Creating a DeFi application that incorporates the above-mentioned features. A fully automated platform, that searches for highest return per transaction, and yet lowest or no risk opportunities in , liquidity pools , arbitrage of all sorts, staking, yield farming and any potential combination to achieve same goal. Ideally, this will be a platform similar to Krystal, but with the added features of above automation based on user request for each item of opportunity. Software must be able to find, on all existing platforms and exchanges these opportunities, evaluate risk factor, and based...

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. ...

I'm looking for a skilled developer to create a custom script for Jira Cloud. The script should modify the behavior of a select field within the platform. Key Features: - Dynamic Select Field: The select field should dynamically change based on the values chosen by other issues in the project. This means that as the field is selected, it should update to exclude values already in use by other issues. - Hide Values Already In Use: The script should ensure that the select field does not present options that have already been selected by other issues in the project. - Customize Form Behavior: The script should also allow for custom form behavior in Jira Cloud. This project requires a developer with experience in Jira Cloud and strong skills in Groovy...

...I'm seeking a self-driven sales professional to scout for potential clients and connect them with my consultancy services. Key Responsibilities: - Proactively engage with startups, introducing and promoting our business strategy consultancy services - Build and maintain strong client relationships, fostering trust and driving long-term business - Negotiate and close deals, ensuring mutually beneficial outcomes - Represent our consultancy platform at relevant industry events and networking functions Ideal Candidate: - Proven track record in sales, ideally within consultancy or a related field - Strong understanding of business strategy and its application to startups - Excellent communication and negotiation skills - Self-motivated and able to work independen...

...scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting d...

...tasks: • Data research: You will need to research and find the best prospects for my business based on their profile, industry, location, and other criteria. You will need to use sales navigator and other tools to conduct effective data research. • Profile research: You will need to analyze and evaluate the profiles of the prospects you find and determine their level of interest, need, and fit for my business. You will need to use sales navigator and other tools to conduct thorough profile research. • Data filtering: You will need to filter and sort the data you collect based on the most relevant and important criteria. You will need to use sales navigator and other too...

Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards. Develop a bespoke Microsoft Excel spreadsheet to accurately calculate sales commissions. The specifics: - The variables: the spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined accurately according to custom formulas (using the previous variables) that considers the Commission Percentage. - Data input: The spreadsheet will be easy to use, allowing to manually input the data for calculation. This tool (Multi-scenarios Custom Sales Commissions Excel Spreadsheets Dashboards) will enhance efficient determination of commissions, henc...

Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the ...

create a captivating ad for Meta platforms and other digital ad spaces. The ad should feature our logo in a simple yet eye-catching animation, accompanied by additional text to convey a special sale message. so the design should be straightforward and appealing. along with the logo animation. The text should be: Website design and deployment $299 when you mention Spring Sale and or “730” $675 Music Video Production sale. Payments plans available.

I am looking for a skilled developer to create a system that can manage and sell chatbots with AI. The main components include: Control Panel Features: Ability to activate or deactivate chatbots Update chatbots with new responses or features Manage clients and their chatbots effectively Display statistics about chatbots usage Provide access to chatbots' configurations Include a client database with their contact information The system should enable me to sell, update, and manage chatbots with ease. On the flip side, my clients should be able to access their chatbots through a login and utilize them effectively in both English and Spanish. Additionally, it is essential that the chatbot can integrate and be used on social media platforms...

...designer to create a logo and distinct artwork for my merchandise that represents the small businesses and culture of Louisiana. This merchandise will be used to raise money for a Save our Shops (SOS) small business campaign in Louisiana. I am looking for 3 or 4 distinct designs and each can be used on multiple merchandise items. Key requirements: - Exceptional ability in logo design, illustration, and typography design - Proficiency in creating a message in style design. - Deep understanding and appreciation of local culture and heritage. - Appreciation of community and the small business role in creating strong communities - Will need files in reproducible format at least 300 DPI The ultimate goal is to produce designs that express our sense of community...

I am in need of an expert who can assist me with the custom...an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your as...

I'm in need of an engaging landing page that effectively promotes my product or service. The focus is on presenting product features and benefits, testimonials from satisfied clients, and clear pricing information. Key elements to include: - Design: A visually appealing layout that builds interest and trust. Utilize colors, fonts, and images that align with the product/service and resonate with the target audience. - Product Information: Display the product features and benefits in an engaging and easy-to-understand manner. - Testimonials: I want to include positive testimonials from customers to build credibility and trust. - Pricing: Clear and transparent pricing information that helps the visitor understand the value proposition of the product. ...

I require a clean and professional logo for my project management consulting business, Let’s Sort This Out, LLC. There isn't any specific imagery I am tried to, perhaps incorporate a pen, clipboard or excel style doc - I am 100% open to creative suggestions! Ideal designers will be experienced in corporate branding and able to present a portfolio of similar work.

I'm in a rush and need a ski...task is the detailed design phase. I need you to take concepts and transform them into detailed plans, elevations, and sections. There's a deadline to be mindful of, as the completion is needed as soon as possible. Key responsibilities include: - Translating architectural concepts into detailed designs - Creating detailed plans, elevations, and sections - Ensuring the design meets all necessary standards To excel in this project, you should have: - Proficiency in AutoCAD and 3D Max - A deep understanding of architectural design principles - Experience in detailed architectural design - The ability to work efficiently under pressure and meet tight deadlines If you're confident in your skills and can deliver ...

Want to gain experience of building a website while making a meaningful, measurable positive impact? I am looking for a knowledgable website builder/design volunteer to help me launch a website for my social impact business. Individual will need to work beyond scope of templates, and know how to create a website that compiles and lists information from many sources into a database that is searchable by many criteria, and that can be updated frequently with new data. Think a smaller but for social impact :) Due to the nature of the business, I cannot offer payment at this time, so this individual must be happy to volunteer for the experience and portfolio building. I am keen to get started, and have a clear vision for this - but am h...

Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.

I need an Android or PC based application for creating quotations, generating invoices, and tax receipts. It should support offline functionality, with essential features available without an internet connection. Key Features: - Creating Quotations: The app should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintai...

I'm planning a crowdfunding campaign to raise funds for a charity or cause. I am in search of a crowdfunding expert to help me navigate this process and ensure the campaign's success. Key Duties: - Develop a detailed strategy: I need someone who can create a comprehensive roadmap for the campaign. This involves setting clear objectives, timelines, and milestones. - Identify and engage specific interest groups: My target audience is specific interest groups. I need the candidate to have experience in identifying these groups and be able to effectively engage them. - Optimize the campaign for maximum impact: I am looking for a professional who can help me craft a compelling message and implement strategies that will drive engagement and donations. -...

...developer to create a customized text-based chat platform using WordPress and chat plugins. Requirements: The chat function must align with a client’s credit limit and rate per minute. The chat should close automatically when the client’s credit reaches zero or if the client decides to end it. The system should handle disconnections gracefully, maintaining the client's credit balance by deducting only the time spent. The client's credit balance should always reflect the amount spent and the remaining balance available for future use. The deduction rate should be accurate, regardless of whether it's 0.5, 1, or 2 credits per minute. The system should automatically track and deduct credits based on the time spent in chat. In ...

...both back and front end development, to join my team on a long-term basis. The selected professional will be the go-to person for multiple upcoming projects in the B2B space. Key Responsibilities: - Develop and maintain E-commerce platforms & Laravel Developed Softwares - Build and manage Custom CMS systems - Implement and integrate APIs effectively, know Frontend like html, css, Vue.js, react.js etc - Ensure the systems are robust and scalable Ideal Candidate: I'm looking for a Senior-level Laravel developer with over 4 years of demonstrable experience in the field. - Strong knowledge of both front and back end development with Laravel - Adept at database management and structuring - Proficient at creating responsive, user-friendly interfaces - Abilit...

...both Facebook and Instagram. - Selection of the profiles for scraping should be primarily based on the following criteria: levels of user engagement and followers count. - Along with the email addresses, extract additional user information namely: the account name and its location. Ideal Candidate Profile: - Must have experience in deducing complex social media algorithms. - Understanding of digital privacy laws to ensure compliance during the extraction process. - Fluency in software that can automate this extraction process would be advantageous. My ultimate goal is to utilize this function to better target digital marketing campaigns, increasing its reach and effectiveness. I look forward to discussing the project details wi...

I need a professional SEO expert to optimize my website in order to improve our search engine rankings on Google. - The main goal for the project is to increase organic traffic and visibility on Google. - I have a list of specific keywords and phrases that I would like to target. - The work is urgent, so quick and effective execution is essential. Ideal Skills and Experience: - Proven track record of successful SEO projects, especially on Google - Expertise in keyword research and optimization - Ability to implement and execute strategies quickly, with a focus on achieving results in a timely manner. Please include any relevant past projects or case studies in your application.

...this integration is to offer users the ability to make voice calls directly through the platform. Key Requirements: - Implementing Telegram VoIP for seamless voice communication - Focused on making the feature user-friendly - Web-based platform The project's primary goal is to introduce a voice calling feature that is both easy to use and reliable. Hence, your expertise in Node.js and experience with TDLib will be vital. The ideal consultant will understand the nuances of VoIP technology and be able to seamlessly integrate it with our existing web application. Your role will be to provide guidance on the integration process, ensuring that the end product meets the needs of our users. Any prior experience in simila...

I'm in need of assistance with an image data entry project. More specifically, the task involves manually categorizing less than 500 images. Key Responsibilities: - Categorizing images based on specific criteria provided - Ensuring accurate and consistent categorization across all images - Completing the task within the specified timeframe Ideal Candidate: - Experience in image data entry and manual categorization - Attention to detail and ability to maintain consistency - Efficient and able to meet deadlines Please apply if you have prior experience in similar projects and can commit to the specified volume of less than 500 images.

I am searching for a talented meme creator to produce entertaining, image-based memes for a general public audience. - The primary purpose of these memes will be to entertain, rather than focusing on brand promotion or social media engagement. - The memes are to be crafted for a general public audience, so a good understanding of mainstream humor and pop culture references is essential. Ideal skills for the job include: - Graphic design and image editing - Proficiency with popular meme formats and trends - Creativity and a good sense of humor - Understanding of mainstream humor and pop culture references I am looking for someone who can create engaging, shareable memes that will resonate with a broad audience.

We are a manufacturing company in need of skilled freelancers to quickly create a total of 480 product renderings from provided CAD drawings. Products include columns, decorative brackets, pergolas, railing systems, cornices/mouldings, etc. Scope of Work: 1. Create product renderings from provided CAD drawings. Requirements: • Proven experience in object rendering. • Ability to deliver high-quality work under tight deadlines. • Excellent attention to detail. Timeframe: We are looking to have this project completed as soon as possible. Please mention your estimated completion time in your proposal. Application: Please include examples of previous similar work and your proposed timeline for completion. Bids without examples and a clear ...

...this integration is to offer users the ability to make voice calls directly through the platform. Key Requirements: - Implementing Telegram VoIP for seamless voice communication - Focused on making the feature user-friendly - Web-based platform The project's primary goal is to introduce a voice calling feature that is both easy to use and reliable. Hence, your expertise in Node.js and experience with TDLib will be vital. The ideal consultant will understand the nuances of VoIP technology and be able to seamlessly integrate it with our existing web application. Your role will be to provide guidance on the integration process, ensuring that the end product meets the needs of our users. Any prior experience in simila...

I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward to receiving your proposals!