Copy from one sheet to another

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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]

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