vba & copy

Hi all, I need an urgent help on a macro. I have very minimal experience with Macro and is struggling to get this done. I have a spreadsheet that has close 22K rows with a lot of data. The data is spread across various columns. The cell A1 is the unique id which repeats in various rows...

Hello, Im new in VBA, and im searching for a script that would search in multiple sheets within one woorkbook, for specific text (specified in script itself) and paste it in a new sheet. for a descritpion: - multiple sheets (search in all of them) - skip new reference sheet + few others...

I want to copy the value in the last cell in a column to a cell in another worksheet, and add 1 to it. I don't know why this code gives a type mismatch error? Sub copyValue() Sheets("Additions").Range("A47").Value = Sheets("Test FAR").Range("A" & Rows.Count).End(xlUp).Value + 1 End Sub

Dear all, I`m having trouble in creating a correct VBA code for a copy paste function. Main sheet "home" Second sheet "clients" On "home" sheet i have 4 cells ( C column - "C4:C7") representing data: id nr, name from a dropdown, name entered manually , and a date. This data should be copied in...

Hi, I have a excel workbook, where the front sheet has every entry of all the worksheets where everyone enters their snagging lists to, and then each worksheet belongs to a project. At the moment we are manually entering to the first sheet and then copying to the relevant project. What I am...

Hello, i would like to make a data input from two workbooks that is in the same path. The data input should be in the master workbook from those two files. The first sheet in the master workbook should just be empty as im going to make macro run buttons for later purpose. The data from the first...

Hello everyone I would love some help to develop some VBA code. But im very new to VBA. Hope someone can help me with it, and i know its a lot to implement. So its for private purpose and a "just for fun project". The project is that i want to two files in a path that i want to match with...

Hi, im new to VBA and i want to access a path on my Windows computer. Tha path contains the master workbook and two workbooks with information in sheet 1 (in both of them). The two data workbooks contains 3 columns with an id in the first column, date in the second and nominal ind the third. I...

Hi There, I am looking for a VBA code that can copy all the rows (Incl Headers) based on criteria in specific column. Scenario :- I have a File with 8 different sheets and different information. Commonly, every sheet has a "Status" column. I want to filter the status column and check for...

Hi, I'm currently trying to write a macro which collates data each day into a masterdata file. I have managed to get the initial copy and paste from one file to the other. What im currently struggling with is adding todays date in a different column so i know from which date the data was...

Good day, I am newish to Visual Basic, apologies if this has been posted but i have searched through most of the forums and could not find this specific one. Basically what I need to do is a data sort from a file that information is not aligned properly. It comes with information in Cell A...

Hi Gods of Excel, how are you ? ? Guys, I took this formula from one place and try it works perfect. It can copy files from one folder to another, but I want to update it and add color in cells which were copied something as indicator ( fore example green color). Is it possible ? Example...