Jackofalltrades
New Member
- Joined
- Apr 13, 2011
- Messages
- 1
HI,
I have a spreadsheet of items (roughly 200+ items) headers consist of Item#,Barcode, MSRP, wholesale price(C3:C7) and by each item number I have a checkbox(A3:A269) and a quantity to purchase (B3:269). What I want to do is take only the checked (TRUE) items from Sheet1 and populate that information onto sheet2 (organized) which will be an invoice sheet. I want certain information to be placed in specific locations. I searched the forums but could not find anything that would help me. Could anyone point me in the right direction? Thank you
I have a spreadsheet of items (roughly 200+ items) headers consist of Item#,Barcode, MSRP, wholesale price(C3:C7) and by each item number I have a checkbox(A3:A269) and a quantity to purchase (B3:269). What I want to do is take only the checked (TRUE) items from Sheet1 and populate that information onto sheet2 (organized) which will be an invoice sheet. I want certain information to be placed in specific locations. I searched the forums but could not find anything that would help me. Could anyone point me in the right direction? Thank you
