Exel macro moneycontrols dataproiecte

Doresc pe cineva care stie sa modifice in Photoshop pozele facute unor bijuterii cu un aparat Sony Alpha 3 cu obiectiv Macro, asa incat sa arate la final ca cele de la Bijuteri Teilor. Va multmesc si astept un raspuns!

Se da urmatorul scenariu: Incazari in data de x,y sau z la locatia x, y sau z cu un echipaj variabil de 1, 2, 3 sau mai multi. Am nevoie sa extrag(copiez) informatia si sa o pun la fiecare om din echipaj in sheet separat. am incercat cu filtre si macro dar imi copiaza doar informatia de la prima coloana de echipaj. se poate cu alta formula sau cu VBA (cod)

Salut - m-ar interesa un Excel macro pentru a lua cateva fields (7 mai exact) dintr-un Excel si a le pune in unul csv-delimited. Sunt formate diferite si ordinea de fields nu va fi aceeasi in cele 2 documente. Ce ma intereseaza e script-ul in sine ca sa pot face eu conversia de cate ori am nevoie. Iti pot trimite samples cu cele 2 documente dar nu stiu cum aici

Prelucrarea produse in format Exel pentru produse online- Corelare codurilor producator cu codurile interne, descrierea produsului cat mai elaborata, poze, atribute complete.

Am nevoie de cineva care stie exel in google sheets pentru a-mi organiza activitatea de la munca. Mai multe detalii in privat.

Dorim sa adaugam noi produse in site realizat cu OperCart 1.5.6, sa actualizam atribute de la alte produse deja adaugate pe site. Sa adaugam si sa actualizam produse pe marketplace-uri. Adaugare produselor ceva mai complexa in sensul ca se doreste a se prelua diverse informatia din mai multe locuri. De asemenea la marketplace-uri prelucrare exel sau csv. pentru adaugare produse in diverse marketplace-uri. La adaugarea de atribute persoana trebuie sa-si dea singur seama de 2-3 atribute ale produsului dupa cum arata si din descrierea produsului: culoare, tip material. Preferabil persoana respectiva sa aibe exeperienta in lucru cu adaugare produse pe OpenCart si de asemenea in adaugare produse pe marketplace-uri

Lucrează în Excel Fac orice este nevoie in exel

Actualizare/reparare sablon scriere tipizate in EXCEL folsind functii macro. Folosesc in prezent un tabel in care sunt introduse date, acesta contine functii macro si genereaza niste sabloane care apoi vin tiparite pe niste tipizate. Doresc repararea unor functii care nu mai genereaza anumite campuri si actualizarea intregului sistem prin care sa creasca usurinta de utilizare si functionalitatea.

Ma intereseaza sa convertesc un cod VB in Java script, folosit de google. Acesta este unul mic care aduna datele din mai multe fisiere excel intr-unul singur. Doresc sa folosesc google docs si foloseste in loc de macro script-ul java.

In acest proiect am facut o prezentare amanuntita a programului exel. Functionalitate, utilizarea barelor de instrumente, introducerea diferitelor tipuri de date (text, cifre, data(calendaristica), ora, formule, functii), editarea intrarilor, crearea si salvarea fisierelor care contin registre de calcul, deschiderea, cautarea si inchiderea fisierelor care contin registre de calcul, lucrul cu foile de calcul, utilizarea domeniilor de celule.

I need a macro tool that can automatically send predefined messages to Telegram. I would like to implement the ability to send messages to Telegram groups without using Telegram bot. MOST IMPORTANT WITHOUT BOT It must be developed in Python. Key Requirements: - The tool should be designed to work on Windows operating systems. - It should be triggered by a specific keyboard shortcut. - The ability to send both text and media messages is essential. Ideal Skills: - Proficiency in Windows macro tools development - Experience with Telegram API - Strong understanding of media file handling in macro tools Please bid if you have the relevant experience and skills for this project.

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrument...

I'm looking for an experienced professional to create a user form macro in MS Project Professional. The macro should have the following capabilities: The key functionality that the macro should have is the ability to filter the project based on selected criteria in the user form, including: - Project Phase: This is a custom field, or Text1 - (And) Work Phase: This is a custom field, or Text6 - (And) Custom Look-Ahead Formula's for 15, 30, & 60 day look-aheads. See attachment but the end user will select one of the three look-ahead options. For the Look-Ahead formula, it should be defined as: IIf(([Start]<([Status Date]+15, 30, or 60) And ([% Work Complete]<100))). It's extremely critical that the candidate has strong proficiency and unders...

...Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data. - Experience with real estate or property development would be a plus, but not essential. Please provide examples of previous work that demonstra...

The report will consist of the following tasks: 1. Identify and justify your chosen global target market and present a market analysis that identifies the macro and micro trends and issues that are currently facing the industry in which your organisation operates and how these relevant factors may impact your market sector. 2. Evaluate and align the organisation’s current approach to expand and operate in relation to at least one competitor. 3. Propose, with justification a customer value proposition supported by academic theory/frameworks for the business strategy for your new ethical product, service, brand extension that addresses one or more of the identified global trends or issues. 4. Create an original customer persona for a specific, sustainable target segment, outlini...

I'm seeking a...develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. Can b...

We have a list of products. We need to check everyday, if those products have strikethrough price appear on them. All the products that need to be checked are from the same website. The following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highlight that G) If the MS...

...user-friendly macro calculator that's accessible on the web. This tool will help individuals in calculating their daily calorie needs based on their fitness objectives, whether it's weight loss or muscle gain. Key Features: - A simplistic yet engaging web interface that allows users to easily input their details - Capability to calculate an individual's daily caloric needs based on their goals - A results page that provides users with a clear breakdown of their macronutrient requirements The calculator will not require user accounts for tracking progress. Instead, users will have the opportunity to download their results after entering in the details for lead generation. This project is intended to generate leads for a coaching service, so the primary focus is on...

I need an Excel expert to help me genera...of Pivot Tables, Macros, and Complex Formulas. Key Requirements: - Proficiency in Excel: You should be highly skilled and experienced in using Excel and its various functions. - Experience with Pivot Tables: You must know how to create and manipulate Pivot Tables to organize the data effectively. - Macro Creation: You will be required to write macros to automate certain processes and tasks. - Strong Command of Complex Formulas: You should be comfortable working with complex formulas to handle the extensive data manipulation required. The end result will be a PDF file containing all possible combinations, derived from the 2048 total objects. If you are confident in your Excel skills and have experience with similar tasks, I&...

Develop macro-enabled Excel workbook

I need a Excel macro that can scrape data from a https://www.ebay.com. The Excel macro should be set to run whenever want to update the data in my spreadsheet. Excel should have Product Name Product UPC Product SKU It will then go to find that Product I want excel macro - list with the number of watches/shoes for that item

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrument...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrument...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrument...

...YouTube Shorts Scriptwriter in the Tech Niche. 1) Skilled Writer + 2) Technology Enthusiast. [Long-Term, Per-Project Pay] We are launching a new YouTube channel dedicated to exploring emerging and interesting technologies. Our goal is to stand out with content that captivates and educates by delving into the latest interesting technological advancements and innovations - from AI products, VR, to macro level tech changes. This role is perfect for someone who is deeply passionate about technology, stays abreast of tech trends, and possesses a witty and engaging writing style. You are always on twitter, product hunt, etc… and you get excited about cutting-edge developments. You will be paid on a per-project basis. Responsibilities: * Write engaging, informative, and creativ...

I'm seeking a talented writer with a nutrition background to create a high protein recipe E-Book for my online training and nutrition coaching business based in Australia, Key project elements: - The book should be in PDF format. - It should include recipes with complete nutritional information, particularly macro breakdowns for each one. - Should include breakfast, lunch, dinner and snack options. - The ingredients should be Australian based- things that are sold in Australia Ideal Skills: - A strong understanding of nutrition, specifically macronutrients. - Experience in ebook writing and formatting, preferably with a focus on recipe or health books. - Ability to create engaging and informative content. - Precise, clear, and concise writing style. Please note, additiona...

I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tracking will be a plus point. ...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrument...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrument...

Preciso que rode conforme video em anexo, eu tentei mexer mas não consegui usar o macro recorder

I have an excel exercise as part of a financial modeling course which i need to solve It is regarding determining debt size and repayment profile while keeping DSCR at a fixed ratio. I will also need to record a Macro of the debt sizing, sculpting and leveling profile

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrument...

Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

I'm seeking a talented writer with a nutrition background to create a high protein recipe E-Book for my online training and nutrition coaching business based in Australia, Key project elements: - The book should be in PDF format. - It should include recipes with complete nutritional information, particularly macro breakdowns for each one. - Should include breakfast, lunch, dinner and snack options. - The ingredients should be Australian based- things that are sold in Australia Ideal Skills: - A strong understanding of nutrition, specifically macronutrients. - Experience in ebook writing and formatting, preferably with a focus on recipe or health books. - Ability to create engaging and informative content. - Precise, clear, and concise writing style. Please note, additiona...

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current systems is instrument...

I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.

Necesito combinar un archivo excel que lo extraigo de un programa extranjero (1r archivo), y que debe añadir de otro archivo (plantilla proveedores) un dato para obtener una excel final (plantilla). El programa debe permitir insertar el archivo inicial, que consulte otro excel para añadir su CIF (el software es extranjero i no lo incluye) i transformarlo en el final (plantilla). Lo suyo sería, inserte archivo inicial, para extraer el archivo final

...can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming - Strong background in data analysis...

...help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be delivered in the next 2 days. If you have prio...

I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclu...the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening...

...Email, using Pulover Macro and AHK where needed. Requirements include: - Automating a series of tasks in Microsoft Excel. This includes data manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and independent management. Ideal skills and experience for this role would include: - Advanced and proven experien...

I'm in need of a macro for MS Word that can automate repetitive tasks. - The ideal trigger for this macro would be a custom button integrated into the ribbon. - The macro should be designed to work solely within Word - The key goal is to automating tasks that I frequently perform. I'm looking for a professional who's experienced in creating MS Word macros. The ability to understand the nuances of my workflow and translate that into an efficient and reliable macro is crucial.

I require exceptional data entry services for a concise assignment, with less than 100 records needing to be entered. The data will be sourced from a database. Even though the project size is relatively small, precision, attention to detail, and the ability to work with databases are crucial skills needed for this job. Applicants should be adept in inputting both text and numeric data accurately and efficiently. Image data handling skills are not necessary as I've skipped this preference. However, being adequately skilled in general data entry tasks will be a definitive advantage.

Develop a macro to fix the columns as requested on our call

As my project deals intricately with WordPerfect, I'm in search of an experienced freelancer who knows the ins and outs of this software. - **Expertise Required**: In-depth knowledge of WordPerfect is a must. Your task will include document formatting, template designing, and macro automation. - **Application Criteria**: Please include proof of your expertise in WordPerfect in your application, such as a detailed description of a project you have worked on or a list of tasks performed using WordPerfect. Show me why you're the best candidate for this task! - **Note**: This project strictly requires WordPerfect skills only. Additional software expertise is not necessary for this particular project. Your exclusive proficiency in WordPerfect will be vital for the highest ...

...specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding of Excel functi...

I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of informa...

PLEASE DON'T BID IF YOU CANNOT WRITE EXCEL MACRO TO SCRAPE THE DATA. PYTHON SCRAPPER DON'T NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experience: - Proficient in VBA prog...

I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.

I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.