Vba reconciliation macromunkák

in plain English here it is: Check column G of Issued Items and select the worksheet if the content of that cell is Head Office select the worksheet Stock Levels - Head Office, if the content is West Metro select the worksheet Stock Levels - West Metro, if the content is North Metro select the worksheet Stock Levels - North Metro, if the content is South Metro select the worksheet Stock Levels - South Metro, f the content is Gippsland select the worksheet Stock Levels – Gippsland, if the content is North East select the worksheet Stock Levels - North East, if the content is South West select the worksheet Stock Levels - South West, if the content is North West select the worksheet Stock Levels - North West then find the cells that matches the contents of row 3 of the wor...

I am looking for a skilled freelancer who can create a macro to transform a column of text/strings. The transformation required is to split the text into separate columns. I am open to suggestions on how to best format the text during the transformation. Ideal Skills and Experience: - Expertise in Excel macros and VBA programming - Experience with text/string manipulation and data transformation - Strong problem-solving skills and attention to detail - Ability to communicate effectively and provide suggestions for the transformation process.

...I'm looking for an experienced bookkeeper who can provide quarterly bookkeeping services for my small business. My team is already using QuickBooks, so experienced with that software is a must. We need help reconciling our bank account, which would include taking care of our accounts receivable and payable, as well as our payroll responsibilities. Additional services would include credit card reconciliation. We're looking for someone who can take the hassle out of these financial tasks, and allow us to focus on running our business. I'm looking for someone who will act as an efficient and detail-oriented bookkeeper with knowledge of accounting best practices, as well as keep up-to-date on recent changes in tax laws and regulations. This person should be able to t...

I have a function 20 lines of code. Need to convert it into vba

Preparation of Financials and AR reconciliation for the period ending May 31.

Hi, I'm looking for someone to help me with a small Excel project. I just need you fix my formula or find another solution. - I have 2 list in 2 columns (A and C) - I need to find if the text in column C is present somewhere in column A (anywhere in the cells) You will attached the file with my formula (column B) I prefer a solution based on formula, not VBA.

I am a pastor and I use my laptop with Microsoft Word for my weekly teachings. I also use Powerpoint on a separate computer to project slides that go with my teachings. I normally post an image into my Word notes so that I know what slide to bring up on Powerpoint. I want to simplify the task by being able run both Wo...to simplify the task by being able run both Word and Powerpoint on the same laptop and simply link an image that I have pasted into Word to the corresponding slide in Powerpoint. Thus allowing me to click the image pasted into Word and bring up the slide simultaneously through Powerpoint. I was told that it takes a simple macro to do that - and once the macro is created I can just copy and paste it to all of my images only having to change the number of the sl...

Looking for a Micro/Macro-Influencer to promote our brand on Instagram/SM. The influencer should have a large following and be able to reach a wide audience. We are looking to keep the budget for the campaign at less than $500. The ideal candidate should have experience in promoting brands on Instagram and be able to provide examples of previous successful campaigns. We are open to working with influencers who have a niche following, as long as their audience is relevant to our brand. Shopify site sells Adult Toys

Hi Alex, Thank you for building this macro (earlier projects) and agreeing to expand on it. Once I create this project I'll reload the instructions that we have been discussing for the record.

I am looking for a skilled developer who can create a macro to transfer data from an XLSX format excel sheet to an online form on the FRRO site. The project requires transferring more than 20 data fields from the excel sheet to the online form. Ideal skills and experience for this job include: - Proficiency in Excel macros and VBA coding - Experience with online form platforms, particularly the FRRO site - Attention to detail to ensure accurate data transfer - Ability to work efficiently and meet project deadlines

I need a freelancer who can help me with an API call from Rex to Excel for Mac using web query. My primary goal is to retrieve data weekly. The ideal freelancer should have experience with both Rex API and Excel for Mac. The project will involve: - Setting up the API call from Rex to Excel for Mac using web query or VBA - Retrieving data from Rex on a weekly basis - Ensuring the data is accurately imported into Excel for Mac If you have experience with both Rex API and Excel for Mac, please apply for this project.

I need a proficient Excel expert who can create a data entry form with VBA and advanced Excel skills. The purpose of the form is data manipulation and it will need to handle both numerical and text data. The form should have automated calculations to streamline the data entry process. I require someone who has experience in creating Excel forms and is proficient in using VBA and advanced Excel functionalities. The ideal candidate should be able to incorporate automated calculations into the form and ensure it is user-friendly. Additionally, some knowledge of conditional formatting and drop-down lists would be an added advantage.

I am in need of a VBA expert to fix functionality errors in my current time sheet code. The issues are causing errors in calculations and need to be resolved immediately, within 24 hours. I have not made any changes to the code since the issue occurred. Ideal skills and experience: - Strong proficiency in VBA coding - Experience with time sheet applications - Ability to troubleshoot and fix functionality errors - Attention to detail and ability to ensure accurate calculations - Ability to work quickly and efficiently to meet the tight deadline.

Extension of VBA/ Macro Coingecko

the VBA code is not pulling data from the correct location in a table.

...cost-effectiveness and sustainability while still ensuring the facility is well-maintained and operational. Strong communication skills and the ability to work collaboratively with stakeholders will also be important for this project. Very important note : I need a facility management strategy and Facility Management Strategic Plan for previous projects in Saudi Arabia and UAE that has been prepared by Mace Macro , or Mace Operate , or Morganti , or Serco. I need real files and already prepared files for Projects that has been developed recently in Saudi Arabia and UAE by those companies for real estate companies for Projects of the nature of Commercial and Residential and hospitality buildings like hotels. The format of the Facility management strategy file must be either in P...

Hello Freelacers, I need a project with below requirements. 1. The code should be in VBA only. 2. The trading platform to be used for automation purpose could be Angel One, Alice Blue or Kotak only. 3. the automation tool should perform below steps.... .... 1. Should login to trading platform virtually 2. tool should store the OHLC data in excel of any date and any timeframe provided by user in excel sheet . 3. The tool should place the orders in trading platform.

I am looking for a freelancer who is skilled in Google Sheets / Excel to help me with spreadsheet management and macro creation. The ideal candidate should have experience in automating tasks through spreadsheet macros. Specifically, I have a task that I would like to automate, which involves report generation. I am open to suggestions on how to streamline this process and make it more efficient. The ideal freelancer should have the following skills: - Proficient in Google Sheets / Excel - Experience in creating and managing macros - Knowledge of report generation - Ability to suggest improvements to streamline processes If you are interested in this project, please provide your relevant experience and examples of previous work.

Seeking a freelancer to assist with our influencer marketing efforts. Our chosen industry or niche is footballers and investors. We are open to working with both macro and micro influencers. The type of collaboration we are seeking is project promotion. Ideal Skills and Experience: - Proven experience in influencer marketing - Knowledge of the football and investment industries - Strong communication and negotiation skills - Ability to identify and vet potential influencers - Experience in creating effective influencer campaigns - Familiarity with social media platforms and analytics - Ability to track and report on campaign performance

...we have any questions. 4. We have offset Invoices against payments, however, it is possible that some may have been missed the need to know how to identify them and offset them, same in the case of Delivery done for a product and its invoice been raised already, but they are not offset against each other, so where to find those entries and how to offset them. 5. Reconciliation of all documents, We don’t have automatic reconciliation with the banks. Here, hence need help with the same. In short, we are looking for someone with very good knowledge of QuickBooks and Tally to answer a few questions and fix a few minor issues. We anticipate that for someone with good knowledge, this will be just a few hours of work, however, do go through the requirement and get in touch...

I have url with parameters. I want to post request with these paramaters in VBA MS Access using x-www-form-urlencoded and finally read the response

I want to use VBA to connect to my remote mySQL database. I do not want to downlad a connector. If anything needs to be downloaded it should just be the .dll (or other) files that can be loaded through the VBA code.

Thank you Alex, for helping me with these large files1

Ecommerce reconciliation project for Marketplace Skills: Experience with ecommerce platform and reconciliation, attention to detail We are looking for an experienced freelancer to help us with our ecommerce reconciliation on our Marketplace platform. The ideal candidate will have experience with ecommerce platforms and reconciliation, and be able to pay attention to detail. The project will involve reconciling sales and revenue. Please include your experience in your application.

I have attached the spreadsheet. This needs to be done in Google Sheets. Basically, the file you see attached is supplied by my data provider. The problem with the data is that it has fields for 10 phone numbers and 10 email addresses all in 1 line (1 record). The place I need to import the data into only allows 1 phone number and 1 email address. So what I need your script/macro to do is... Put each phone number into a record (line) of it's own and match it up with the corresponding email address. (and copy all of the rest of the data for that record into each new line). So in the example file... Line 2 would basically be left alone Line 3 be a replica of Line 2 with the following changes: Phone 2, Phone Status 2, Phone 2 Tags, and Email 2 would be moved to Phone 1, Phon...

Seeking a freelancer to assist with our influencer marketing efforts. Our chosen industry or niche is footballers and investors. We are open to working with both macro and micro influencers. The type of collaboration we are seeking is project promotion. Ideal Skills and Experience: - Proven experience in influencer marketing - Knowledge of the football and investment industries - Strong communication and negotiation skills - Ability to identify and vet potential influencers - Experience in creating effective influencer campaigns - Familiarity with social media platforms and analytics - Ability to track and report on campaign performance

I am looking for a freelancer to automate the extraction of number and text data from PDF files and input it into an Excel spreadsheet. The ideal candidate for this project has experience with VBA programming language and is skilled in data extraction. Specifically, the project requires the following: - Extraction of number and text data from PDF files - Input of extracted data into an Excel spreadsheet - Formatting of the output Excel file to match a specific format provided by the client - Use of VBA programming language If you have experience with VBA and data extraction, please apply for this project.

I am looking for a freelancer who can fix an existing project management Excel sheet for me. The main purpose of the sheet is to manage my project tasks effectively and tell me when was the last date I worked on it. I would like the sheet to have advanced features such as macros or VBA. The specific task that I need the Excel sheet to perform is task tracking. Ideal skills and experience: - Advanced Excel skills - Experience in creating project management tools using Excel - Knowledge in macros or VBA programming

I need Amazon API two endpoints in VBA. Contact me for more details

need to have a show button macro for value column in the sheet assumptions for the pivot table

trying to create a workbook for our company CPHSP, I have done most of it but struggling with the VBA code to transfer rows from 1 sheet to another, I have got it working but when I more more than 1 row it overwrites the the last row I moved instead of stacking them like a list

I'm looking for an experienced bookkeeper to provide ongoing support for my business in Australia. I currently use Xero for my accounting software and the services I need are accounts receivable and bank reconciliation. I would like my books to be updated weekly. I'm looking for someone who is highly knowledgeable in this field, organized, and responsible. The ideal candidate should have experience with Xero. Please let me know how you can help my business. Thank you!

I want a VBA function called IsPrime(x) that returns true, if x is a prime.

Based on chat discussion: 1. Create a pivot table report for provided dataset (Excel file). 2. Add VBA code for importing data files, updating the pivot table and extending its data source range.

Hello, I have an Excel sheet for real estate investments - no fancy calculations, just some financial ones plus diagrams. I want the Google sheet to look very similar to the original - including the sliders and graphs. There is no VBA in the sheet, just standard functions. I guess the easiest is that you use a converter and then do the troubleshooting. I ll send you the original file, so you can assess the work. Please indicate your experience with Google Sheets.

I need a macro to tranform a simple table in excel ( with all my items for sale ) into an attractive and intuitive excel for my clients to place orders. tasks for the macro: 1. Simple tasks to clean data 2. Make it an "excel to place orders" 3. Display the order with some graphics. I will post the exact transformation need it.

I am looking for a freelancer who is experienced with QuickBooks Online. Specifically, I need help with data entry, reconciliation tasks, and setting up certain features within the software. Ideal candidates will have expertise in the following areas: - QuickBooks Online - Data entry - Setting up features - Reconciliations If you have experience with troubleshooting QuickBooks issues, that would be a plus. However, this is not a requirement for the project.

I am in need of a Macro Specialist who can assist me with a word document.

I currently have an application written in MS Access using VBA. This application contains all my products, my clients, and their orders. This application polls Amazon, eBay and Walmart as well as our own websites for any new orders every 15 minutes. If any new orders are found, the orders are imported into our system and then processed. For orders on Walmart, eBay and our websites we connect to both FedEx and UPS servers to determine the best shipping rate for that package based upon weight, dimensions, and delivery location. For Amazon orders, we first attempt to use AmazonBuyShipping to ship the order, and if for some reason that is unavailable, we ship locally and update Amazon tracking via a feed. The application prints the shipping label and appends a packing list to the bot...

I am in need of a freelance trainer who specializes in providing trainings relating to Advanced Excel, VBA, Automation, Python and other related technology for long-term ongoing sessions. The ideal candidate should have experience in providing technical training to individuals as well as to corporates with an advanced level of expertise. The training sessions will be ongoing, so I am looking for someone who can commit to a long-term engagement. Skills and experience required: - Advanced technical skills training expertise - Experience providing ongoing training sessions both online and offline - Excellent communication and teaching skills - Ability to tailor training to individual needs - Familiarity with industry-specific software and tools The trainer will be responsible for...

write a macro to extract information from multiple tabs

Responsabilidades da Métricas Boss no processo de auditoria ● Plano de Mensuração ○ Definição de macro e micro conversões do negócio (objetivos principais e secundários do usuário no site); ○ Documentação técnica com base nas conversões mapeadas; ● Viabilização técnica das implementações por parte do cliente junto ao time de tecnologia; ● Diagnóstico de Google Analytics 4 utilizado em produção; ○ Auditoria dos usuários com acessos a propriedade; ○ Análise de retenção de dados; ○ Análise do fluxo de dados; ○ Análise do modelo atribuição padrão; ○ Análise da configura&cce...

I am looking for a freelancer who can edit the VBA Macro code for me. Currently, I am facing issues with saving down emails with a specific subject line in the folder due to functionality errors in the code. I have the source code available and I am using Microsoft Office 2016 or later. The ideal freelancer should have experience in VBA Macro coding and be proficient in debugging and troubleshooting syntax and runtime errors.

...developer to make some changes on Audacity. Specifically, I need two text boxes and two buttons added to the macro manager. The first box i can put a number in it and it will create a macros with that number, lets say i putted 10 it will create 10 macros in sequence numbers, like macro 1 macro 2 macro 3 and so on, also the second box should be the number of macros inside the next macro, macro gonna contain from the previous one, like macro 3 will contain macro 2 10 times and so on, make the first macro contain the order (duplicate)، two buttons are (apply) to apply the effect and (delete all) to delete them all if i want, there is a picture for 62 macros i made with macro 61 been contained in macro 62. ********...

translate a excel worksheet into a combined file

I am looking for a skilled freelancer to create a VBA in Excel that can help automate my sales and purchase processes. It should include data entry based on a rough idea I have. In addition, I need some additional features implemented to make the system more efficient and user-friendly. I am hoping to find a freelancer that can create a program that will help me to easily track my sales and purchases, so I can analyze the spending and keep cost under control. I am also looking for integrations with other software, such as inventory management platforms, to further enhance the efficiency of the system. If you are an experienced Freelancer who understands how VBA works and can develop the project to meet my requirements, please get in touch!

Hi Polina I., As an Accountant Secretary, you will assist with various financial tasks and ensure the smooth functioning of our day-to-day financial activities. Responsibilities include bookkeeping, financial documentation, bank reconciliation, data entry, and budget monitoring.

I'm a Project Manger at a small resoration company. We do not have the funds to update our software, and we work with XACTIMATE to export the estimates to excel, and then format them to an uploadable and workable estimate to import to BuilderTrend. I'm looking for someone who could quote me to create a macro to save hours a week manipulating material PO's and Estimates in excel. Budget is minimum as I would be paying out of pocket myself as an investment to save my time, and could later request reimbursement if the help proves to increase efficiency (which I believe it would)

I'm looking for someone to develop an RPA-based reconciliation process that will analyze invoice data on a monthly basis. This process will help me gain a better understanding of my sales data and make informed decisions based on the insights. The system should be designed in such a way that it can automatically perform the required data analysis every month so that I can stay on top of my sales. It should be comprehensive and able to produce accurate results. If you have the experience and expertise to develop this process, I would be very interested in speaking with you!

I need the macro guru for multiple jobs. Details will be discussed.