Insert several rows from one sheet to another sheet

joeak

New Member
Joined
Feb 3, 2014
Messages
1
Hi,
My problem is as follow:
I have one sheet Day1 (Schedule description) and other sheets PSxx (with presentation information for different subjects xx).

For example sheet PS11 contains few columns (A - B - C - D - E):
Session TitlesFirst NameLast NameText
session 1 - PS11abstract 11.1Speaker FN 11.1Speaker LN 11.1Text 11.1

<tbody>
</tbody>

Sheet Day1 contains columns ( A - B - C - D - E) as:
xxsession 1 - PS11N/AN/A
xxL3abstract 11.1Speaker LN 11.1Text 11.1
xxL3abstract 11.2Speaker LN 11.2Text 11.2
xxL3abstract 11.3Speaker LN 11.3Text 11.3
xxL3abstract 11.4Speaker LN 11.4Text 11.4
xxsession 2 - PS12N/AN/A
xxL3abstract 12.1Speaker LN 12.1Text 12.1
xxL3abstract 12.2Speaker LN 12.2Text 12.2

<tbody>
</tbody>

I would like to perform a loop to read all the PSxx sheets and insert in sheet Day1 all the rows found for each PSxx. We use matching value between cell A2 (Sheet PSxx) and cell "Bx" in Day1 to start in Day1 the insert of the rows found for each PSxx sheets.
For example for PS11, rows are inserted in Day1 after matching session 1 - PS11.

Not all columns have to be copied form sheets PSxx to Day1. Here it will be:
from sheet PS11, column B copied to C in sheet Day1,
from sheet PS11, column C copied to D in sheet Day1
from sheet PS11, column E copied to E in sheet Day1

Thanks if you can help me.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,215,035
Messages
6,122,785
Members
449,095
Latest member
m_smith_solihull

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top