macro

I am really struggling with this and while its just the first part it technically controls everything else. Say I have 18 (I've only shown 12) rows and the data represented in these rows are dependant on a table (for want of a better word) The table contains 4 pieces of information which will...

I'm trying to automate the sort function in excel (by levels). So I would like to first sort Column B by A-Z Then the next level is sort Column N from oldest to newest date The problem with the macro below, is it sorts Column B fine (A-Z), but then it doesn't apply the "level" criteria, and it...

I have an excel macro to do the following For Column O, for each cell in Column O, if cell is blank, then for that row, clear all cells going right. For example, if Cell O7 is blank, it will clear all the contents of all the Cells from P7,Q7,R7, S7 etc. onwards. But leaving the cells on the...

I have an excel macro that applies values in Columns O, P, Q, R. It works fine for Column O, but for Column P, Q & R, the values keep getting applied even though there is a blank cell/blank row. What I would like is for the cells highlighted in red (see attached image), that the excel macro...

Hi there, I'm a bit stuck on some VBA code and need some help! I want to create some code for a macro button that will auto populate a value from cell A1 in cells Q19 and AJ19 and carry on doing this every 14 cells in both columns. It would be great if the VBA loop ends at row 355 as this is...

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...

In Column O, starting from Cell O3, the value is =H3/$D$3. I then drag and drop the formula downwards. So Cell O4's value is =H4/$D$3 and so on etc.. But whenever I encounter a blank row, for example if Row 6 is a blank row, I would like the formula in Column O to "reset". So for Cell O7's...

Hi Everyone, I have an online appointment scheduler, using "https://www.squarespace.com/acuityscheduling". So far I have been manually copying all of the client information manually. Below is the information I gather manually from the website and put in my excel sheet. Is there a way I can...

I have a spreadsheet with form control checkboxes next to various cells. I would like a formula where if the checkbox is selected, then it copies a specific cell and pastes it into a range on the same sheet (I4:I15). There will be multiple checkboxes checked so I would need it to copy/paste...

Hello everyone I have a problem. I'm trying to run a macro but it doesn't work. When my co-worker runs it, it works perfectly. We both checked the settings in our computers and we have the same enable so I don't know what is the problem I would really appreciate if someone can guide me Best...

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...

Hi all, I'm hoping I can get some advice as I'm not entirely sure where to start... I have a spreadsheet which is a master file of data for multiple "stores" (Store 1, Store 2, Store 3 etc) I use this master to track what stores have particular merchandising "plans" (some stores have the same...

Having trouble with latest date code for pivot table vba code. Trying to streamline our process of entering equipment hours and I started getting into vba since it seems like it's the way to go, I found some code that should do this but I can't get it working in my particular instance. Listed...

Hi all, Super novice here trying to get something done for my wife and a non-profit she is part of. I hope someone can help save me some time as I have been at this for hours. I have a set of raw data on one page that is organized by row. (a2, a3, a4...) I have a separate page with name tags...

Greetings Excel Community, I am attempting to insert or duplicate a string value within a naming convention without having to do input manually. Is there a formula or a macro code that might be able to complete this possibly? Via the example below, I am attempting to duplicate the ID value...

Hello All! I have written the code below that does what I want it to do, but it is assigned to 1 ActiveX check box. I would like it to run anytime an ActiveX checkbox is used, but also only effect the one checkbox being activated. Any help or guidance is much appreciated!!! FYI there is over...

Hi All, I am constantly on a daily basis having to prepare data for SQL in excel so was wondering if there is an automatic way to add quotes, commas, transpose and select the transposed rows which i could simply paste into SQL. Here's what I do: 1. I paste all my data in column B1 onwards 2...

Hi, we have the data in sheet1 and sheet2 and using index and match formula, its working fine but we don't want to drag and drop formula from C2:C4 and again we have used formula in D2:D4, there is any formula from which we can get desired result so that don't do drop down SHEET1 125024568765...

I have a macro enabled workbook to produce cost estimates for customer proposals. I have built a macro in cost estimate workbook to create a customer specific proposal in word from a word template that uses mail merge fields to pull in the data from various cells in the cost estimate workbook...