🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.apps.spreadsheets
Article #325

Excel Macro question

#325
From: Robert Sipe
Date: Fri, 08 Jan 1993 01:31
15 lines
1009 bytes
I would like to write a macro that would go through a multiple of Excel spread
sheets and pull info out and paste it to another spreadsheet.  The
requirement I have is that columns the info is on is consistent but the
row is not.  To change rows I would like to put in some variable inorder
to select the data I need.  That way I could write a macro where I could
input the row I need the data off of then the script would be able to 
open the necessary spreadsheets and gather the data.

Any suggestions or example scripts would be appriciated.


-- 
Statement made by Oliver North when asked to comment on Clinton's draft
record.  "I would rather vote for Jane Fonda than Gov. Clinton!  At least
she has been to North Vietnam."
Technical Details
Message-ID: <C0IHJw.6sq@bcstec.ca.boeing.com>
Path: arc1-ca.pugleaf.net!sparky!uunet!bcstec!robs

Show Full Headers
Complete Article Headers
Newsgroups: comp.apps.spreadsheets
Path: arc1-ca.pugleaf.net!sparky!uunet!bcstec!robs
From: robs@bcstec.ca.boeing.com (Robert Sipe)
Subject: Excel Macro question
Message-ID: <C0IHJw.6sq@bcstec.ca.boeing.com>
Organization: Boeing
Date: Fri, 8 Jan 1993 01:31:06 GMT
Lines: 15