moving long formula to new sheet,

Hi All New to the forum,

I have a problem with following:
I have shipments arriving to my warehouse and I need to create manifest for boys with details, (cartons, weight etc) based on search criteria “departure date” Cell: V13
At the moment I have a sheet (for each month) with “my” manifest and in the same sheet manifest for the warehouse. Manifest for Warehouse is generated based on “departure date” Cell: V13 and is searching for all shipment that where shipped that day.
all works ok but now I need to move warehouse manifest to different sheet (in the same excel file)
is there any way to keep my setup for warehouse manifest in new sheet, as I was trying (without success ) to move the formula in L column and amended but I am not a “guru” – Yet.

Formula that I need to move:

Formula:

Please Login or Register  to view this content.

Example attached,

Hello and welcome to the forum.

First off, you can shorten that formula to this:
=IFERROR(INDEX(B:B,SMALL(IF(A$8:A$12=V$13,ROW($A$8:$A$12)),ROWS($1:1))),"") Ctrl Shift Enter

or the non-array equivalent:
=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW($A$8:$A$12)/(A$8:A$12=V$13),ROWS($1:1))),"")

Now, if you want to move the info in cells A7:J12 to a different sheet, let's say the same cells in Sheet2, all that you have to do is include sheet references like this:
=IFERROR(INDEX('Sheet2'!B:B,AGGREGATE(15,6,ROW('Sheet2'!$A$8:$A$12)/('Sheet2'!A$8:A$12=V$13),ROWS($1:1))),"")

hi TMS,

in Sheet2 try to change date from 1st april to 3rd. i was coming to the same problem. its not working. but thank you.

63falcondude, you are guru!
works great. thank you.

Add Reputation - click!

Happy to help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Similar to @63falcondude, and work for me

See the file

thank you all for the help.

now as i said "my" manifest will be on each sheet (each month on separate sheet) now if we use Sheet2 as warehouse manifest. and sheet1 as April
can we add to formula to have possibility to change month, something like let say in cell N1 will say its April (name of the tab) and will that data from there, them N1 will be May (name of tab) and will do the same

You guys are the Best!
thank you 63falcondude you my friend are the best of the best ;0)

You're welcome. Happy to help.