Need data from sheet A to appear in sheet B based on data posted in a column in sheet A?

[Firebird77]

OK! Well that was a confusing title? This is my first post so, please be gentle! I apologize in advance for the long-winded description but, I didn't know any other way to explain this!!

Here's my problem. I have a workbook where Sheet A is a Master Order Form. Employees will input the quantities they need in Column C. The sheet will be otherwise protected. Sheet B is a "printable" order form that only contains the rows from Sheet A where the Quantity on Sheet A is not blank and is >=1. This will allow me to print sheet B with no blank rows for the items I don't need.

Anyway, some time in the past, I found the following formula which claims to be able to do what I want:

=IF(ROWS($1:1)>MAX(C:C),"",INDEX(A:A,MATCH(ROWS($1:1),C:C,0)))

I'm pretty good with Excel but, I'm no pro. This formula is over my head. And, I can't get it to work correctly across two sheets. Can anyone explain, in dummy terms, what this formula is "saying/doing"? I really need my sheet to work and this is the only formula I've found that seems to give me a chance for success.

BTW, any other suggestions would be greatly appreciated!

I've attached a sample of my spreadsheet for your review. Please let me know if you need any further information.

HDForm_Test01.xlsx

Thanks in advance!
Firebird77

[Richard Buttrey]

Hi and welcome to the forum.

Personally I'd be inclined to use a simple filtering macro to extract the records that are marked.
On the Master Order form enter 'QTY' in G1 and '>0' in G2

Now add the following macro and attach it to a simple button shape so that you can simply click the shape to run the macro.

Please Login or Register  to view this content.

[Firebird77]

Thanks for the reply! However, I have to admit that I'm not as skilled in Excel as I would like to be. And, I've never used macros. So, I don't understand exactly how to do what you are suggesting. Can you give me a more step-by-step description?

Thanks again!

[AZ-XL]

Hi
enter this arary formula to a9 cell
=IFERROR(INDEX('Master Order Form'!A:A,SMALL(IF('Master Order Form'!$C$9:$C$23>0,ROW('Master Order Form'!$C$9:$C$23),""),ROW('To Be Sent'!A1))),"")

Hope this is what you want

[Richard Buttrey]

Hi,

See attached

[Firebird77]

WOW!! Thanks to everyone for the suggestions. A special thanks to Richard for the extra effort. All of the suggestions worked great. I think I'm going to try Richard's method first. But, having the other options is a God-send!

Thanks again!
Firebird77

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.