software

I have several woksheets in a workbook that have differing data - Words
letter and numbers. I would like to create a summary sheet. I have worked out
how to get the data into the summary sheet. However the sheets have all been
renamed so i must insert every formula manually. Is there anyway for excel to
auto generate the formula for every sheet in the workbook?

Try this

www.rondebruin.nl/summary.htm

--
Regards Ron de Bruin
www.rondebruin.nlquot;NicNIcquot; gt; wrote in message ...
gt;I have several woksheets in a workbook that have differing data - Words
gt; letter and numbers. I would like to create a summary sheet. I have worked out
gt; how to get the data into the summary sheet. However the sheets have all been
gt; renamed so i must insert every formula manually. Is there anyway for excel to
gt; auto generate the formula for every sheet in the workbook?
Don't understand the notation on this. Can you help?

quot;Ron de Bruinquot; wrote:

gt; Try this
gt;
gt; www.rondebruin.nl/summary.htm
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;NicNIcquot; gt; wrote in message ...
gt; gt;I have several woksheets in a workbook that have differing data - Words
gt; gt; letter and numbers. I would like to create a summary sheet. I have worked out
gt; gt; how to get the data into the summary sheet. However the sheets have all been
gt; gt; renamed so i must insert every formula manually. Is there anyway for excel to
gt; gt; auto generate the formula for every sheet in the workbook?
gt;
gt;
gt;

The data in the worksheets have no formulas they are just typed information.
Does this make the process a little easier?

quot;Ron de Bruinquot; wrote:

gt; Try this
gt;
gt; www.rondebruin.nl/summary.htm
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;NicNIcquot; gt; wrote in message ...
gt; gt;I have several woksheets in a workbook that have differing data - Words
gt; gt; letter and numbers. I would like to create a summary sheet. I have worked out
gt; gt; how to get the data into the summary sheet. However the sheets have all been
gt; gt; renamed so i must insert every formula manually. Is there anyway for excel to
gt; gt; auto generate the formula for every sheet in the workbook?
gt;
gt;
gt;

Hi NicNIc

This macro will make a link to every cell you in the range
Range(quot;A1,D5:E5,Z10quot;)
Change to the cells you want
Note: if you want to create many links from each sheet this is not the best option (max 256)

Alt-F11
Insertgt;Module from the menubar
paste the sub in there from my site
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select quot;Summary_All_Worksheets_With_Formulasquot; and press RunYou can also use the indirect function to create your formulas manual
Start here
www.cpearson.com/excel/indirect.htm
--
Regards Ron de Bruin
www.rondebruin.nlquot;NicNIcquot; gt; wrote in message ...
gt; The data in the worksheets have no formulas they are just typed information.
gt; Does this make the process a little easier?
gt;
gt; quot;Ron de Bruinquot; wrote:
gt;
gt;gt; Try this
gt;gt;
gt;gt; www.rondebruin.nl/summary.htm
gt;gt;
gt;gt; --
gt;gt; Regards Ron de Bruin
gt;gt; www.rondebruin.nl
gt;gt;
gt;gt;
gt;gt; quot;NicNIcquot; gt; wrote in message ...
gt;gt; gt;I have several woksheets in a workbook that have differing data - Words
gt;gt; gt; letter and numbers. I would like to create a summary sheet. I have worked out
gt;gt; gt; how to get the data into the summary sheet. However the sheets have all been
gt;gt; gt; renamed so i must insert every formula manually. Is there anyway for excel to
gt;gt; gt; auto generate the formula for every sheet in the workbook?
gt;gt;
gt;gt;
gt;gt;