nrow

Hi to all, I found a vba script that I changed a little to copy a row content from multiple excel workbooks into one. this is working. It adds A52:Z52 into one excel from all files selected. What I would like to do is change this script in a way that I can copy a few rows from each workbook...

Dear Gurus, The above-mentioned error keeps popping up when I execute the code below. It was running perfectly fine till I switched the sourceWB workbook and made changes to the code to reflect the change. Since the change, i could not get the macro to run and it is driving me crazy. Hope...

Hi, Today I have tried to set up a VBA code in Excel to merge multiple data into one Excel-file. I have a Test folder with multiple Excel files and i want to read multiple cells from each file into one New Excel file. Below an overview of the code. Where I get stuck is reading the multiple...

Hi, I have copied the following code to import data from multiple workbooks. There is a text in every source workbooks sheet1 cell b6 which I want to get to SummarySheet's Column A instead of source workbooks filename. Code below: Sub Hae() Dim SummarySheet As Worksheet Dim...

I need to take the the information on one worksheet from each of (up to) 31 files ... (one per day each month). Each of these worksheets is formatted exactly the same, and always contains a heading row, but may or may not contain data, dependent on whether certain conditions were met. I have...

Okay, I worked through some of my issues from my other post, but I can' get it fine tuned like I want it. Hence the title of this post. It is importing the data as it should, but it will override any data already on the sheet and replace it with the new imported data, and it keep resizing my...

Okay, I am currently running the following code to merge several workbooks into one. I want to modify this code to insert all new data at the last row of a file that already contains all of the old combined files. What do? Sub MergeAllWorkbooks() Dim SummarySheet As Worksheet Dim...

Good afternoon, I have this little snippet of code I wrote earlier today, and all was well for the intended purpose, until I added more lines above the original portion. So, what this is supposed to do is: Copy data from "Vet List" columns B, D & C where column Q is blank. Rows 5 to the...

I have some code that opens all excel files within a folder and copies cells from these files into a master recording spreadsheet. However, I have now been told that the source files will be saved within individual sub folders within this root folder. The code works perfectly for the root...

Hi all, I am trying to transpose multiple data from multiple columns into a single row in a new workbook. My original data simplifies to what is seen below. Before Col1 | Col2 | Col3 1 | 2 | 3 1 | 2 | 3 1 | 2 | 3 After Row1 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 So far, I am able to grab Column 1...