Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
How to search column, copy row, and copy to another sheet in same | Excel Discussion (Misc queries) | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
'Copy to' Advance Filter depend only on sheet ID not start sheet | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |