groups.com
Subject: $$Excel-Macros$$ Create worksheet from list
I would like to modify the VBA code in the attached excel spreadsheet so
that when a new sheet is created from InputData tab for Rep 02, Rep 03
and Rep 05 the formatting from the InputData tab is retained.
An alternative might be
difference what r is called. could be lastrow or x or many
things as you desire
-Original Message-
From: airen
Sent: Thursday, September 29, 2011 9:00 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Create worksheet from list
Hi dguillett,
I am a learner, could you ple
THANKS NOORAIN
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
Dear Airen,
r = Cells(Rows.Count, "J").End(xlUp).Row
it is use to find last non-blank row in J Column.
Searching Start from Excel End.
On Thu, Sep 29, 2011 at 7:35 PM, airen wrote:
> Hi dguillett,
> Also give me meaning of "r = Cells(Rows.Count, "J").End(xlUp).Row "
> Thanks
>
> --
>
> -
Hi dguillett,
Also give me meaning of "r = Cells(Rows.Count, "J").End(xlUp).Row "
Thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailyti
Hi dguillett,
I am a learner, could you please tell me meaning of "& r" in
Range("J2:J" & r) in above code.
Thanks
Akhilesh Airen
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks a
Haven’t followed this so
Send your file with a complete explanation and before/after examples to
dguille...@gmail.com
From: Mr excel
Sent: Thursday, September 29, 2011 4:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Create worksheet from list
Macro 1:
Option
*Macro 1:*
Option Explicit
Sub ExtractReps()
Dim ws1 As Worksheet
Dim wsNew As Worksheet
Dim rng As Range
Dim r As Integer
Dim c As Range
Set ws1 = Sheets("Sheet1")
Set rng = Range("Database")
'extract a list of Sales Reps
ws1.Columns("C:C").AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRan
I didn’t see a “like the above” and I answer many emails so please refresh my
memory and attach the file.
From: Mr excel
Sent: Monday, September 26, 2011 10:36 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Create worksheet from list
Mr.guillet..thanks for that great
Mr.guillet..thanks for that great macro.i had a situation same like the
above. A little change is that u had given example for a worksheet with
data.
i want to update all the worksheets as and when i enter new data into the
main sheet.i think it can be done using the On_enter worksheet event.can u
10 matches
Mail list logo