vba & code

At Name creation, Excel defaults to Workbook; which was fine when intended with only one sheet. Now after finishing all the formulas, I have new need which requires Sheet duplicated to same workbook. What I need is help on, preferably non-programmatically, is all Names to remain same for...

I am creating a tracker that will be used as a live sheet. It will be accessed by numerous people and consistently updated. There will be an active tab and a closed tab. On the Active tab, the cells on row N contain a drop down. The drop down options are "In Progress" and "Closed". The goal is...

Hi All, I need assistance on how to efficiently delete blank and empty columns based on a condition in the second row, starting from "F" column to the last column. I have updated the entire project code information in columns F1 to the last column, totaling more than 150+ columns. In the second...

Hello everyone, I have been learning a lot from this amazing forum and have come across many short codes and new techniques. Recently, I created a macro code for Team Entry Preparation. However, I noticed that the code takes more than 1 hour to run when dealing with a large dataset. I believe...

Hello all I'm learning new things as I go and appreciate any help. I will have multiple sheets that are identical. I want to pull all the data from the sheets to the master at the end of the day. The sheets will be named C1 and C2, and this will be in reference to the work cell where the product...

I'm stuck with how to select the Gender (Male / Female) from a dropdown list in a Website. My current script works, apart for the gender part: Sub MERF() Dim IE As Object Dim doc As HTMLDocument Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.navigate...

Hello All, I have been trying write a VBA code for protecting all sheets except the column H. The spreadsheets consists of from ListObjectsTable and slicers. every vba code i have tried locks the slicer. So i was thinking rather to protect the sheets i could protect the ListObjectsTable except...

Hello, so first of all - this is not about dependent dropdown lists - The dropdown lists in my excel file are already dependent from each other. What I would like to know if it's possible to automatically change what is set in one dropdown when changing something in an other one. I do have a...

quiero pasar una base de datos de excel a powerpoint pero cada vez que se genera el archivo se crea en las mismas diapositivas , quiero que se haga en el orden de la base de datos en la misma diapostiva Opción explícita Sub Combina Correspondencia() Dim strBaseDatos como hoja de...

Hi; I am asking you and my dear friends and professors to help me I have two sheets in the attached file One sheet to enter and edit information and another sheet to store information I encountered a problem editing information in this file I cannot recall and edit the information I have...

I am working with a price list and would like to select pivot table fields (column headers) based on the price level (PL) selected which is also a column headers. The price level is indicated by Z0 and Z1. This particular column header can be used or not as part of the solution because there is...

I'm seeking assistance in creating a VBA macro that can help me merge data from multiple workbooks located in different folders based on order numbers in another excel file. I am beginner and not having enough knowledge in VBA. It would be a kind help to achieve my migration activity. Here's...

While import file will have many row maybe more than 5000 row, so I want to cut 1-100 row to in 1 excel and then 101-201 loop file until to 5000 row. Sub test() Sheet60.Range("A1:BX100").Copy Workbooks.Add Application.DisplayAlerts = False ActiveSheet.Paste Destination:=Range("A1")...

hi, I have 3 sheets in this attached file where I record information in the data sheet and it is saved in the Save_Data sheet. In the Admin sheet, how can I write a formula that by entering the date and user name, the registered information from the Save_Data sheet will be called and placed in...

Hello all. I have a workbook with over 20 tabs. I am trying to build a VBA code that it goes through all 19 tabs inserts rows creates a table inserts a slicer. The tables consist of the same columns but the rows will vary. Slicer is always the same. Also, i have a Summary sheet that does not...

Hi guys, I'm after a VBA macro code that I can have saved in a workbook that, when run by pushing the macro button. Brings up a window where you can select a folder and it will find all excel workbooks in that location and print them to PDF. I would like the Print to pdf to only print used...

I need to sum the expenditures of multiple projects defined under several worksheets. Each project is named on the worksheet tab. The first workbook contains the expenditures per month per category. The categories are "Labor" and "Material". The expenditures (i.e., under the first workbook)...

Hi; In a user form, we have 6 ComboBox and the value of all of them is the same Is it possible to assign a value to all of them with a loop? And by selecting an item in any of the combo boxes, that item will not be displayed in other ComboBox

Hi Gurus, Could you help me simplify below code which I recorded? Basically, I need to apply these conditional formatting and hoping that the macro will look for Change 1, Change 2 and Change 3 header name and reflect the number format for all tabs (as the column might interchange on the other...