Article View: comp.apps.spreadsheets
Article #325Excel Macro question
From: Robert Sipe
Date: Fri, 08 Jan 1993 01:31
Date: Fri, 08 Jan 1993 01:31
15 lines
1009 bytes
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!robsShow 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