Answer for:

I want to ask about a formula. Is any way to do?

Message 6 of 14

View entire thread
0 Votes

I'm still not clear. You say you want to pull all the data from an existing row, but now you're saying they are entering the data? It sounds like you want the user to see all the rows and columns. They would then go through them and add a 'p' to any rows they want printed, then they press a button and all the data for any row with a 'p' will be printed. Is that correct? If so the first response I gave of using data filtering is the way to go (ie. filter where column contains 'p', then hit the Print button). If you are trying to provide a different sheet with a nicer looking interface that the user sees instead of seeing the table with the data then you're going to need to do some VBA coding.