Retrieve data from all of the worksheet within the file
 

How do I get datas from ALL of the worksheet within the file into a
"master worksheet". REMEMBER ALL WORKSHEETS

In the master worksheet:
Column A = worksheet name (example "Sheet 1")
Column B = get data in cell B1 from each worksheet
Column C = get data in cell B2 from each worksheet
Column D = get data in cell B3 from each worksheet
Column E = get data in cell K20 from each worksheet
Column F = get data in cell C26 from each worksheet


--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032
View this thread: http://www.excelforum.com/showthread...hreadid=525392

Retrieve data from all of the worksheet within the file
 

Hi dannyboy213

Create links to the cells with this macro
http://www.rondebruin.nl/summary.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"dannyboy213" wrote in message
...

How do I get datas from ALL of the worksheet within the file into a
"master worksheet". REMEMBER ALL WORKSHEETS

In the master worksheet:
Column A = worksheet name (example "Sheet 1")
Column B = get data in cell B1 from each worksheet
Column C = get data in cell B2 from each worksheet
Column D = get data in cell B3 from each worksheet
Column E = get data in cell K20 from each worksheet
Column F = get data in cell C26 from each worksheet


--
dannyboy213
------------------------------------------------------------------------
dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032
View this thread: http://www.excelforum.com/showthread...hreadid=525392