vba & excel 2016

Hello friends, I spent a while searching and googling a solution with no resolution. Tried creating an array, but my array skills are lack luster. Basically, I'd like a suggestion of an easier/cleaner block of code to accomplish the same thing. This code functions properly but seems very...

Hello- I am a complete VBA beginner....however, I am attempting to write a macro to copy data from a source sheet to the current active destination sheet (same workbook). - The source sheet will vary. I created a drop down list of sheet names in coordinate "Q5". I'd like the macro to refer...

I can convert a column of data to type: text. But it still shows large numbers as scientific notation. For example: in a cell it reads: "6.40001E+14" but in the formula bar it reads: "640001171111044". I need it to say the latter, as these are Serial Numbers, and no math is being done. What...

So I have a list of values in a column with named "Rank". This has values of integers going from 1 to 10. In a different column called "Name" I want to indent the data in each cell according to the value in column "Rank." So if Rank = 1, no indent is needed. If Rank = 2, one indent (5...

I will be opening CSV files that will be exported from another location. Some of the data columns are useless that comes through, so I want to delete them if the title contains specific text. I don't just want to delete the column based on location (i.e. delete column D regardless of what the...

For some reason, IsDate is missing some blank cells and I can't seem to resolve the problem. The blank cells have been thoroughly checked with IsBlank and IsEmpty and show as blank cells. What happens is, the blank cells are then subtracted from a date and consistently return a -43524...

Hi all, I am constructing a panel chart, that is, a chart that has multiple regions which compare similar data sets side by side (in separate panels) rather than right on top of each other. Essentially a single chart is repeated across a grid, with different data sets in each instance of the...

Hello all, I'm trying to populate an order form ("Supply Usage Form") using VBA. I have a command button that, when selected, loops through a location-based inventory sheet ("Location") and checks columns L & M for missing or expiring items. If any are found, it auto-populates the order form...

Hello, I currently have an Excel workbook with three worksheets. The first contains all the variables and data. The second is coded in VBA to require a user input of a number greater than or equal to 0. When the user inputs a number they then push a command button and it pulls data that is...

Hi! So i am fairly new to Macro's but am also running into SO many errors so much that i basically need to scrap everything complex and start over.... can i get some help? I can adjust the actual rows and column numbers so i will keep it simple. Here is what i need to do: Press a Command...

I have a code that searches Sheet1 ("Location") for certain criteria and populates Sheet2 ("Supply Usage Form") with that data. This works fine, after looping through all the rows on Sheet1, I need the code to loop through all the newly added data in Sheet2 for duplicates, combine the rows and...

HI, I am trying to adapt an existingVBA project to copy 11 worksheets from a folder into one workbook, then update a master template. In Column A I have “ABM”, then it runs along for 32 more columns, row 1 is the titles which I don’t need to copyover. There is only 1 worksheet per workbook and...

I want to create a function in Excel VBA that can do matrices multiplication for multiple matrices (undefined numbers of augments). The following is my code (I use ParamArray in this function), but it returns an error. Could anyone help me debug it? Function MultMMult(ParamArray X() As Variant)...

Hi All, Please could someone give me a hand. I'm not sure if this can be done the way I am trying to do it. Basically, I have a userform with 40 labels on it (amongst other objects) and would like to update the BackColor property using a "For... Next" statement - instead of writing 40 lines...

Hi all, I was wondering if i could get your advice. Is there a way to automatically increase a numerical value in "column A" by 5% without having to add another column to do the calculation within VBA. I haven't come across any Google topics that can answer this question.

Hello, I was able to find VBA code that splits data from one sheet into new sheets based on a criteria in a certain column, but I need to figure out how to select what columns I want to go on the new sheets. For example, I want to split my data based on the column H (Tab) because I have already...

Hi all, I hope i could get your guidance. I am stumped to which line of the code needs amending or adding in as currently, it copies the header row into the data set if the column is blank. What I am trying to achieve is to ignore the header row. I have tried different variances to the...

I have a data set with individual measurements of over 100 pieces - each in a single sheet. I need to create line chart with all data plotted in a single graph. The name of each sheet is in cell J1 Y-Axis range is J2:J256 X-Axis range is C2:C256 How can I create a marco which automatically plots...

Hi guys! Trying to implement a VBA loop the first time and struggling with it. I have table Table1; separately defined range Filtered (same area as Table1, however no headers) and hardcoded array of values Arr. I want VBA to cycle through all those values in array and use each of them to filter...

Hi guys. I have bit of code that clears a sheet, before it does that I have it save to another location (just incase the user pressed the wrong button), my question is, is there a way to notify the user hat the save is succesful before thy carry on? Here is hat I have already. If...