Analyse VBA Code (excel Macro codes), and help objectives to running a macro, including figuring out which parts need to change on existing Macros, and tweak / modify as needed. You will need to train on the call how to resolve specific issues as they will have multiple questions. It will be based on existing Excel Macro.
I need a marco to randomly select 42 or so lines from 2 different columns and put them into a template on a new sheet in the same workbook with fields for QTY and DATE, the item numbers and bin locations will come the first sheet. The items selected have to be different everytime unitl the list is complete, then start all over
I am looking for someone to write a script for Microsoft Excel which I can use do remove specific rows and columns from a spreadsheet. It needs to work on a Mac computer. Please watch this screen recording video where I explain exactly what I need
I have (in sheet TEMPLATE) a list persons with data for each person and I want to copy the data from this person to sheet 'DATABASE' and fill in all months with the template value when I click the checkbox 'Fill in all months with this value?' The same is between 'Editing values' and 'Database' sheets.
I need a NEW Freelancer with good experience in SPSS, T test, APA format Tables with Tests I need from Pakistan. I need work for long term
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun
Please update the team members' progress through Teams in real time. If you want to know the details, please contact us further. ※The wishes listed in the file attached can be changed. If there is a problem with construction, you can change it after consultation.
I want to connect data from Excel and Word and have it feed into ChatGPT automatically to create outcomes and run workstreams. Can someone create the API and connections? Open to other platform integrations with ChatGPT such as Slack etc. Welcome feedback and guidance. Thank you!
The project is as follows Move some cells from one row in some columns to the same column one and then delete rows of copied cells. Example Lookup column B value ”6949785206893” (Row #2) Result: column A “6949785206893” (Row #3) Copy Cells of columns E, F, H, P, Q, R, S, T, U, V, W, AU, AV (Row #3) Paste in Cells of columns E, F, H, P, Q, R, S, T, U, V, W, AU, AV (Row #2) Delete an entire row of Result: column A “6949785206893” (Row #3) Continue to next till the end of the sheet (could be up to 40,000 rows) Possible that other sheets need to be created to combine the proper data or to have the lookup values. Also, you may need to add sheets to copy-paste data
I have an excel report that consists of a small dataset (within the sheet called "Data") that populates a number of tables within the report. The tables are pretty basic and contain all the formulas in them. I would like the report moved into Power BI. I have already added the data to the pbix file so it's just a case of creating the measures and replicating the views from the excel version
PHP code to import excel sheet in database. Excel file format is fixed and we need to create a php code to import all data from excel sheet to mysql database using php core code file... 1) HTML Page to select excel file 2) upload script that will upload data from excel sheet to mysql database
we have some data on word document and want to transfer it to an excel sheet, we will provide the template and also we need some research done and find emails and add them as well
...to pdf files ②Conversion to EXCEL BOM Table.(Drawing BOM Table into EXCEL BOM Tables) There are Mechanical Drawings Bill of Material [BOM] is in image format, which is to be converted into Excel sheet table format. Image file Inputs will be shared along with An Excel sheet Reference format. which is needed to convert the BOM image file data table into Excel file data format. Although this is a NON-TECHNICAL job but knowledge of the Excel tool is a must. Little Mechanical know-how might be an advantage, materials and all are present there so converting the original data into excel must remain the same. whatever means of conversion using internet tools or CAD tool is fine to me. 1 Image file and 1 Excel file are attached for you...
Tasks 1. Create a new form on the website using questions already shown on example. 2. I need the data that they fill out on the website to popular the cells on my excel (see example). 3. The form should automatically save a folder to our Google Drive or Dropbox (if preferred). It should be titled the customer’s name and should save their excel and uploaded files inside this folder. I already have this excel set to populate a Word Document (our quotation file), so I just need you to take the data from the website form and put in in my excel.
We do need a Formula or a macro for a data merge between 2 x Excel sheets by 1 x uniq attribute. 1. Excel sheets consist of 2 x rows (A; B). 2. Excel sheet consist of 1 x row (A) Values of row A from sheet 2 can be found into the row A from sheet 1. Corresponding values of row B must be copy into the sheet 2.
Please read the post and then place a bid. Please find the file attached please see the latest file and the work that needs to be done to complete project Spell cast 3 statement model: - Consolidated IS - I had to create a new Thailand Tab "TH Profit and Loss (2)" as this is how I wanted to view for Thailand to be. Please use this to consolidate into SG and TH IS - Consolidated Forecast : This should follow Consolidated Forecast and - Consolidate BS - please consolidate the BS based on the mapping Valuation Year End Model: Please relink the IS and BS after the above is completed. You can send to me first for review before linking the valuation model. - Please be careful if you add rows to make sure following dependent tabs are flowing through. I believe if you add a row i...
...you're comfortable with. The results need to be Bulletproof and accurate. We have used our scraper for some time but want it to run either on my computer or in the cloud whatever is best. This is part ONE as it will accomplish what we do daily by hand. We want to automate these steps first. Later we want to go to another step with these results and put everything into one file by trimming some excel fields. Also, in step two, we want to automate the new scraper program that you have modified to continue to fetch data every 30 to 60 minutes. Please don't send auto BIDS without inspecting the program. IT's not professional and will not be appreciated. Also, we want your best BID. We don't have time to deal with low balls that keep wanting more money or HI...
We are looking for an experienced it person to install and set up XL compiler XLS Padlock. We will be soon launching a company that relies heavily on selling and distributing licences to our spreadsheet software. However, we are currently experiencing difficulties in setting up and configuring the XL compiler XLS Padlock software, which is critical to our daily operations. The free trial version of the software is available for download, so you can get started right away with initial testing. If you have a strong background in IT and are confident in your ability to install and configure XLS Padlock for us, we would love to hear from you. This is a great opportunity to work expand your skills. Please send your qualifications and experience, and let's work together to get this softwa...
Hello, I need someone's help to build an excel file with data given to help with the production schedule of my work and can extract it as one PDF full a4 view (You can do pages if one page is not enough). The file will be split for every customer, like the attached below; please see and join if interested. Also, you guys can DM me for the details for making an example. Really appreciate all your guys help.
Hello, I have a company inventory report taken from an old inventory software. The report is in text but it has irregular spacing between values, new pages headers in the txt file and a lot of descriptions that can be confused for inventory values. I need to convert all this report to an excel sheet, without the pages header and with all the columns correctly distributed. I am attatching the first 6 pages of the report for you to take a look. In total there are 240 pages of this data and all is the same, so the attatched file is all you really need to know what it takes to do this job. Thanks!
I have 2 spreadsheets, both with some products on them. I need to have some editing done on one of them including price changes, showing deleted products, etc. Really need to work with someone as they’re working on it. If you know how to use scripts in Excel, it will probably take less than 30 minutes or so. Automated replies will simply be ignored. I want to know you’ve read and understood it. Thanks.
I urgently need the freelancer to fix the pivot table and the graphs, as the incorrect data is causing significant issues. The filters on the pivot table are incorrect and the graphs are not showing the correct data.
I have some excel PDFfile need to create in Vanva
Hi there. I'm looking for someone to add some formulas to a spreadsheet I use. There are 3 tabs on the attached spreadsheet. This is an invoice tracker breaking down, profit, product category etc. And I want the spreadsheet to calculate automatically the amount of orders, values, GP (gross profit) and lead source. January 2023 tab shows an example of how this is used used month by month Master tab is the black tab that is copied when a new month is started. Master 2 tab is a duplicate of the Master tab and but I have inserted notes in red capitals explaining what I require. I'm looking to make a quick decision on this one. Message with any questions.
You need to enter in the package height weight and dimensions into a CSV sheet to import into WooCommerce. Comfortable working with variation products, Excel/Numbers and completing repetitive tasks quickly.
I am searching for someone with strong Excel skills to work remotely with my startup on a part-time basis. The assignment's goal is to update the annual statistics information and transfer data into Excel, working primarily from current templates. You must have a good eye for detail and have experience in: -manipulating data in MS Excel -using pivot tables -generating standing tables and graphs -creating graphs in Microsoft Word -producing charts in existing style -comparing data for anomalies
Looking to add 2nd possibly 3rd developer to build an Excel Add-in with react and typescript. Please let me know your hourly rate and your experience building an Excel Add-in - React - Typescript
...ask that you complete the following task. Go to this website: Complete a foreclosure research based on filed NEDs from January 1, 2023 to January 30, 2023. List all properties that were foreclosed with a balance due above $400,000. Provide FC#, Grantor, Street, Balance Due and Status. Our most frequently utilized applications include MS Outlook, Word, Excel, Smartsheet, and Appfolio. We need someone that is a good communicator (verbal and written skills), is well organized, can be proactive in learning our platforms with online education materials, is dedicated and wants to be a long-term team member. We are looking for a full time remote worker and we are comfortable with in state or out of the country help. This is for Mountain Standard