ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   in excel how to pull only used information to another sheet (https://www.excelbanter.com/excel-worksheet-functions/181718-excel-how-pull-only-used-information-another-sheet.html)

kathysperdie04

in excel how to pull only used information to another sheet
 
my employer would like a check sheet that when he checks a in a column cells
it will take that information in that row and put it on another sheet or
worksheet making a proposal form that I do not have to retype. is this
possible. example he has a list of kitchen repairs only check that he did
three of them and then they go to the new page only with the descripiton i
have set up on that line

Pete_UK

in excel how to pull only used information to another sheet
 
Yes, you can do this. You would have a series of VLOOKUP formulae on
the proposal sheet which if you put some code in would "pull" the
information from the other sheet - you can't use a formula to "push"
data, which is how you describe it.

You'll need to give some details about how your data is laid out if
you want more detailed advice.

Hope this helps.

Pete

On Mar 28, 7:18*pm, kathysperdie04
wrote:
my employer would like a check sheet that when he checks a in a column *cells
it will take that information in that row and put it on another sheet or
worksheet making a proposal form that I do not have to retype. *is this
possible. *example he has a list of kitchen repairs only check that he did
three of them and then they go to the new page only with the descripiton i
have set up on that line




All times are GMT +1. The time now is 05:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com