makro

Hallo Zusammen, ich musste für die Arbeit ein Makro programmieren, dieses funktioniert einzeln auch. Nun habe ich das Problem, dass in dem Excel schon ein anderes Makro mit "Worksheet_Change" existiert, welches nicht von mir ist und mir die Funktion nicht bekannt ist. Wenn ich Beispielsweise...

Hello, I need help with a makro in excel. I have got table1 in worksheet1 and on worksheet2 there is table2. Now, I want to select a certain value in table1, search for that value in table two and then copy the content below the found value and insert it under the selected value in table 1...

Hello, I couldnt find any similar question nad i also looked the problem up. I am new in the game :) I have two sheets: One as a mask, so you can write the information in the cells ("mask") and one sheet as a table where the makro will copy the data in the mask an paste them in the table...

Can anyone help me with a macro to cycle through my entire workbook and clear all the unlocked cells. Many thanks.

Hello, I would like to have makro which will be merging cells based on values on next column plus making sum of this cells in column C So I have: blank A 5 blank B 4 blank C 6 blank D 7 blank E 9 blank F 11 So excel merge cells where blanks are for A,B,C plus...

Hello, I would like to ask if there is a way to merged cells within table using makro ? I need to have possiblity to sort, filter ect. and I can't use filter because of other data in sheet. Can anybody help me ?

hi, i automate some processes for a browser. i stuck at the following problem. for my makro i need to click on a link. »» Info / Gruppen IE.Document.getElementByID("vendorLink").Click <-dont work could you help me? thanks.

Hey, I've been looking for the answer to my current VBA issue, but couldn't find anything. Maybe someone in there knows how to solve the crisis. I have two Excel files - one Workbook contains all the information on current/past/potencial clients[ALL CLIENTS'], and another one for just the...

Hi! Is this possible via makros? I have workbooks for each day of the week. Their name contains the current date. Is it possible to write a makro, that can import all these workbooks into one sheet? Next to each imported content, the date would be there(from the name of the files). If there...

Hey Excel community, I have tried different solution approaches from this thread but they don't seem to fit my specific situation (or I'm making a fundamental mistake, who knows haha). I'm working on a document for meeting minutes and I want to paste the topics of the agenda to the worksheet...

Dear all, I am by no means an Excel or Makro expert - far from it actually, but I am working in an Excel file which includes all my data, so I have to find a way to make this work. I sincerely hope someone out there/ here can help me. Each of the items in my database contains one field (let's...

Hello everyone, I have an unexpected problem that i hope some of you can help me with. I have recently made an Excel Workbook with some Makros inside, to help some of my coworkers plan and log their daily activities, My Makros, which are placed in the entire workbook, not in modules or at...

Hi. I have made a Macro that insert a new row below the Activerow, then its autofills from Cell E5 and down to the last row. (the reason is that the E5 and down to lastrow has the same formula, and it autofills to make the formula change f.eks c5+d5 to be cc6+d6.) This makro works, and it works...

Hello, I am working on creating a makro for excel. I want it to check if a specific other Excel workbook is already existing. If so I wanted it to be opend and a few specific fields to be automatically filled from the first workbook. If it does not exist already I would like excel to create the...

Dear All I have a table with data from a wastewater treatment plant. The table contains 89 columns. Column A is the day/date. The rest of the columns are measurements parameters from Column B till Column CH. I would like to create a makro which create an x-y dot plot with X-axis always Column...

I am new to this forum. I hope someone can help me: I want to write a VBA or makro to establish the following: I've got a directory 'xxx' with a number of files in it I want to import those in excel (I chose within other for .xml, but than have to change it to all files) the columns are...