Update Text & Data in sheet 1 which copies multiple lines into seperate workbooks/sheets

Post a workbook with a few lines of made up sample data so it's easier to understand the data layout.

Is it something like this that you are after?
Note that I'm using array formulas, they have to be entered with Ctrl+Shift+Enter. I also made the data into an Excel Table, makes it easier to get the correct range for the formulas.

Good to hear!
Right click on the tab of one of the sheets in the workbook I last posted and select "Move or Copy...".
In the "To book:" dropdown menu you select "(new book)".
Then you must not forget to tick the box where it says "Create a copy".
Click OK and you're all done, the formulas update automatically.

Hi

I tried to copy the formula onto the sheets im using but i just get - come up, any ideas why ? sorry & thank you

Also i dont know what a PM is ???

Hmm... I suspect it is because I've been sloppy and used the ROW function instead of the ROWS function to get the n'th largest element.
Did you by any chance add a row above the header?

Never mind, I corrected the formulas in this sheet to the proper way. No you can add as many rows above the header as you want.


These are array formulas and has to be entered with Ctrl + Shift + Enter. If done correctly the formula will be surrounded by curly brackets. Don't try to add curly brackets manually, it will not do you any good.

If you know what you're doing when copying formulas and know how to adjust ranges and so on to make it work they can be copied to another workbook.

If you feel less experienced with that then you are better of copying the data to the Table in my workbook (which is what you done I assume).
Then use the method I described in post #6 to put the sheets in individual workbooks.
Try again with this updated workbook and let me know how it works out for you.

Oh, I didn't quite get that the error was in my workbook, I thought it happened when you tried to use the formula elsewhere.
Anyway, corrected it now. A sloppy mistake indeed.

It's not that difficult.
Select cell B2 on the Louise sheet, click in the formula bar and select the whole formula string there, hit Ctrl + C, then hit Esc.

Past it in cell B29 and hit Enter.

Then click in the formula bar again so that all the range references becomes visible with colored rectangles on the sheet. It is now obvious that they are misplaced. Grab the rectangles one by one and drag them to the corresponding place in the new table. Finish with Ctrl+Shift+Enter.

Finally, change the Table1 to Table2 and finish with Ctrl+Shift+Enter.

I did the Ashley sheet already so that you have something that works.