Re: $$Excel-Macros$$ Sample Data

2013-03-27 Thread Aikistan
It is definitely NOT that. On Wednesday, March 27, 2013 4:14:26 PM UTC-4, Aikistan wrote: > That worked! However...now they want to generate links to the 50+ sheets, > rather than the values themselves. Would that be: > > rng2.Copy Destination.Formula:= "=" & rng.

Re: $$Excel-Macros$$ Sample Data

2013-03-27 Thread Aikistan
That worked! However...now they want to generate links to the 50+ sheets, rather than the values themselves. Would that be: rng2.Copy Destination.Formula:= "=" & rng.Address(0, 0) Thanks! On Wednesday, March 27, 2013 12:37:56 PM UTC-4, ashish wrote: > Please try the attached file > > 1 Cli

Re: $$Excel-Macros$$ Macro newb - copy rows from multiple workbooks using condition

2013-03-27 Thread Aikistan
BlackBerry® from Vodafone > -- > *From: *Aikistan > > *Sender: *excel-...@googlegroups.com > *Date: *Wed, 27 Mar 2013 08:06:39 -0700 (PDT) > *To: *> > *ReplyTo: *excel-...@googlegroups.com > *Subject: *$$Excel-Macros$$ Macro newb - copy rows from multiple &g

$$Excel-Macros$$ Macro newb - copy rows from multiple workbooks using condition

2013-03-27 Thread Aikistan
Hello everyone, this is my first post here, so please bear with me. I have about 50 individual workbooks with the same layout and I need to combine them into another workbook but only if cells in column D meet my criteria. The columns are A-D and contain ID, Name, Amount, and Date. I need on