VBA code to read data and paste in other sheet using a loop.

**aleenkhan** · 02-17-2018, 09:24 AM

Hello Excel Gurus,

I am wondering if someone can help me in achieving the below task.

I need to extract data from few excel templates and consolidate in a different excel workbook.

I know that it can be done by writing a VBA code to copy respective cells and paste it in other file but the problem is, it is a form template and data is organised in a typical way so wanted to check as how to create a loop to read a range if data is present in that range on the source worksheet.

In the file attached, I need to copy the data from cells in source sheet and paste in the destination sheet in a particular format. The cells in "FIRST PART" should be copied repeatedly along with all the rows in the "SECOND PART".

Can somebody help me in writing the VBA code for it?

Thanks.

Cross posted at: https://www.mrexcel.com/forum/excel-...ges-sheet.html

**LeoTaxi** · 02-18-2018, 05:49 AM

Did changes in layout of sheet Source, almost none merged cells anymore,
then this code can do

Please Login or Register  to view this content.

Kind regards
Leo

**aleenkhan** · 02-18-2018, 02:11 PM

Thanks Leo for your reply.

The problem I have is, many cells are merged in my template from where I am trying to copy the data and consolidate in another workbook.

I will take your code and will work on it further to achieve what I want.

Thanks again Excel Champ.

**LeoTaxi** · 02-18-2018, 02:16 PM

Is template always same layout as source sheet ?

**aleenkhan** · 02-18-2018, 02:49 PM

Yes it is.

**aleenkhan** · 02-18-2018, 03:01 PM

Hi Leo,

Can you tell me as how can I read more data ranges with this code?

I have few sheets where more data tables/ranges (in B27:G32 and K27:O32) and I want to copy these ranges also in the destination sheets.

Thanks for your help.

**LeoTaxi** · 02-18-2018, 03:19 PM

not mixing 2 different sheets, in the fiile B23 to B32 are merged

so for file you posted, without changes in layout

Please Login or Register  to view this content.

kind regards
Leo

**aleenkhan** · 02-20-2018, 02:37 PM

Thanks Leo for your support.

Can you also help me as how can I copy different ranges from a sheet to designated sheets in other workbook?

That seems to be very difficult to me to code. I really appreciate if you can help me to learn this.

Cheers

**LeoTaxi** · 02-20-2018, 06:48 PM

First save the 2 files in same folder

extra lines of code between End With en End Sub of excisting

Please Login or Register  to view this content.

Kind regards
Leo

**aleenkhan** · 02-21-2018, 03:01 PM

Thanks Leo.

You are a STAR..

VBA code to read data and paste in other sheet using a loop.

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to read data and paste in other sheet using a loop.

Re: VBA code to read data and paste in other sheet using a loop.

Re: VBA code to read data and paste in other sheet using a loop.

Re: VBA code to read data and paste in other sheet using a loop.

Re: VBA code to read data and paste in other sheet using a loop.

Re: VBA code to read data and paste in other sheet using a loop.

Re: VBA code to read data and paste in other sheet using a loop.

Re: VBA code to read data and paste in other sheet using a loop.

Re: VBA code to read data and paste in other sheet using a loop.

Re: VBA code to read data and paste in other sheet using a loop.

Thread Information

Users Browsing this Thread

Similar Threads

Loop web data into new column on same sheet (Code included)

Loop web data into new column on same sheet (Code included)

[SOLVED] How to write a code within a loop to copy and paste rows on to another Sheet

[SOLVED] Loop through entire sheet, Insert row, copy row data, paste row data, delete row

Code to Read/Copy Data from Closed Wb and Return/Paste in Active Wb

Loop to read data from sheet and run all cases

VBA Code to read the structure & data of an excel sheet having merged rows & columns

Bookmarks

Bookmarks

Posting Permissions