Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Question
I am trying to pull information from specific cells on an excel spreadsheet A to excel spreadsheet B. The problem I am facing is that excel spreadsheet A has multiple tabs (about a hundred with all data in exactly the same location on each tab) and cannot figure out a way to pull the information using a macro onto 1 tab on excel spreasheet B. Does anyone know what I can do? Thanks. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Question
Dim sh as Worksheet, rng as Range
for each sh in workbooks("spreadsheetA.xls") With workbooks("speadsheetb.xls").Worksheets(1) set rng = .cells(rows.count,1).End(xlup)(2) end with sh.Range("A1").CurrentRegion.Copy _ Destination:=rng End With Next -- Regards, Tom Ogilvy "Oli Oshiz" wrote in message ... I am trying to pull information from specific cells on an excel spreadsheet A to excel spreadsheet B. The problem I am facing is that excel spreadsheet A has multiple tabs (about a hundred with all data in exactly the same location on each tab) and cannot figure out a way to pull the information using a macro onto 1 tab on excel spreasheet B. Does anyone know what I can do? Thanks. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Excel 2003 to Excel 2007 Question | Excel Worksheet Functions | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Excel 2000 versus Excel 2002 question | Excel Programming |