| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
(macro, formula,...) To Copy columm in various sheet's
I have a file in excel with various sheet's, i want to copy the columm H (from all the sheet's) and paste in only one columm in the same file (or another), in a automatic way (macro, formula,....). How can this be done????? PS. The columm contains numbers (with formulas), and it's in Excel 97 Thanks :-D -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=387118 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
(macro, formula,...) To Copy columm in various sheet's
A better explanation/example of what you want.
-- Don Guillett SalesAid Software "pmarques" wrote in message ... I have a file in excel with various sheet's, i want to copy the columm H (from all the sheet's) and paste in only one columm in the same file (or another), in a automatic way (macro, formula,....). How can this be done????? PS. The columm contains numbers (with formulas), and it's in Excel 97 Thanks :-D -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=387118 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
(macro, formula,...) To Copy columm in various sheet's
Don Guillett Wrote: A better explanation/example of what you want +------------------------------------------------------------------- |Filename: test.zip |Download: http://www.excelforum.com/attachment.php?postid=3599 +------------------------------------------------------------------- -- pmarque ----------------------------------------------------------------------- pmarques's Profile: http://www.excelforum.com/member.php...fo&userid=2511 View this thread: http://www.excelforum.com/showthread.php?threadid=38711 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
(macro, formula,...) To Copy columm in various sheet's
untested...
Dim iLastRow As Long Dim iNextRow As Long Dim sh As Worksheet Dim shSumm As Worksheet Set shSumm = Worksheets.Add shSumm.Name = "Sum,mary" iNextRow= 1 For Each sh In Activeworkbook.Worksheets If sh.Name < shSumm.Name Then ilastRow = sh.Cells(Rows.Count,"H").End(xUp).Row sh.Range("H1").Resize(iLastRow).Copy _ shSumm.Range("H" & iNextRow) iNextRow = iNextRow + iLastRow End If Next sh -- HTH RP (remove nothere from the email address if mailing direct) "pmarques" wrote in message ... I have a file in excel with various sheet's, i want to copy the columm H (from all the sheet's) and paste in only one columm in the same file (or another), in a automatic way (macro, formula,....). How can this be done????? PS. The columm contains numbers (with formulas), and it's in Excel 97 Thanks :-D -- pmarques ------------------------------------------------------------------------ pmarques's Profile: http://www.excelforum.com/member.php...o&userid=25110 View this thread: http://www.excelforum.com/showthread...hreadid=387118 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| <ASK How to add columm more than the default columm IV | Excel Discussion (Misc queries) | |||
| formula to insert a row of consective numbers in a columm (1tru 5 | Excel Worksheet Functions | |||
| How to copy a sheet's formatting from one xls to another? | Excel Discussion (Misc queries) | |||
| What is the formula for adding up *values! in a columm in exell | Charts and Charting in Excel | |||
| (macro, formula,...) To Copy columm in various sheet's | Excel Discussion (Misc queries) | |||
Hybrid Mode
