=" & s.Name & "!C30"
Cells(B, 5) = "=" & s.Name & "!D30"
Cells(B, 6) = "=" & s.Name & "!E30"
B = B + 1
End If
Next s
End Sub
Regards - Dave.
> Date: Mon, 3 May 2010 18:51:55 -0700
> Subject: Re: $$Excel-Macros$$ Macro to d
ot;)
> Cells(B, 6) = s.Range("E30")
> B = B + 1
> End If
> Next s
> End Sub
>
> Regards - Dave.
>
>
>
>
>
> > Date: Wed, 28 Apr 2010 21:24:29 -0700
> > Subject: $$Excel-Macros$$ Macro to display specific
21:24:29 -0700
> Subject: $$Excel-Macros$$ Macro to display specific cells from all sheets
> onto a new sheet
> From: propagan...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi all,
>
> I need help creating a macro that will scan through all sheets (the
> number of sh
Hi all,
I need help creating a macro that will scan through all sheets (the
number of sheets may vary - but, for example, the first one has 51
sheets), then find 5 specific values on each sheet (pretend they are
always in cells A4, B30, C30, D30 and E30) and then display those five
values in a new
