Copy from one sheet to another
 

Hello,

In the same workbook, is there a way to automatically copy from one sheet to
another sheet?

For example, multiple users will be putting various information, both
letters and numbers, no formulas, into rows in multiple sheets in the
workbook. We are trying to create a "summary sheet" that combines every
users information.

Thank you

Copy from one sheet to another
 

Simple cell links may do the job if laid out properly.

If you want VBA coding see Ron de Bruin's site.

http://www.rondebruin.nl/tips.htm

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 12:16:03 -0700, nabanco
wrote:

Hello,

In the same workbook, is there a way to automatically copy from one sheet to
another sheet?

For example, multiple users will be putting various information, both
letters and numbers, no formulas, into rows in multiple sheets in the
workbook. We are trying to create a "summary sheet" that combines every
users information.

Thank you

Copy from one sheet to another
 

Thank you Gord. I checked out the website. I am very green at excel. How
would I go about adding in a macro?

"Gord Dibben" wrote:

Simple cell links may do the job if laid out properly.

If you want VBA coding see Ron de Bruin's site.

http://www.rondebruin.nl/tips.htm

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 12:16:03 -0700, nabanco
wrote:

Hello,

In the same workbook, is there a way to automatically copy from one sheet to
another sheet?

For example, multiple users will be putting various information, both
letters and numbers, no formulas, into rows in multiple sheets in the
workbook. We are trying to create a "summary sheet" that combines every
users information.

Thank you

Copy from one sheet to another
 

See David McRitchie's website for getting started with VBA.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

You may want to look at a specific example at Ron's site.

http://www.rondebruin.nl/copy2.htm

At the page bottom there is a link to David's site and some information on where
to store the code.


Gord


On Thu, 26 Jul 2007 05:40:04 -0700, nabanco
wrote:

Thank you Gord. I checked out the website. I am very green at excel. How
would I go about adding in a macro?

"Gord Dibben" wrote:

Simple cell links may do the job if laid out properly.

If you want VBA coding see Ron de Bruin's site.

http://www.rondebruin.nl/tips.htm

Browse through the section on Copy/Paste/Merge examples


Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 12:16:03 -0700, nabanco
wrote:

Hello,

In the same workbook, is there a way to automatically copy from one sheet to
another sheet?

For example, multiple users will be putting various information, both
letters and numbers, no formulas, into rows in multiple sheets in the
workbook. We are trying to create a "summary sheet" that combines every
users information.

Thank you