copy and past rows vba

The goal is to: write a VBA Code to copy data from (specific sheet) in multiple workbooks and paste rows with content to Master Workbook. I have spent the last few days working on this, but I was really excited to come across this site. Current, when the information desired is copied, I noticed...

Hi - Thank you in advance for help on this! I am trying to create a macro (or maybe multiple?) that looks at a a few fields in a "Raw Data" tab and exports results into a tab called "Opportunities". I have 4 categories listed in a column ("Lifestyle", "Multi", "Tech", "Auto" ). I am trying to...

I received a raw data weekly, the data has 5 worksheets and I need to filter the data start from "B4" cell with criteria "I" then copy and past all result from 5 worksheet into one new file. can someone help me with more efficient way?

Hi Everyone: Can someone please point to me in the right direction? My attempt is to go through a specific folder and consolidate all the files into one workbook. I am having three setbacks. First one is I am not sure how to loop through all the workbooks. Second one is adding the file name...

Hi all, I'm writing some code (see below) to add to a command button on a worksheet and seem to be having some trouble. All I want to do is select a row a data and copy it from one workbook into the first empty row of a worksheet in a different workbook. The code seems to work when i = 2, but...

Hi I have a spreadsheet with approx 1000 lines of data which needs to be formatted. The lines number varies each week. I need to amend my macro so that it can capture/move the necessary data to the correct columns regardless of the number of rows. Column H contains subtotal headings (ie Total...

hi i have a workbook which contains 2 sheet. Sheet 1= this is master sheet Sheet 2= contains list of item(row 9 till 155), each row is different item, staff required to key in amount for that item at column F. Column I contains "defined name" for each item (e.g A9 is item named Admin, F9 is...

Hi - i currently have a piece of code that will copy the selected row and paste it right underneath. However, whenever I filter on a column and run the macro it will copy but paste blanks. There are some vlookups in some of the columns so was wondering if its possible to copy and paste exactly...