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):
<tbody>
</tbody>
Sheet Day1 contains columns ( A - B - C - D - E) as:
<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.
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 | Titles | First Name | Last Name | Text |
session 1 - PS11 | abstract 11.1 | Speaker FN 11.1 | Speaker LN 11.1 | Text 11.1 |
<tbody>
</tbody>
Sheet Day1 contains columns ( A - B - C - D - E) as:
xx | session 1 - PS11 | N/A | N/A | |
xx | L3 | abstract 11.1 | Speaker LN 11.1 | Text 11.1 |
xx | L3 | abstract 11.2 | Speaker LN 11.2 | Text 11.2 |
xx | L3 | abstract 11.3 | Speaker LN 11.3 | Text 11.3 |
xx | L3 | abstract 11.4 | Speaker LN 11.4 | Text 11.4 |
xx | session 2 - PS12 | N/A | N/A | |
xx | L3 | abstract 12.1 | Speaker LN 12.1 | Text 12.1 |
xx | L3 | abstract 12.2 | Speaker LN 12.2 | Text 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.