Xls macros reformat datacông việc
rất đơn giản, tôi gửi 1 file ảnh hoặc text có các báo giá, bạn điền vào 1 bảng do tôi cung cấp.
Công ty mình WHy NOt Build tại Melbourne Australia đang làm về lĩnh vực đầu tư, xây dựng và sửa nhà cần tuyển người có những kĩ năng sau: Biết Tiếng Anh - chỉ cần giỏi về phần đọc hiểu Excel VBA Excel Macros Thân Mến,
6 trang pdf, có thể dùng phần mềm convert, kết quả cuối là trang bảng tính có nội dung file pdf, đồng thời so sánh với bảng chi tiết cũ, lọc phần VAT ra (khoảng 10-20 mục VAT). công việc có thể xong trong 1g.
- tôi lấy dữ liệu giao dịch chứng khoán tại 1 website khác. + 1 số dữ liệu trong file XLS của tôi - sau khi có dữ liệu thì phân tích dữ liệu ( thường tôi dùng file XLS) - hiển thị dữ liệu phân tích lên web theo điều kiện tôi đưa ra
I am creating an xls file for an initial database load. I have several source xls files that need to be transferred into a primary xls based on the correct columns. I will provide the source files with the correct data to transpose. More details can be given once the job is accepted.
Need an Excel combinations generator that can generate combinations into a list from multiple numbers. Need an input, numbers will have commas between them, for example (9,12,21,22,29,40). Input numbers 6* and need output of 3 numbers. the result should look like this list. Have the option for output, how many numbers of combinations to choose from. input can be up to 20 numbers and output can be from 1-19. 9,12,21 9,12,22 9,12,29 9,12,40 9,21,22 9,21,29 9,21,40 9,22,29 9,22,40 9,29,40 12,21,22 12,21,29 12,21,40 12,22,29 12,22,40 12,29,40 21,22,29 21,22,40 21,29,40 22,29,40 When multiple inputs are present, they should look like this. Input* 9,12,21,22,29,40 5,18,30,41,46,52 11,14,19,33,44,54 output* 9,12,21 9,12,22 9,12,29 9,12,40 9,21,22 9,21,29 9,21,40 9,22,29 9,22,40 9,29,...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this proj...
...strategies. The project involves: - Adapting advanced financial models: The existing models are highly complex, with intricate formulas and extensive use of macros. The ideal candidate should be comfortable working with such complexity. - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - Financial Modeling Experience: Prior experience in financial modeling is a major advantage, especially with adaptin...
Reproduce and reformat these 6 data sheets in Indesign format. Translate from Polish to English using chat GPT. The drawings of the sofas must be 1/50th scale (1000mm = 20mm). A new layout is expected to use as few pages as possible while respecting the scale. 1/50th. For each product, you will have to add a price that will be communicated. The sample freelancer document is a model of expected result. please edit in indd format.
I ...a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your bid. I appreciate your time and consideration and look forward to potentially working...
I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.
...Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macros, and strong skills in report generatio...
Hi Emilia S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
As discussed, bird netting calculator editable pdf & xls conversion with formulas from excel, next button and submit.
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-t...
I am looking for a fr...tasks: 1) Around 250-300 expense invoices data entering in Odoo (given in PDFJPGTXT). Deadline: 26.04.23 2) VAT file preparation in VAT template, based on Sales data (entered in Odoo already) and based on Expenses (entered by you at step 1), which can be extracted in xls. Deadline: 27.04.23 3) P&L report creation and books closing, particularly entering of missing data for P&L: - HR salary in Odoo (3 entries), - Part timers HR costs entering (5 entries) - rental expenses (4 entries) - new fixed assets' (8 entries for depreciation). Deadline: 05.05.24 Skills and Experience: - Experience with Odoo is required. - Knowledge of VAT for UAE filing and financial record management (P&L standards) is required. - Attention t...
I'm currently preparing for a Microprocessor exam focused predominantly on Assembly Language. I need an expert who can help me resolve issues, especially with the following key topics: - Data Types and Literals - Procedures and Macros - Assembly Language - Arithmetic and Logic Instructions - Memory Interface So, if you possess a good understanding of these areas, along with proficiency in diagnosing microprocessor issues, I would like to hear from you. Your role will not only be to help me understand these topics better but also aid me in applying them appropriately in an exam setting. Looking forward to your informed bids. Ideal skills and experience: - In-depth knowledge of Microprocessors - Expertise in Assembly Language - Teaching or tutoring experience is a plus
I'm in search for a skilled developer to create a complete Office Package, compatible with the Windows operating system. Tasks include: - Word processing application: This should be able to read and write .docx and .doc file formats. - Spreadsheet application: This needs to create, manage, and support .xlsx/.xls file formats. - Presentation application: Here, the application should be capable of creating, editing, and supporting .pptx/.ppt file formats. Ideal Skills: - Experience in developing software for Windows. - In-depth knowledge of word processing, spreadsheets, and presentation software development. - Understanding of the requested file formats. Please note, we're searching for a robust, fully-functional software, and the budget has been set considering the c...
...UI, which has a settings dialog for the rules: - add/delete/update/display (CRUD) operations on rules - user can choose a regex pattern to detect specific phone numbers (from) - user can choose the destination(s) (a list of destinations) with whatsapp, telegram, sms, e-mail - implementation in this MS on the UI only for e-mail (but user can select all the named options) - user can choose to use macros like: - sender phone (smsSenderPhonenumber) - sender name (smsSenderDisplayName) - senders text (smsBody) - senders datetime (smsDatetime) MS3: help to publish on playstore and appstore MS4: implement the telegram integration (forwarding destination) MS5: implement the telegram integration (receiving telegram msgs and forward) MS6: implement sms sending (e.g. to forw...
I'm working on an academic project that requires adva...on an academic project that requires advanced statistical analysis. I need assistance with regression analysis and hypothesis testing. The statistical analysis is for an academic project, so I need someone who has a deep understanding of these methodologies. For the documentation, a comprehensive and professional LaTeX documentation is needed. It should include advanced formatting, custom LaTeX macros, and complex mathematical formulas. Ideal Skills: - Proficiency in regression analysis and hypothesis testing. - In-depth knowledge of LaTeX, particularly in advanced formatting. - Experience in academic projects is a plus. ***It consists of 6 advanced statistics questions and you are expected to write their detailed solu...
Excel to Invoice Automation System My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing software with a new a...
I'm looking for a highly skilled macro coder to assist me with the development of a...for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver hi...
...listing lacks specific task detail. I rely on you to be innovative and foresee potential tasks such as automating data entry, creating macros, or generating reports. Ideal Skills & Experience: • Proven VBA scripting in the Excel environment • Experience with automation, macros, and report generation • Demonstrable troubleshooting skills In your application, please showcase your past work, how much experience you have, and provide a detailed project proposal. While the specific tasks aren't predefined, your application should reveal your versatility and expertise in VBA scripting. The project's ultimate purpose is unknown, potentially involving the automation of repetitive tasks, data analysis, or fabrication of interactive d...
I have a daily dataset of the prices and funding fees of crypto...table format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a clean and user-friendly layout for the output. Your work will significantly ease my daily workload and improve my decision-making process. I look forward to your proposals. Screen of excel file.
...account balance reporting. Optional features include a chart of accounts with automatic generation of accounting entries and export functionality in TXT, JSON, and XLS formats. The ideal candidate should be able to implement these features and ensure they are integrated seamlessly into the existing system. Key Points: - Extend existing module with purchase and sales registration. - Implement correction notes and payment/collection receipts. - Create an account balance report feature. - Optional: Develop a chart of accounts with automatic generation of accounting entries. - Optional: Implement export functionality in TXT, JSON, and XLS formats. - Also required: Develop a receipt form and accounts receivable/payable for clients, suppliers, cash, and banks, as well as for ot...
I'm looking for a freelancer who can type up data from an XLS Excel sheet. The data is related to different categories and I want it organized accordingly. Additionally, I would need some basic analysis done on this data; think simple calculations like sum and average. Ideal Skills: - Proficiency in Excel, specifically with XLS files - Experience in data entry - Ability to perform basic calculations Please note: This project doesn't require any complex analysis like pivot tables or charts, just simple arithmetic operations.
I'm seeking a talented graphic designer to help enhance the visual appeal of my file. The goal is to improve readability, emphasize key information, and to create a visually appealing design. Key Tasks: - Revamp the color scheme, making it bold and vibrant - Rearrange and reformat the information layout for enhanced clarity - Overhaul the typography and fonts for a modern and engaging look - Conceptualize and incorporate a visually representative aspect to the design Upon completion of the redesign, I will need the new design to be executed in Blender. I am willing to pay $10 for the design and an additional $50 for the Blender execution. Ideal Skills and Experience: - Proficiency in graphic design, with a strong portfolio of previous work - Expertise in color theory and v...
...diligent freelancer capable of extracting specific data from a website containing a list of potential investors. The project requires an attention to detail as well as proficiency with Excel or similar spreadsheet software. Key tasks: - Visit a pre-specified website and navigate to the list of potential investors. - Carefully extract the following details for each investor: Name, Fund name, and 'Sweet Spot' investment amount. - Collate this information in a well-organized Excel spreadsheet. - Find and add a link to each investor's LinkedIn profile alongside their extracted details. Specific requirements: - A meticulous approach to uphold the accuracy of data. - Experience or familiarity with Excel or similar spreadsheet software. - Strong data ext...
Excel to Invoice Automation System My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing software with a new a...
I am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database system...
As I'm launching a new business, I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macr...
I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.
Hi Milan S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
...] Each CRM needs to offer a "birds eye" view and efficient centralization of partner team data, activities/interactions, reminders, templates for standardized emails, trackers, etc..... *MUST be able to work independently & intuitively with provided Google Sheets CRM data >> translate similar functionality into Zoho CRM. *MUST be detail-oriented, intuitive, and goal-driven (a mix of self-directed + training new user on functions). > Limited "directions" to follow-.. instead = "intent/goals" to achieve in organizing our partnerships) + log/line items of tasks & interactions..... set up reminders. + storage / display of real estate inventory (line items of basic data fields) - CSV or XLS files used...
I need an Excel macro developed for my employee training tracking workbook. I want to have a feature t...completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee Training Systems: Experience with tracking and managing employee training programs is a plus. - Communication Skills: You should be able to effectively communicate with me to ensure the macro meets the business req...
I need a proficient VBA professional who can help develop an Excel recruitment tracker dashboard. Key components should include: - Display recruitment data in visually engaging formats including bar charts, pie charts and tables. - Incorporate dropdowns using macros form control for flexible data querying. - Capture essential data points such as candidate name, the position applied for and the application status. - Provide tracking capabilities for application status reflecting stages like pending, shortlisted, and interview scheduled. -Should have recruitment metrics like Time to hire, recruitment funnel and other key metrics The ideal candidate should have robust skills in VBA and Excel, particularly in creating dynamic and interactive dashboards. Experie...
...UI, which has a settings dialog for the rules: - add/delete/update/display (CRUD) operations on rules - user can choose a regex pattern to detect specific phone numbers (from) - user can choose the destination(s) (a list of destinations) with whatsapp, telegram, sms, e-mail - implementation in this MS on the UI only for e-mail (but user can select all the named options) - user can choose to use macros like: - sender phone (smsSenderPhonenumber) - sender name (smsSenderDisplayName) - senders text (smsBody) - senders datetime (smsDatetime) MS3: help to publish on playstore and appstore MS4: implement the telegram integration (forwarding destination) MS5: implement the telegram integration (receiving telegram msgs and forward) MS6: implement sms sending (e.g. to forw...
As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.
My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing software with a new automated invoicing system. I look ...
...referred by which marketing person, business owner name, business name, phone number, email, website etc. Many of these things I am open to enter manually in control panel in my laptop, so that they may be part of database for future observation. - Client (Sorting/filtering by date, referred by which business owner, numbers of messages received, data submitted by him) 7. Few questions - How will I be able to sort, filter, download all these reporting in xls format in my laptop? (Because of my age above 50, I can better see at my laptop, rather than at my mobile screen). - In future, how can we categorize changes into small changes (for free) and big changes (you may charge). Ans - yes thats later on as according to changes may warry from 1000inr to 3000inr - Are we going ...
I am in need of a skilled Word VBA programmer who can assist with automating document formatting and creating custom macros. The ideal candidate should be familiar with Office365 Word and have experience working with formatting styles. Key Responsibilities: - Automating document formatting - Creating custom macros The goal is to make a fully functional document with macros based on an example with Word field codes. Ideal Skills: - Proficiency in VBA for Word - Experience with automating document formatting - Strong understanding of formatting styles in Word - Ability to create custom macros - Attention to detail This project is suitable for someone who is looking to apply their Word VBA skills to a real-world problem, and who can work independently to deli...
I'm looking for a skilled freelancer with a strong understanding of Excel, particularly in building macros for data import and operations. Here's what you'll need to do: - Implement an Excel macro that can smoothly import numerical decimal data from a text file. Our perfect freelancer for this task will have: - Proficiency in Excel and VBA programming - Strong knowledge and experience in creating Excel macros - Understanding of data import techniques for decimal numerical data - Experience in handling data input tasks using macros. If you have the necessary skills and have previously handled similar projects, I'd love to get your bid. Thank you.
Potential freelancers: -Past experience in financial services industry (Recommended) -Skilled in running excel VBA/macros, automating excel data & display through line chart Project: (1) Display recent weekly data (2) For past 5 years Key Details: (1) Data source:
I'm in need of an experienced VBA Excel programmer for automation of repetitive tasks, creation of custom Excel functions, and assisting with data analysis and visualization. Key Responsibilities: - Develop and implement VBA automation for my repetitive tasks - Scripting and designing customized Excel functions - Contribute expertise to data analysis and visualization tasks. Ideal Skills and Experience: - Fluent with Excel Macros and VBA - Robust knowledge in data analysis and visual representation - Flexible to work with any version of Excel I'm looking for a completion timeline of within the next month.
I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions
...sheet for auto parts dropshipping. Your task is to ensure accurate information on product descriptions and supplier details. Key Aspects: - Populate Excel spreadsheet with relevant fields: Product description and Supplier information. - Must be proficient in Excel and have prior experience in a similar role, proof of such experience is necessary. - Deliver the final product in Excel format (.xls or .xlsx) Knowledge in the auto parts industry will be a significant plus....
We are a material manufacturer looking for product drawings to be reformatted to reflect the company branding. Existing CAD drawings will be provided as well as all part numbers, logo assets, etc. 1. Reformat. 2. Replace title block. 3. Replace logo. 4. Change part numbers. 5. Provide CAD and PDF version for each drawing. Examples of drawings before and after are attached - it would be approximately 250 drawings. Thanks in advance for your bid.
Have a custom WP theme built on ACF. This is a blog so it is all about making content and presently it is a pain as have to reformat paste content (if paste as text). I need to have ability to paste content from a site/excel/word etc and the content to be formatted correctly for WordPress and strip any HTML from the source. Presently pasting text from a site etc adds the HTML from the source site. The goal is to be able to copy/paste to make content on the blog without having to format text, and for images to be saved to Media Folder without doing manually. Examples of need: - Table o Uses native format from CSS o Remove all bold and format so it just table with text (will bold etc manually after as I think is simpler right?) - Images o Paste and saves directly to media fol...
I need assistance to solve specific problems with my current logo. The issues are mainly related to its size and quality not meeting updated upload requirements. The ideal freelancer for this task should have a keen eye for detail and be proficient in using design software such as Adobe Illustrator for fine-tuning the logo. Specific tasks will encompass: - Adjusting the logo size without compromising on its visibility and appeal. - Enhancing the logo's quality to meet new upload prerequisites. - Finally, deliver the improved logo in my preferred file format, that is JPG. Those with experience in modern typography and iconography are highly sought after. Appreciate your attention to this and look forward to your bids.