Article View: comp.sys.mac.apps
Article #2929Quicken and EXCEL
From: Dale Alexander
Date: Fri, 11 Sep 1992 22:01
Date: Fri, 11 Sep 1992 22:01
7 lines
944 bytes
944 bytes
I use Quicken to keep track of finances. Reports made in Quicken can be exported in a format that can be read by Excel. I want to create an "archival" spreadsheet in Excel 4.0 which includes a macro that will automatically copy data from a column of an exported Quicken spreadsheet and paste it in the next available empty column in the archival spreadsheet. What macro command(s) are necessary to have Excel locate the next available empty column in a spreadsheet?
Technical Details
Message-ID:
<dale_alexander-110992165054@msdmac58.msd.anl.gov>Path:
arc1-ca.pugleaf.net!sparky!uunet!europa.asd.contel.com!darwin.sura.net!spool.mu.edu!uwm.edu!ux1.cso.uiuc.edu!milo.mcs.anl.gov!msdmac58.msd.anl.gov!userShow Full Headers
Complete Article Headers
Newsgroups: comp.sys.mac.apps Path: arc1-ca.pugleaf.net!sparky!uunet!europa.asd.contel.com!darwin.sura.net!spool.mu.edu!uwm.edu!ux1.cso.uiuc.edu!milo.mcs.anl.gov!msdmac58.msd.anl.gov!user From: dale_alexander@qmgate.anl.gov (Dale Alexander) Subject: Quicken and EXCEL Message-ID: <dale_alexander-110992165054@msdmac58.msd.anl.gov> Followup-To: comp.sys.mac.apps Sender: usenet@mcs.anl.gov Organization: Argonne National Laboratory Date: Fri, 11 Sep 1992 22:01:08 GMT Lines: 7