Selective cells for use in a different spreadsheet

Excel Help for Selective Cells For Use In A Different Spreadsheet in Automating Data Analysis Tasks

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 15 Feb 2010

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	VLOOKUP and IF functions Rate this: (3/5 from 1 vote) This can be done with VBA code; however the spreadsheet may be simple enough to do this using formulas. 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 15 Feb 2010

Displaying page 1 of 1