Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW CAN I PULL INFORMATION FROM ONE SHEET TO ANOTHER IF NOT # | Excel Worksheet Functions | |||
Pull information from a Web page to Excel file | Excel Worksheet Functions | |||
Pull information from one worksheet to another | Excel Discussion (Misc queries) | |||
How do I pull information from one worksheet to another using cer. | Excel Worksheet Functions | |||
How do I pull information from multiple existing spreadsheets int. | Excel Discussion (Misc queries) |