Search Results for: Visual Basic

I'm seeking an Excel expert to assist with data manipulation and analysis using Macros and VBA. Key Responsibilities: - Develop and implement efficient Macros and VBA scripts for data processing - Perform data manipulation and analysis tasks Ideal Skills: - Advanced proficiency in Excel, particularly with Macros and VBA - Experience with data manipulation and analysis - Familiarity with in...

Delivery Time: 6 days left days

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

I'm looking for a proficient Excel expert who can create a macro for me. The primary goal of this macro is to automate data entry tasks. Key Requirements: - The macro will be handling mixed data (both text and numerical). - It will need to collect data from several excel files and compile it into one comprehensive report. Ideal Skills: - Extensive experience with Excel macros. - Excellent d...

Delivery Time: 6 days left days

Data Entry Data Processing Excel Visual Basic Visual Basic for Apps

Create a Google Sheet with two sheets: Sheet 1: "ProductList" (For storing product details) This sheet will have three columns: Product Name – List of all products MRP Price – Maximum Retail Price of each product My Price – The price at which I buy the product Example Data: Product Name MRP Price My Price Product A ₹1000 ₹800 Product B ₹2000 ₹1800 Product C ₹3000 ...

Delivery Time: 5 days left days

Data Entry Data Processing Excel PHP Visual Basic

I need assistance with importing photos from a specific folder into an Excel sheet, alongside their corresponding prices and descriptions from another Excel file. Key Requirements: - Photos are named with identifiers that align with the Excel data, ensuring a straightforward correlation. - I will provide specific instructions for custom sizing of the images within the Excel sheet. - The descript...

Delivery Time: 3 days left days

Data Entry Data Mining Data Processing Excel Visual Basic

I have a task requiring the conversion of mixed data (text and numerical) from multiple sheets and sections of Excel and PDF files into a single CSV file. Key Requirements: - Proficient in data handling and file conversion - Experience with Excel, PDF and CSV formats - Ability to accurately process and convert mixed data Ideal Candidates: - Detail-oriented professionals with a knack for data - T...

Delivery Time: 1 day left days

Data Entry Data Processing Excel PDF Visual Basic

I'm seeking an Excel expert to create a comprehensive workflow spreadsheet for me. The spreadsheet needs to: - Calculate various values based on specific dates, including days overdue, upcoming deadlines and duration between events. - Utilize 'traffic light' cell colours to visually represent the status of call values. For instance, if a call is 30+ days overdue, the cell should tu...

Delivery Time: 2 days left days

Data Entry Data Processing Excel Microsoft Access Visual Basic

I need assistance with data entry from Excel to Google Sheets. This task involves 1-5 files, some of which contain complex formulas and macros. Ideal skills and experience for the job: - Proficiency in Excel and Google Sheets - Experience with data entry - Ability to handle complex spreadsheets - Attention to detail

Delivery Time: 5 days left days

Data Entry Excel MySQL PDF Visual Basic

My current Excel spreadsheet for tracking sales deals is inefficient and poorly designed. I need an Excel expert with pivot table experience to enhance its functionality and design, so I can manage my business more effectively. Key requirements include: - Automatic color-coding of start and end dates - Efficient data transfer from different sheets - Accurate drawdown of monies owed as payments a...

Delivery Time: 5 days left days

Data Entry Data Processing Excel Microsoft Office Visual Basic

I need a skilled professional in Excel automation to help streamline some of my manual data entry tasks. Key Responsibilities: - Automate the data entry process in Excel - Implement basic data validation during the entry process Ideal Skills and Experience: - Proficient in Excel and familiar with its automation features - Experience with setting up data validation checks - Ability to understand...

Delivery Time: 3 days left days

Data Entry Data Processing Excel Software Architecture Visual Basic

I'm looking for an expert in Excel who can create a Pivot Table from an Excel spreadsheet for the purpose of analyzing data. Ideal Skills: - Advanced Excel proficiency - Experience with Pivot Tables - Strong analytical skills Please note that the specifics of the formulas to be used in the Pivot Table have not been defined yet. So, I am open to your suggestions based on best practices fo...

Delivery Time: 4 days left days

Data Entry Data Processing Excel Statistics Visual Basic