excel & vba

Hi Guys, I need to copy and paste data from multiple workbooks and multiple sheets. (name keeps changing of worksheets as well as workbook) I have a code but here I need to manually select the cells. I just want to select the sheet and it should automatically import the entire data in the...

This is related to a different question I asked about getting exact position on a sheet of a option box but I have made it a separate question in case it can be applied to other objects and therefore perhaps help others. Admin please delete if you feel this question is not appropriate. I have...

Hello, I am having some trouble with figuring out how to insert blank rows to my data set. I have been able to find information and figure out how to insert blank rows based off of one column. The problem for me is that I need to be able to do this for multiple columns where the data value...

Hi i have 5 column table - 1st column -"product" ,2nd column-"A",3rd column-"B",4th column-"C",5th column-"D" Product are selecting from drop down list.The drop down data come another sheet. have 4 product (Name) LSOU ,LCOU,COC,DEC If select each product name to row "LSOU" , "LCOU" , "COC"...

Hi all, Hope you can provide some advice. I've found and slightly adapted VBA code which requires the user to select a chart in excel, the code then copies and pastes into the location where the cursor is located in the word doc. See code below. Is it possible for the code to select each...

Hi I have a large workbook with a variety of documents the majority of whichhave my company logos as standard but I need to be able to insert the customerlogo into these sheets. The position and size of the logo is different from onesheet to another so pasting to a specific cell is not going...

Hello, I created a folder template which has several sub-folders. I want to copy this template and create new folders with names from an excel spreadsheet. The path for this template is: C:\Users\woodenk\Documents\Employee Personnel Files\_Folder Template. I also placed the spreadsheet...

I am looking to write VBA to hide 2 rows on Sheet10 (code name) based on cell value on Sheet1 (code name). The logic I am looking for assistance on is the following: If Sheet1 cell C33 does NOT = "Apple" then hide Sheet10 rows 108 & 109, but if cell C33 is blank, then do nothing. Thank you!

I created a code which can open a .csv file and copy data from .csv to an excel file without opening both.(It looks like not opening) Actually it works for excel files (.xlsx) but When I use a .csv file as below code it displays me an error message "SUBSCRIPT OUT OF RANGE". How do I solve this...

I am looking to write a VBA to delete rows based on a call value within Sheet13. If the value in column A (over 50,000 rows) does not match the cell value in H1, then delete that row. With the amount of rows, I am concerned with the speed and efficiency of the code.

Current: I have code that updates 4 tab (Sheet6, Sheet7, Sheet8, Sheet10) names based on cell values in range D2:D5. This range is populated with formulas, which can result in blanks and is located on a tab named “Calculations”. Each cell is associated with a specific tab: D2 -> Sheet6. If...

Could I possibly get some help. I need a user to be able to click a button and just rotate through 3 cells A15:A18 and highlight each one with a color. The loop would be infinite as the user will be pushing the button through out the course of a day. Possibly 500 times in a day.

Cell A3 contains folder path. Cells below contain file names with extensions. Upon selecting a cell below, my Excel macro opens that file's location in File Explorer and out of multiple files in that folder selects this particular one, which can be seen in Preview. When next cell containing...

Hello, I have a workbook that contains classes a person must take based on their roles in a system (job duties). Because each roles requires certain classes and all of the roles have repeated classes, I would like to combine the rows based on the user while keeping all unique values and keeping...

Hi MrExcel wizards. :) I have been searching for hours trying to find something to solve this specific problem. I have information in an Excel file, which I want to transfer to a word file. I have everything working perfectly. All i now need is to add "Page X of Y" at a specific location. I...

I have these set of zip code ranges in my excel sheet and I would like to build a code that expands these number ranges into new rows by the simple press of a macro and for it to recognize the numbers after the comma whether they are single numbers or a new range. Any help is appreciated. I also...

So I'm having an issue with my current code. <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans...

Hi All, i have 2 Private Sub Worksheet_change(ByVal Target As Range) codes that work on their own. i need them to work in the same sheet. whenever i do this the 2nd code does not run. how do i merge these please!!? Code: [Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As...

Hi All, i have been looking for a VBA code that automatically sorts my data when it is entered/ updated. if there is a value in column I the VBA should move the row to the next row that is not blank in column I resulting in having all blank cells at the bottom. i know you can us a sort but i...

I have a workbook with a large number of sheets (100+) Ihave a button for administrator/high level user use which unprotects the wholeworkbook which works OK, BUT when the code runs it shows/flashes through allthe sheets as they are being unprotected which is very annoying (and may evenbe a H&S...