Get data from one sheet and move to another based on info....Its not doing what it should be doing.

JBJones82

New Member
Joined
Jun 29, 2014
Messages
9
Ok I dont know what I am doing wrong. You guys have all helped me in the Past so I am hoping you guys can do it again.

I have 2 sheets and I want to only take the Rejected Jobs from the one sheet and have them Auto fill in the other. I have tried this by
{=IF(ROWS(A$5:A7)<=$B$3,INDEX(Dock,SMALL(IF('Project Tracker'!STATUS='Rejection Log'!$A$3,ROW('Project Tracker'!STATUS)-ROW('Project Tracker'!$E$4)+1),ROWS($A6:A6))),"")}

Gives me the first one in all the cells counted(rejected).

and

I have done it without the Array also

JOB LOG

DateDockConstruction Sales Force IDProject NameSTATUSMARKETCITYLOB / Project TypeZoneOUNOTES/COMMENTS
9/24/2014120085544691SHENBERGER AND ASSOCIATES INCSent to designMID WESTBRECKSVILLE403 DOCSIS Commercial New Build
9/24/2014121532546498PAETECPend WOVMID WESTCLEVELAND403 Wholesale
9/24/2014120033544667TRUENORTH ENERGY-MAINRejectedMID WESTJEFFERSON403 DOCSIS Commercial New Build
9/24/2014120537NA2352484 - JORDY ROBISONSent to designMID WESTCLEVELAND401 Residential New Build
9/24/2014119081543524BILLPRO MANAGEMENT SYSTEMS INC.Sent to designMID WESTWICKLIFFE403 Fiber Commercial New Build
9/24/2014120361545096MILLENNIUM-RHM AURORA LLCRejectedMID WESTCHAGRIN FALLS403 DOCSIS Commercial New Build
9/24/2014121125545953FAMILY DOLLAR COAXSent to designMID WESTUNION CITY403 DOCSIS Commercial New Build
9/24/2014121092545829CORPORATE GLASS INCSent to designMID WESTERIE403 DOCSIS Commercial New Build

<tbody>
</tbody>


Rejected Log

DockConstruction Sales Force IDProject NameDivisionZoneField Survey CoordinatorConstruction CoordinatorDate RejectedDate ReturnedRejection ReasonRejection CodeComments
120033544667TRUENORTH ENERGY-MAINMID WEST009/24/14
120033544667TRUENORTH ENERGY-MAINMID WEST009/24/14
120033544667TRUENORTH ENERGY-MAINMID WEST009/24/14
120033544667TRUENORTH ENERGY-MAINMID WEST009/24/14
120033544667TRUENORTH ENERGY-MAINMID WEST009/24/14
120033544667TRUENORTH ENERGY-MAINMID WEST009/24/14
120033544667TRUENORTH ENERGY-MAINMID WEST009/24/14
120033544667TRUENORTH ENERGY-MAINMID WEST009/24/14
120033544667TRUENORTH ENERGY-MAINMID WEST009/24/14

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

JBJones82

New Member
Joined
Jun 29, 2014
Messages
9
This sample I only put in 2 rejections on the Rejected Log there are 9 because that is what was on the real reports for both. So it is giving me the right Rejection first just not the next one in line.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,599
Messages
5,597,105
Members
414,125
Latest member
iQQ

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top