excel

I have two spreadsheets (Sheet 1) and (Sheet 2) with similar data in different columns that I want to move to an existing spreadsheet(Sheet 3) in the workbook under the New columns for further analysis They have similar data and I need to create a VBA code that would consolidate all...

Hi, I need to update pivot tables in a certain order, can some help with this? The data is on a tab called Details, on this tab I have a from/to date range and a refresh button The first pivot table is called Helper Pivot The second pivot table is called Pivot, which pulls data from both the...

Hi there, I was wondering if you help me transform the following dataset? This is how it comes out of the system: EmpNum ProductName InputName EntryValue Product Entry ID Emp1 Apples Type GrannySmith 123 Emp1 Apples Units 5 123 Emp1 Apples Type Gala 456 Emp1 Apples Units 3 456...

Hello Everyone! I have two files named Purchase Requistion (PR) and Database (DB). PR is in the format of a form which they fill in order to raise a PR request. This file is then "Save As" with a different name so as not to disturb the native file "PR". DB is a table format, which takes the...

I am currently creating a macro to improve a weekly file update process. I have to copy a specific range of data from one file (file name "Previous Weeks File") and paste it into my current week file - the new week's file name has date changes: "File Update - 03-17 (Weekly)". How can I copy the...

Hello, I’m trying to write a vba script to return all columns that match a list of numbers. Some numbers have multiple rows of data. I use the choosecols and filter function to return the data which works. Now I’m trying to write a VBA script that does the same thing. Problem now is that it’s...

Hello - newbie here. Using VBA, I need to cut the last 36 rows of data and paste them to a new sheet. The actual number of rows will vary each time we use the sheet. Any help would be greatly appreciated!

Hi, I'm creating a cashflow spreadsheet to track the outgoings from various sources and have used an index match formula to track from different projects into one summary sheet. The formula works fine for the BACS column, but for my CC and ACC columns it returns a #N/A. Can anyone help with...

Hi, I am trying to get a pivot table to work with multiple columns. This is the data I have: Customer Name Credit Limit Date Sales AA A&A Paper Corporation 3000 2024-03 5,329.50 AA A&A Paper Corporation 3000 2024-02 2,340.00 AA A&A Paper Corporation 3000 2024-01 2,524.50 AA A&A Paper...

I have a sheet with 6 check boxes, i have the below formula that will complete a Vlookup when the check box is ticked, what i now need to know how to do is adapt the formula to complete Vlookups when several check boxes are ticked, and then put the result of the vlookups into one cell. This...

Hi, I have several check boxes within a sheet that when ticked will perform a Vlookup and return the value required, this is the formula that i have that currently works as intended =IF(C4=TRUE,(VLOOKUP(A4,Sheet2!B2:E30,4,FALSE)) What i also want to explore is the addition of the ISBLANK...

Hi All, I am a newcomer here. I found an old question which I am interested to. https://www.mrexcel.com/board/threads/text-format-for-numbers-to-preserve-trailing-zeros.811427/ I ask anybody to write a Sub file to apply this Function published there...

I am in need of an Excel formula that looks to see if cells in column A match. If they do, then provide the sum of all of the cells that match in that group in the first cell of that group in the appropriate column (GA = column "G", "FL" = column "I"). You can see the totals in columns G and I...

Hello Good People, I have this allocation workbook that when I click a button. It will randomly divide the list of data into 8. (Currently 8 but it will soon increase). I have attached a sample images for my 2 sheets. Persons sheet - List of data Teams sheet - Output of allocation However...

I have the following data (before.png): I would like to have a VBA script which runs through column A looking for a carriage return. Upon finding one, it copies that entire row but only with everything PRIOR to the carriage return - it will make a new row for each iteration. It will then add a...

I have an excel issue that I can’t resolve on my own, looking for some help. I will add that I work with laptop and desktop both and sometimes start on one and finish on another. I do a lot of excel work between church finances, scheduling for our little league, and my personal finances. My...

Through use of multiple UserForms I open a 2nd workbook that I hide and then may get or write data to that workbook before closing it. All was good until I noticed that when the red X in upper right corner (Close event) of forms was clicked that the 2nd workbook was left open and hidden. To...

Hello folks, Based on the attached photo, at a click of a button, I would like to: 1. Copy the contents of A3 to C3 2. Paste in the next available, free cell. In this case, A12:C12 3. Clear contents of A3:C3 I'm struggling with getting the macro to paste at the bottom most, next available free...

Hi there! I am using this macro to sort through a master inventory list and transfer a row if the inputted "Vendor" is found when the InputBox populates. However, after the input, the InputBox keeps popping up and infinitely looping. How do I make it so that once a vendor name is entered, the...

Good morning, I have about 25 different excels spreadsheets with various information. I'd like to auto-transfer any data updated and saved onto any of these excel sheets into One google sheet file; each excel file would have its own tab in google sheets. What is the best way to accomplish this...