ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   need help please inserting multiple rows based on cell value then copying to data sheet (https://www.excelbanter.com/excel-worksheet-functions/148625-need-help-please-inserting-multiple-rows-based-cell-value-then-copying-data-sheet.html)

[email protected]

need help please inserting multiple rows based on cell value then copying to data sheet
 
Hi there, I've seen quite a few messages similar to this almost
identical that has given me most of what I need, however am getting
frustrated as quite cant get there.

Heres my scenario

I have a worksheet named 'PLAN' that has a header row from A1 - A6,
then 6 rows across 5 columns i.e. A2:F7. Looks like so;

A B C D E F

1 5 fg

2


Pete_UK

need help please inserting multiple rows based on cell value then copying to data sheet
 
And your question is ??

Pete

On Jul 1, 8:04 pm, wrote:
Hi there, I've seen quite a few messages similar to this almost
identical that has given me most of what I need, however am getting
frustrated as quite cant get there.

Heres my scenario

I have a worksheet named 'PLAN' that has a header row from A1 - A6,
then 6 rows across 5 columns i.e. A2:F7. Looks like so;

A B C D E F

1 5 fg

2





All times are GMT +1. The time now is 03:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com