vba & excel

Hi, new to this forum, hope you guys can help me with my issue altho my expressions are terrible :') I have attached a picture of how my excel looks like and my code below. Basically what it's supposed to do is to extract files from different locations and combine them as separate worksheets in...

Hi guys. I'm a noob working with VBA, so I need your help. So, I have an excel file, where I have a table with some data. In this table, I have a collumn named "expiration date" (column G), but not all rows have expiration dates, some of them are empty. I have setup a conditional formating...

have a code that misses row A1 and then adds 20 rows after this. I need the code to add 20 rows after A2 Sub AddRows() ScreenUpdating = False With ActiveSheet lastRow = .Cells(.Rows.Count, "A").End(xlUp).Row End With Dim AddRows As Integer: AddRows = 20 Dim i As Integer: i = lastRow Do While i...

Hello, I am after a VBA code that will fill in data for the 'Location' Column. The value of this data to be filled in will pick from the 'Manufacturing method' offset value. If the 'Location' value is blank I want to search the 'Manufacturing method' column to find the value 'Assembled-House'...

I am new to VBA and would need help to write a piece of code for the requirements below: i have a spreadsheet with 1000's of data From the data in the column “N”, for each line: Copy-paste all the objects starting with “L-“ into a new column named “Location Type” Copy-paste all the objects...

Hi! I am new to VBA. I currently have this code to help bring in data to a master sheet from another sheet with the same column header. Right now it only looks at one sheet (v6d). How do i get the code to look at the other 4 source worksheets to bring back the data into the master sheet? Code...

I want to save activated worksheet i.e.template at given folder path and want to save in tab with specific worksheet name using VBA macro and want to delete activated worksheet(template) again.as i am doing this for number of files and also i want to add wrap text =true and row height set 12.75...

Hi I'm new to VBA, still learning the ropes. Please can I get some assistance and would appreciate help with the below code. The macro runs but copies the same row of data to row 3 in the destination workbook (TEST1), instead of copying it to the next row based on the last row that contains...

Hi everyone, I have a problem with listview. I want a table with some informations in my sheets when i click in a button "CommandButton1" but i have an error 424 object required here : Someone know what is my problem ? Thanks by advance here is my code : Private Sub CommandButton1_Click()...

I created a VBA script that adds charts and slicers to my worksheet, but for some reason they don't work after adding them. Now, once the charts and slicers are added I would go and select on the chart, right click and click "select data" then click ok. Once I do that the slicers work with the...

Hi guys, I encounter with a problem that Commandbutton works well before hiding it. But once making it hidden and back, the button suddenly does not react to click_event anymore. I have to close the excel and reopent it, then it recovers. I just have searched the problem. There are similar...

Hi everybody, I am Paul, and I recently joined that forum. I would like to share to other computers an excel file which contains formulas to fetch live quotes from Bloomberg. My idea was actually to push to OneDrive or Sharepoint a copy containing only values and being updated with a Macro...

Dear Members, I am using the following code to display photo from a folder in my excel sheet. Sub DisplayMainPicture() With Sheet1 On Error Resume Next .Shapes("ReceiptPic").Delete On Error GoTo 0 If .Range("I12").Value = Empty Then Exit Sub PicPath = .Range("I12").Value 'Picture Path If...

Dear all, I am being new to VBA (learned about the existance of VBA 2 weeks ago), and I have a question about the extraction of data from a txt file. I have a code that extracts the data of a txt file to my excel sheet, and I wanted to know about the existence of a formula that could only...

Hi all, I've been searching for a solution to my issue on the board but could not find a working solution that covers my needs. I'd really appreciate some help to come up with a VBA code that does the following: I need to break down a single row of data consisting of multiple columns into...

This code works fine in the listbox, But when you try two scenarios, the following happens: 1) when replacing a line (myCols = Array(1, 3,4, 5, 7, 10) with TextBox and let TextBox 2 written inside it (1,3,4,5,7,10) it gives me an error message (application defined or object defined error...

1. I open my PC at 7 AM 2. I want to run my macro (Org90) at 9 AM 3. Then I want my macro (Org90) to run every 1 hour 4. At last I want my macro to stop working at 5 PM automatically daily. I searched all internet that I can, but I didn't get a full answer to my question. I know it is...

hey,hope you are doing great, the below code matches the first column between 2 workbooks then copy & paste the matched results using vlookup function, the problem is that vlookup only shows 1 cell result while i need the whole row to be copied so i tried to loop the process to chnage column...

Hi, I have the current code that works to pull directly from a shared folder's inbox. I need it to pull from the SubFolder "Shared Email box" > Inbox >>"SubFolder". Can you please tell me how i can modify the below? Sub GetEmails() 'Add Tools->References->"Microsoft Outlook...

Hi all I'll be appreciate if you help me with my problem. I have a large table with more than 5000 rows with more than 700 section, each section have their own data in about 7 to 11 rows and what i need is to have a code to sort each section with my selection rows and sorting them by column Q...