you have use loop then pass the cell address and link to output
sheet/master sheet
Regards
Ashish
On Thu, Mar 28, 2013 at 2:23 AM, Aikistan wrote:
> 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 gener
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.Address(0, 0)
>
> Thanks!
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
Please try the attached file
1 Click on get file names to import the full path of all files to be merged
in the worksheet
2 click on merge to merge the data and paste it in output sheet. Currently
u need to change date in code . you can use input-box or date picker option
if u want to select date
Sorry, didn't see your post until after my cut/paste. Here are 2.
--
Stan
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
