vba & copy

Hello, I'm new to VBA and currently still learning. My problem is that I want to be able to copy a set of data from multiple worksheets in a workbook based on a date search and have these data paste to a summary worksheet in the same workbook. For example: I want to copy data from sheet A-I...

I need help with a VBA code and have absolutely no experience/knowledge with it. I have looked into it but ultimately come up confused where i am suppose to change data to match my workbook. I am trying to copy data based on one cell with multiple and changing factors into other sheets for a...

Hey All, I am having major difficulties working out a macro formula for what I am trying to do, unfortunately, this seems way, way more advanced than my current skillset, and I can't seem to find any good video tutorials on what I am trying to do. I am trying to create a macro with a button...

Hi everyone, I'm trying to copy the range of the second table (green background), however I can only get it to copy the blue background table. I was trying to set it up so the "LastRow" was set to the row that the string "Total" is located. Which worked for my first function addSetB, which...

Hi, I would like a macro that auto populates a master sheet in a workbook based on two other sheets, sheet 1 and sheet 2, which will act as templates. The master sheet will have normal column headers horizontally but in sheets 1 and 2, the headings will be contained in column A and the data in...

Hi all, first off thank you in advance for reading and considering to help. I am looking for assistance on a copy paste macro to copy data from Sheet2 to Sheet1. the macro must Compare the values of columns C in the 2 sheets and if they are equal: copy/paste the whole row in sheet2 Example...

I'm trying to create a Macro to copy the values from a table T1 of sheet1 and paste them into the bottom of table T2 of sheet2 if the value in cell G (key) of sheet1 does not exist in in cell G of sheet 2. If it exists, just replace the values of cell M of sheet2 by the values of cell M of the...

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...