Vba reconciliation macromunkák

I have a need for a VBA Microsoft Visio expert. The project primarily revolves around this specific task: - Automation of rectangle geometric shape creation. The detailed requirements include: - Developing a VBA code that can automate the creation of rectangles in Microsoft Visio. - The shapes must be created accurately and efficiently, with minimal margin for error. - Familiarity with geometrical shapes, especially rectangles, is a must. Also Add picture to shape , and grope . The ideal candidate for this project will possess a deep understanding of Microsoft Visio and Visual Basic for Applications. Experience in automating shape creation, specifically in dealing with geometric shapes in Visio, is crucial for successful completion of this project. This knowledge and ex...

I am in need of an expert Word VBA programmer to: - Develop custom macros for Word documents - Make these macros capable of converting Word files (.docx) to PDF, and vice versa (this PDF file -> .docx) using the (PDF to WORD Converter) website. The ideal freelancer for this project will: - Have in-depth knowledge and experience in Word VBA programming and macro development - Be familiar with file conversion resources such as - Be capable of thoroughly testing the macro to ensure it functions correctly, specifically for document conversion. The goal of this project is not only to automate document conversion, but also to enhance workflow efficiency. If you are keen on taking part in this project, kindly send in your bids.

I urgently require professional assistance with Tally Prime. Specifically, I'm seeking intermediate to advanced training and support to master the following functionalities: - Importing Bank Statements & undertaking Reconciliation - Undertaking GSTR Import and Reconciliation - Importing Vouchers from XLS Files This project has a tight deadline and I expect completion of the training within a week. The right freelancer for this job must have a comprehensive understanding of Tally Prime and possess the capability to train and provide support on an advanced level. You should also have a strong track record in similar projects and be ready to start immediately. Please confirm your availability and readiness to meet the outlined timeframes in your bid.

I'm in need of a skilled VBA coder to help enhance the functionality of Microsoft Word. The specific functionalities required are: - Document automation - Text formatting and styling - Data extraction from documents The Word document essentially consists of tables. The tables have different numbers of rows and two columns. The first column should only contain text. There should be a checkbox in the second column. The checkboxes should initially be hidden. The checkboxes should only become visible when you activate the “Show all” function. If the check box is selected, the text in column 1 should have a specific target style assigned to it. If the check box is cleared, the text should be mapped to another style that is defined to have the text hidden. If I de...

We are seeking a skilled web designer to revamp the front end of our company website, IDIGITALPRENEUR, to align with our global expansion initiatives. The redesigned website should exude professionalism and incorporate modern design elements, including micro and macro animations, to enhance user engagement. Current Website - Key Requirements: - Redesign IDIGITALPRENEUR website to reflect a modern, global brand image. - Incorporate micro and macro animations to elevate user experience. - Maintain a professional aesthetic with a preference for a dark color theme, though light colors can be utilized as needed.

As a real estate owner, I need an ambitious Excel expert to develop a professional spreadsheet for managing my properties' rental income and expenses. With each listed property, manual entry will be utilized for inputting income and expense data. In this project, the focus is on tracking individual real estate assets and not t...categories for easy tracking and assessment. - Monthly/Yearly summary: It should provide a clear and concise picture of the monthly and yearly income and expenses, aiding in financial decision making. The ideal candidate for this job should be a seasoned Excel professional with a track record in financial management spreadsheets, particularly properties and real estate. If you have proficiency in VBA, that can elevate the spreadsheet to an even more o...

As the initiator of this project, I'm on the lookout for an intermediate-level VBA specialist. I am looking for someone who have Finance background, While the specific tasks were not laid out, the hired freelancer should be comfortable with various activities, including but not limited to automating data entry, generating reports, and creating macros. The key skills and experience required include: - Proficiency in Visual Basic for Applications (VBA) programming language. - Ability to automate tasks, create macros, and produce reports using VBA. - Demonstrated experience in a similar role or project. Please highlight your experience in your application. Remember, your ability to showcase your skills and past success in this area will significantly impact the...

VBA basics but no time to do it. I have already started the 1 step of the project () Can you please finish it ? Everything is explained on

...- Implementing a system for financial data reconciliation and dynamic reporting - Drafting advanced Excel tasks Primary Features: - The automation process should include data extraction and reconciliation functionalities. Ideal Skills: - Extensive experience using Power Automate - Solid grasp of SAP and Financial Data - Advanced Excel skills - Previous involvement in invoice management systems - Strong knowledge of data extraction and reconciliation mechanisms Scope of Work: SAP Automation: Utilize Microsoft Power Automate Desktop RPA to automate tasks within SAP ERP, including data filtering, extraction, and report generation. Integrate Power Automate with SAP using no-code solutions for seamless data transfer. Financial Data Reconciliation: - Aut...

I am looking for a freelancer who can make moderate changes to my VBA software in Excel. Here are the details of the project: Type of software: VBA in Excel Function or feature: I do not have a specific function or feature in mind for the software, but I am open to suggestions. Level of customization: Moderate changes are needed for the software. Ideal skills and experience: - Strong proficiency in VBA programming in Excel - Experience in customizing and modifying existing VBA software - Ability to suggest and implement improvements to enhance the software's functionality and usability

VBA basics but no time to do it. I have already started the 1 step of the project () Can you please finish it ? Everything is explained on

Primero, recibo los pedidos a través de WhatsApp. Luego, transcribo los nombres de los pedidos en un documento de Excel. Utilizo una macro VBA en Excel para generar archivos individuales para cada nombre listado en el documento. Estos archivos se crean a partir de una plantilla base llamada "libro ". Una vez generados los archivos, los protejo manualmente uno por uno utilizando un programa externo. Finalmente, adjunto cada libro de Excel protegido a los respectivos contactos de WhatsApp. Estoy interesado en automatizar este proceso y me gustaría explorar diferentes propuestas para lograrlo. Próximamente, compartiré un video detallando el proceso actual a través de un mensaje directo. puede ser web, que funcione tambien con el cel...

The main task will be to automate the process of downloading PDF files. The desired macro should: - Navigate to a specific URL - Download all PDFs - This includes navigating to the next page(s) until all PDFs downloaded. Do not use the "All" link, use the "Next page" link. The macro should do the downloads page by page. The page URL is All this can be done with the open-source version of (free!). Screenshot attached. We need this macro within a week. So please only bid if you can work on this now. In your bid, please mention "within-a-week". Sorry about that, we need that filter to avoid all the spam bids.

I'm looking for an individual with proficiency in Microsoft Excel and Microsoft Word to assist me in generating delivery notes. For this project, your tasks include: - Reading data from an Excel spreadsheet and populating it into a Word template for the delivery note. The data to be transferred includes: customer names and...descriptions, and quantities. - Automating this process for all entries in the spreadsheet in such a way that each entry generates a separate delivery note automatically. - Replicating this delivery note for all the 92 notes captured in the Excel spreadsheet. In addition, you will be creating a PDF copy of each finished delivery note. Possessing experience in visual basic for applications (VBA), data processing, and automation will be advantageous...

I urgently require an expert to lift protection from a VBA macro in my Excel 2007 document. A complex password (10+ characters, including symbols) protects the macro. Here's what's needed: - Thorough understanding of Excel 2007 and later - Proficiency in dealing with complex passwords - Demonstrable experience in unlocking protected VBA macros The document itself is not password-protected and remains accessible. However, the VBA macro within is locked. I am specifically looking for a problem-solver with a track record in removing complex macro passwords without affecting the functionality of the macro. Please only apply if you meet these criteria.

I am currently running a subscription to QuickBooks Online and I am struggling with several tasks that demand professional attention. This includes transaction categorization, properly recording invoices, and generating reports to prepare for taxes. I need someone with a background and expertise in QuickBooks-online to help me manage my single bank account reconciliation in the system. Ideal Requirements: - Profound knowledge of QuickBooks Online - Experience with transaction categorization, especially invoices - Assistance cleaning books and properly record transaction for 2023 tax prep - Able to generate financial reports in QuickBooks so I can prepare taxes. - Accurate and detail-oriented in managing accounts. - ability to join online meeting to work through initial effort Your...

I need a freelancer adept at Excel and Visual Basic for Applications (VBA) to assist with a project that necessitates basic data manipulations and formulas. The application is primarily dealing with both numerical and textual data. The ideal candidate should possess: - Proficiency in Excel functionalities and VBA scripting. - Experience with handling diverse data types like texts and numbers in Excel. - Ability to quickly comprehend and effectively manipulate data structures using VBA. Kindly submit your bids if you meet these requirements and can efficiently solve complex data problems.

...analyst-forecasted growth rate, and the expected industry P/E ratio. 2) Support work a) Well-structured and well-labeled worksheets and VBA code to support your presentation Questions to consider and take into account for the finished project Is the spreadsheet's broad purpose immediately obvious? Is the output of the spreadsheet AND its meaning clear to the user? Is your analysis correct? Are there any hard-coded numbers (other than numbers that would never change in the formulas? Can the user (or developer for some of the assumptions) change each assumption and see that the model adequately reflects changes to each assumption? Are all cells and the VBA code labeled appropriately? Does the spreadsheet look aesthetically pleasing? (Yes, colors matter...

Hi Need to send and receive e-Mail from G-Mail. Need to use oAuth2

check reference image, excel insert row & copy the value from above row

I am attaching a file that includes the current output with notes. You can see yellow highlights as to what needs to be corrected in the existing code. Then I need a second macro to output data into the DoD_merge template. I added notes to that docunment.

I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.

I'm in need of a detail-oriented professional for a simple data entry job. The core of the work includes: - Transferring information from PDF files into an Excel spreadsheet - Ability to accurately input raw data without altering information Ideal skills and experience: - Proven experience in basic Excel data e...into an Excel spreadsheet - Ability to accurately input raw data without altering information Ideal skills and experience: - Proven experience in basic Excel data entry - Proficiency in handling PDF files - High attention to detail - Fast and accurate typing abilities Please note, this project doesn't call for intermediate or advanced Excel techniques like formulas, data sorting, pivot tables, or VBA. The successful freelancer will strictly be transferring dat...

I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.

I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. Key tasks include: 1. Utilizing VBA to automate the generation of project summary reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is highly desirable. I'm looking for someone who understands project progress reporting and can deliv...

...affecting my code. Specifically, it is producing incorrect outputs when engaging with certain external systems. Key tasks include: - Identify the root cause of the output error - Troubleshoot and rectify the logic flaws causing these errors - Make sure code is efficient, secure, and maintainable The ideal candidate for this role will have: - Proven experience working with Lisp and Autolisp even VBA. - Troubleshooting and debugging expertise - A good communicator that can take my rudimentary directions. To make it short, I have a code that is used for underground drilling permits in the CAD environment. I have a LISP suite that stations a line by generating notes, that generates MLeaders when the subject of the permit crosses a utility lines and puts it on the layer automa...

I'm in need of an expert in VBA programming and Crystal Reports integration to enhance and extend the functionalities of an existing form in our program. - The form was created with VBA for the purpose of data entry. - The enhancement would involve adding more features to this existing form. - The extension requires integrating it with Crystal Reports for more efficient and agile reporting. - Moreover, I'm looking for someone who can provide ongoing support as needed. The ideal freelancer would have extensive experience in VBA programming, form design, and Crystal Reports. Your portfolio or a demonstration of a similar task you've completed would be much appreciated. A commitment to provide ongoing support on an as-needed basis would be a bonus.

I'm seeking assistance with my Microsoft Access project involving the creation of queries, forms, reports, and a comprehensive description of the databa...after project commencement) - Creation of 2 forms: A Main and a Subform. The main form is to be designed for data entry. - Devising 2 reports based on set requirements (to be disclosed upon project initiation). - Crafting a detailed written description of the entire database system using a provided template. Ideal assistance would come from someone with proven experience in Microsoft Access, SQL, VBA, and database development. A deep understanding of query development, form creation, and ensuring data integrity within Access databases is crucial. Your ability to communicate effectively to explain complex systems will also ...

I'm looking for a professional with Excel VBA expertise who can swiftly help in automating the process of printing specified worksheets from Excel to Word. Here's what's important: * Excel VBA proficiency: This task calls for specialized knowledge of Excel VBA, so your skills in this area will be pivotal. * Existing VBA: I will share the existing vba, the VBA has many tools including the print. * Enhancement required: the existing vba has print funtion where user can print specific sheets, we need to print or covert these sheet to a word file. * Quick Turnaround: I need this project completed ASAP, so ability to work under pressure and deliver on time are key. Please ensure you check the requirment carefully before bidding....

...the end of this week. What are your thoughts regarding this and other options available to me? In addition, there is a credit to D Day directors loan account on line 59 for £2258 which I can find no reason for. Should this be also be removed from calculations? What puzzles me is how did the previous accountants to get the YE2022 figures already submitted to balance if they did a bank reconciliation. What are your thoughts on this? Ultimately the figures for YE2023 not yet submitted need to balance with bank figures, debtors and creditors. So is there any other advice you can pass on to my bookkeeper and I to achieve this. Thank you for your interest....

Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!

I have an Excel document that needs to be updated by reading data from a TXT file. The process must be automated via a script, filling in blank cells, distribute...within the excel document, in the required cells. 3. In the case of data discrepancies within the TXT file, enable an automated resolution by defaulting to a specific value. Leveraging your expertise in data extraction, manipulation, and Excel automation will be instrumental for this project. Ideally, you are proficient in scripts suitable for handling such tasks, debatably the likes of Python or VBA, contingent on your recommendation. Familiarity with Excel data structure is a must. Furthermore, being adept at handling data discrepancies and implementing default values coherently across diverse data entries will be b...

Seeking a skilled economist with experience in t...isn't pinpointed, a broad range of macroeconomic, financial modelling, and data analysis skills are suggested. The successful freelancer will show initiative by providing information about their past work, experience and their proposed approach. Please include these in your application: - A showcase of your previous token launches or similar projects - In-depth understanding and experience in macro economics and financial modelling - Demonstrated capability in data analysis - A detailed project proposal outlining your approach for market research, token valuation, and investor outreach The most suitable candidate will have experience in crypto or financial projects and will be comfortable working independently on this signi...

I'm seeking a proficient developer to create a macro screen recorder specifically for corporate websites. This tool should automate repetitive tasks majorly involving mouse clicks, and should also support recording of keyboard inputs. Key Requirements: - Proficient understanding of website functioning, especially corporate sites. - Strong skills in programming languages relevant to macro recorder development. - Capable of integrating both mouse click recording and keyboard input recording. - Ability to test and guarantee the functioning of the tool on corporate websites. Your primary focus should be reliability and efficient performance of the macro.

I'm in search of a diligent freelancer proficient in QuickBooks Online for monthly bank reconciliations. Responsibilities: - Monthly bank reconciliation in QuickBooks Online Ideal Candidate: - Proficient user of QuickBooks Online - Strong understanding of banking transactions - Detail-oriented - Excellent problem-solving skills - Previous experience in bank reconciliations Please ensure your proposal includes your previous experience in bank reconciliation and working with QuickBooks Online. Looking forward to your applications.

For the Macro program update work

I am looking for a script to automatically add 7 days to a date in a table. The date format is dd/mm/yyyy and the date is located in the column "Not done late +35D". The result should be a new column with the date + 7 days, called "Not done late +42D". Specifications: The script must work on Microsoft Word. The script must be easy to use and does not require any programming knowledge. The script must be compatible with recent versions of Word (2013 and above).

I have 2 unfinished Access/VBA projects. I need assistance to finish the projects. My estimation is 3 working days. Max budget : 100$ Please note that I m also a freelancer. Thanks for you bid

I'm experiencing an issue with my VBA code not running as expected on my Mac with Office 365 version of Excel. I am also receiving error messages when attempting to run the code. I'm in need of a freelancer with a strong background in: - VBA Programming - Excel - Debugging - MacOS, specifically the Office 365 version of Excel Your task will be to inspect my code, identify the issue causing it to malfunction, provide fixes, and guide me through the process to avoid such problems in the future. Your debugging skills will be paramount and your ability to communicate clearly is desired. I expect prompt resolution of this issue, without any loss of original functionality. Please ensure you have the specified skills before making a bid.

...sheet) Botón "Entregar": Debe haber un botón "Entregar" en el sistema. Al presionarlo, se deben activar acciones automatizadas relacionadas con la gestión del pedido. Integración con Excel: El sistema debe poder asignar automáticamente las credenciales y detalles del pedido a un libro de Excel. Esto incluye información como el nombre del cliente y el código del pedido. Automatización con VBA: Ya que utilizo VBA en Excel para manejar estos procesos, el sistema debe ser compatible o integrar esta automatización para facilitar la transición y el mantenimiento. Subida Automática a Google Drive: El sistema debe ser capaz de subir automáticamente el libro de Excel generado...

I'm seeking an expert in VBA coding, financial dashboard design, and crafting Power BI presentations. This project's focus is to: 1. Develop VBA coding 2. Design interactive and dynamic financial dashboards 3. Create an engaging Power BI presentation The ultimate goal of the dashboard and presentation is to: • Thoroughly analyze financial data • Visualize the company's financial performance in a compelling manner • Present clear and concise financial insights The types of financial data that will be included in the dashboard and presentation encompass: • Revenue • Expenses • Profit/Loss • Cash flow • Budget Ideal candidates possess in-depth experience with VBA, financial dashboards, Power BI, and prove...

For convenience I divide the illustration of the project into 2 different parts. PART1: I have an excel file with an "CEL ANNUALE" sheet which shows some personal data and some characteristics of the users of a service. The data is entered into the sheet through a userform called "userform1". The data entered through userform 1 are always recorded in the main "CEL ANNUALE" sheet Among these data are: - an "insertion date" field which concerns the date on which a user was added to the service. - a "resignation date" field which reports the date on which a user concluded the service. In addition to the "CEL ANNUALE" sheet there are 12 other sheets called "CEL 01-24" (which refers to the service status as of January 2024...

necesito una macro que sea capaz de hacer una tarea sencilla: volver el menu de un juego (sería el boton de atrás), darle a "Jugar" y a "aceptar". Esta tarea la debe hacer presionando un botón flotante.

I need a skilled IT professional to handle my network hub and server management issues. Your responsibilities would include: - Server management: Delve into the intricate details of server operation, configuration, and routine maintenance, focusing on a Windows operating system. - Network hub management: Macro-level management of the network hub, ensuring seamless interconnectivity and performance. - Troubleshooting & maintenance: Prompt identification and resolution of issues related to the server and network hub, ensuring optimal uptime and reliability. - Security enhancement: Develop and implement strategies to fortify the security of my servers and network hubs preventing unauthorised access or potential attacks. Key skills include extensive experience in Windows server...

I'm in need of an expert in VBA programming and thermodynamics to create a VBA code for vapor-liquid diagrams compatible with Microsoft Excel. The code should be flexible enough to work with any two components. The following skills and experience are required: - Proficient in VBA code in Excel - In-depth understanding of Thermodynamics Key requirements include: - Usage of the Wagner equation - equation for the saturated pressure : p_i^* (T)=exp⁡((Aτ+Bτ^1.5+C^2.5+D^5)/(1-τ))×P_c. - bull point equation P= 1/(y_a/(p_a^* (T_pr))+((1-y_(a)))/(p_b^* (T_pr))) - dew point equation P= x_a p_a^* (T_pb )+(1-x_a)p_b^* (T_pb) - Ridders method to find the right temperature for dew point and bull point - The code must be compatible with Microsoft E...

...below to be automatically looked up from the values within Table above. Each quarter the Table above will change in terms of the values in the two right columns, and the number of rows will also change. I would like the paragraph to again automatically lookup the referenced values from the new Table. Expertise in Word automation and document editing is essential for this project. Familiarity with VBA scripts for Word or similar is also very beneficial. The chosen applicant should demonstrate an understanding of Word functions, automation techniques, and table editing. In a nutshell, I want a system where I don't have to manually change numeric values within the text every time the Table data updates. Sounds like you? I look forward to reading your detailed proposals!...

I urgently need an expert in Excel VBA who is highly skilled to create a tool capable of storing passwords securely. This task is critical and needs immediate attention. Key Requirements: - Development of an Excel VBA sheet with password storage functionality - Emphasis on security measures: While I skipped the question related to specific security measures, the chosen freelancer should be competent in advising and implementing the most appropriate ones such as data encryption, file password protection or two-step verification to ensure the highest level of safety. Ideal Skills: - Proficiency in Excel VBA - Expertise in data security principles - Knowledge about password storage and encryption - Capability to work under tight deadlines Given the urgency of this pro...

...affecting financial reporting. Excel Spreadsheet Design: Develop a structured Excel workbook that includes: Separate sheets for the original financial statements of both companies. A detailed analysis of the differences between ITA GAAP and Romanian GAAP. A consolidated financial statement sheet with extensive account details according to Italian accounting principles. Financial Statement Reconciliation: Adjust the Romanian company's financial statements to align with Italian accounting standards. Highlight differences and reconcile them in a dedicated column within the Excel workbook. Consolidated Financial Reporting: Aggregate the adjusted financial data into a final consolidated financial statement that adheres to ITA GAAP, complete with detailed account breakdowns. D...

I'm in need of a skilled freelancer who is an expert in Excel 365 and specifically skilled in VBA automating tasks. The main function of this role includes: - Automating tasks in Excel 365 - Utilizing VBA to generate regular reports - Should work in Windows and Macbook both The ideal candidate for this project has strong experience in using Excel 365, with specific knowledge in automating tasks through VBA. I am especially interested in those who have a proven track record of generating regular reports using VBA. Please include examples of similar work in your proposal.

More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data