| Home > Forum Home > Automating Data Analysis Tasks > selective cells for use in a different spreadsheet | Share |
Selective cells for use in a different spreadsheet
Excel Help for Selective Cells For Use In A Different Spreadsheet in Automating Data Analysis Tasks
| Forum Topic | Post Reply Login |
Selective Cells For Use In A Different Spreadsheet | Rate this: (3/5 from 1 vote) |
 | Hi all, I have a workbook with data in several sheet, From the data that is entered into one of those sheets I want it to appear in another sheet in a printable format... I need to give certain comands so that the sheet with the printable form will know which sheet to look for and in which cell(s) Hope that I am making sense, and I hope that someone can help me.. Thanks legepe | |
| Posted by legepe on | ||
| Replies - Displaying 1 to 1 of 1 | Order Replies By: Most Recent | Chronological | Highest Rated |
 | Rate this: (3/5 from 1 vote) If this is the case, it could be done with a combination of VLOOKUP and IF functions entered in the printable sheet. The VLOOKUP function can start to look up values from one of the sheets. The IF function can then be wrapped around this several times to encompass the other sheets. |
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for selective cells for use in a different spreadsheet in the Excel Business Solutions Directory |