Show a link to the last 5 rows of a table from a different spreadsheet

[NickScott]

Hi there,

I am trying to have a preview of the last 5 or so rows from a table in another tab in the worksheet. Not sure if this is possible, but id like it to be linked so it is constantly updating with the source table. Please let me know if there is a way to do this.

Thanks so much,

Nick

[FDibbins]

Hi, welcome to the forum

You could probably do this with COUNTA() a nd index/MATCH, but hard to say for sure without seeing a sample of what you have. Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[NickScott]

Here is a copy of what it looks like / I'd like to see.

Thanks for the quick reply!

Cheers,
Nick

[FDibbins]

Sorry for the delay in replying.

Try this...

	A	B	C	D	E	F	G	H
1	Top	5
2	Recorded?	Order #	Date	Order Type	Customer	Product Name	Quantity	Unit Price
3	X	10	1-Jul-16	Sale	Customer 10	Product 1	7	50
4	X	11	2-Jul-16	Sale	Customer 11	Product 1	15	50
5	0	12	3-Jul-16	Sale	Customer 12	Product 1	14	50
6	0	13	4-Jul-16	Sale	Customer 13	Product 1	17	50
7	0	14	5-Jul-16	Sale	Customer 14	Product 1	10	50

B1 = the days you want displayed
A3=IF(ROWS($A$1:A1)>$B$1,"",INDEX(Sheet1!B$21:B$35,MATCH(LARGE(Sheet1!$D$21:$D$35,$B$1+1-ROWS($A$1:A1)),Sheet1!$D$21:$D$35,0)))

I used the range for the 2nd table you have, so you just need to adjust teh range to suite your actual data, something like this...
=IF(ROWS($A$1:A1)>$B$1,"",INDEX(Sheet1!B:B,MATCH(LARGE(Sheet1!$D:$D,$B$1+1-ROWS($A$1:A1)),Sheet1!$D:$D,0)))

[Tony Valko]

Use table size=1 and it'll fit without text wrap.

	A	B	C	D	E	F	G	H
1	Top	5
2	Recorded?	Order #	Date	Order Type	Customer	Product Name	Quantity	Unit Price
3	X	10	1-Jul-16	Sale	Customer 10	Product 1	7	50
4	X	11	2-Jul-16	Sale	Customer 11	Product 1	15	50
5	0	12	3-Jul-16	Sale	Customer 12	Product 1	14	50
6	0	13	4-Jul-16	Sale	Customer 13	Product 1	17	50
7	0	14	5-Jul-16	Sale	Customer 14	Product 1	10	50

[FDibbins]

@ Tony, was that to me?

[Tony Valko]

@ Tony, was that to me?

Yes
---------

[NickScott]

Sorry for the delayed response, I've been travelling for work. I inputed your formulas into the sheet, but I only seem to get a #NUM! error when I do. I've tried playing around with it and can't seem to get it to work. Did you happen to have the sheet you did this on? Thank you so much for all your help.

Cheers,
Nick

[NickScott]

Nevermind! Jet lag has my mind turned into mush. It works beautifully. Thank you so much!

Nick