PDA

View Full Version : Print Macro and Cell to Populate from table Help!



valendj
04-01-2011, 07:21 AM
Hi,
Two things I need help with. The first one is how do you create a print macro to print just sheet3? The second question is I am not sure how to explain it so I will describe what I need. I need for my Column C to auto populate depending on what I have someone put in Column A. So for example my inspector puts section “6330” in column A4 and fills out B4 but I want C4 to be populated from a table I have on another sheet so C4 should be B-5-S. I attached a file for reference and I hope this makes sense.

nepotist
04-01-2011, 10:13 AM
1) Worksheets("Sheet3").PrintOut

2)Cell C4 =VLOOKUP(A4,Mailinfo!A:C,3,FALSE)