Macro for Creating WorkSheets

V

vinayguj

New Member
Joined
Jul 8, 2012
Messages
11
Hi All,

I need help for the below activity. I am not well versed in Macros. Below is the scenario.

1. I have one Workbook, with two Worksheets named as; "People" & "Masterfile"

In People Worksheet the Data is as below:

[TABLE="width: 673"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]Column A
[/TD]
[TD="align: center"]Column B
[/TD]
[TD="align: center"]Column C
[/TD]
[TD="align: center"]Column D
[/TD]
[TD="align: center"]Column E
[/TD]
[TD="align: center"]Column F
[/TD]
[/TR]
[TR]
[TD="align: center"]Row 1
[/TD]
[TD="align: center"]Reg No.
[/TD]
[TD="align: center"]Name
[/TD]
[TD="align: center"]Credit
[/TD]
[TD="align: center"]Debit
[/TD]
[TD="align: center"]Reason
[/TD]
[TD="align: center"]Week Nos.
[/TD]
[/TR]
[TR]
[TD="align: center"]Row 2
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]Ajay
[/TD]
[TD="align: center"]10
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]To buy stationary
[/TD]
[TD="align: center"]5
[/TD]
[/TR]
[TR]
[TD="align: center"]Row 3
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"]Vijay
[/TD]
[TD="align: center"]30
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]To buy stationary
[/TD]
[TD="align: center"]5
[/TD]
[/TR]
[TR]
[TD="align: center"]Row 4
[/TD]
[TD="align: center"]3
[/TD]
[TD="align: center"]Sujay
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]50
[/TD]
[TD="align: center"]Paid back pending
[/TD]
[TD="align: center"]5
[/TD]
[/TR]
[TR]
[TD="align: center"]Row 5
[/TD]
[TD="align: center"]4
[/TD]
[TD="align: center"]Ajay
[/TD]
[TD="align: center"]40
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Paid for transport
[/TD]
[TD="align: center"]6
[/TD]
[/TR]
</tbody>[/TABLE]


Masterfile worksheet has following data:

[TABLE="width: 420"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]Column A
[/TD]
[TD="align: center"]Column B
[/TD]
[TD="align: center"]Column C
[/TD]
[TD="align: center"]Column D
[/TD]
[/TR]
[TR]
[TD="align: center"]Row 1
[/TD]
[TD="align: center"]Name
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Row 2
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Row 3
[/TD]
[TD="align: center"]Transactions Reason
[/TD]
[TD="align: center"]Week Nos.
[/TD]
[TD="align: center"]Debit
[/TD]
[TD="align: center"]Creadit
[/TD]
[/TR]
[TR]
[TD="align: center"]Row 4
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Row 5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


The Macro should
1. Create number of "Masterfile" worksheets based on the number of Names in the "People" worksheet, and rename the worksheet with the name, but if already created, then do not create again.
For Example: Worksheets by Name: "Ajay", "Vijay", "Sujay"

2. In the Worksheet "Ajay", the details of Name, Transaction Reason, Week Nos., Debit, Credit, should be filled corresponding to the Data in the "People" Worksheet. For Example:

[TABLE="width: 420"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]Column A
[/TD]
[TD="align: center"]Column B
[/TD]
[TD="align: center"]Column C
[/TD]
[TD="align: center"]Column D
[/TD]
[/TR]
[TR]
[TD="align: center"]Row 1
[/TD]
[TD="align: center"]Name
[/TD]
[TD="align: center"]Ajay
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Row 2
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Row 3
[/TD]
[TD="align: center"]Transactions Reason
[/TD]
[TD="align: center"]Week Nos.
[/TD]
[TD="align: center"]Debit
[/TD]
[TD="align: center"]Creadit
[/TD]
[/TR]
[TR]
[TD="align: center"]Row 4
[/TD]
[TD="align: center"]To buy stationary
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]10
[/TD]
[/TR]
[TR]
[TD="align: center"]Row 5
[/TD]
[TD="align: center"]Paid for transport
[/TD]
[TD="align: center"]6[/TD]
[TD][/TD]
[TD="align: center"]40[/TD]
[/TR]
</tbody>[/TABLE]


3. Similarly in other worksheets of Vijay and Sujay.

I hope somebody helps at the earliest.

Thanks in Advance.
 
Sort by date Sort by votes
Yes Dave, there is other data as well in the "Masterfile" worksheet. :(

Precisely, the output in of the worksheets would be looking someting like the below.

[TABLE="width: 760"]
<tbody>[TR]
[TD]Row 1
[/TD]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[TD]Column C
[/TD]
[TD]Column D
[/TD]
[TD]Column E
[/TD]
[/TR]
[TR]
[TD]Row 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 3
[/TD]
[TD]Name
[/TD]
[TD]Ajay
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 7
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 8
[/TD]
[TD][/TD]
[TD]Week No.
[/TD]
[TD]Week No.
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[/TR]
[TR]
[TD]Row 9
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 10
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 11
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 12
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 13
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 14
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 15
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 16
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 18
[/TD]
[TD]Transaction Reasons
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 19
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 20
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 21
[/TD]
[TD][/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 22
[/TD]
[TD][/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 23
[/TD]
[TD]To buy stationery
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]10.00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 24
[/TD]
[TD]Paid for Transport
[/TD]
[TD]6
[/TD]
[TD]6
[/TD]
[TD]40.00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 25
[/TD]
[TD][/TD]
[TD]7
[/TD]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 26
[/TD]
[TD][/TD]
[TD]8
[/TD]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 27
[/TD]
[TD][/TD]
[TD]9
[/TD]
[TD]9
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 28
[/TD]
[TD][/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 29
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

All the Blank Cells inbetween has some other data which needs to be carried onto all the worksheets.
All the words in bold would already be in the "Masterfile", just as a Template.

The Name, Transaction Reason, Credits, Debits is what the Macro should copy and paste from the People WorkSheet but corresponding to that person.

Above is an example I have shown for Ajay.

I know, I am making it very complex now. I am sorry, I should have given these details earlier.
Sorry for the trouble.
Thanks a million for your efforts and help!
 
Upvote 0

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
vinayguj said:
Yes Dave, there is other data as well in the "Masterfile" worksheet. :(

Precisely, the output in of the worksheets would be looking someting like the below.

[TABLE="width: 760"]
<TBODY>[TR]
[TD]Row 1
[/TD]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[TD]Column C
[/TD]
[TD]Column D
[/TD]
[TD]Column E
[/TD]
[/TR]
[TR]
[TD]Row 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 3
[/TD]
[TD]Name
[/TD]
[TD]Ajay
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 7
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 8
[/TD]
[TD][/TD]
[TD]Week No.
[/TD]
[TD]Week No.
[/TD]
[TD]Credits
[/TD]
[TD]Debits
[/TD]
[/TR]
[TR]
[TD]Row 9
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 10
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 11
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 12
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 13
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 14
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 15
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 16
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 17
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 18
[/TD]
[TD]Transaction Reasons
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 19
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 20
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 21
[/TD]
[TD][/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 22
[/TD]
[TD][/TD]
[TD]4
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 23
[/TD]
[TD]To buy stationery
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]10.00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 24
[/TD]
[TD]Paid for Transport
[/TD]
[TD]6
[/TD]
[TD]6
[/TD]
[TD]40.00
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 25
[/TD]
[TD][/TD]
[TD]7
[/TD]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 26
[/TD]
[TD][/TD]
[TD]8
[/TD]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 27
[/TD]
[TD][/TD]
[TD]9
[/TD]
[TD]9
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 28
[/TD]
[TD][/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row 29
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

All the Blank Cells inbetween has some other data which needs to be carried onto all the worksheets.
All the words in bold would already be in the "Masterfile", just as a Template.

The Name, Transaction Reason, Credits, Debits is what the Macro should copy and paste from the People WorkSheet but corresponding to that person.

Above is an example I have shown for Ajay.

I know, I am making it very complex now. I am sorry, I should have given these details earlier.
Sorry for the trouble.
Thanks a million for your efforts and help!
Click to expand...


In this case it may be better to adapt code bertie kindly posted.

Dave
 
Upvote 0
Hi To All!
i have created a user form using VBA in excel for budget preparation, but i have challenge to add VBA codes than can link data in the form into excel report,
can someone help!

Thanks.
Faustim
 
Upvote 0
Faustin said:
Hi To All!
i have created a user form using VBA in excel for budget preparation, but i have challenge to add VBA codes than can link data in the form into excel report,
can someone help!

Thanks.
Faustim
Click to expand...

Hi Faustim, and welcome to the forum.

Can I please ask you to start a new thread for your problem. Feel free to drop me a pm to with a link to the thread.

You will find you will get a faster response if you provide more detail.
Is the form on a spreadsheet or is it a UserForm?
How do the form cells/controls map to the report? i.e.,

cell/control on form => column A on report,
cell/control on form => column B on report, etc.

If it is a UserForm please provide the names of your controls.
[Edit:] The name(s) of your spreadsheets would also be helpful.

Thanks,
Bertie
 
Upvote 0
Hi Vinayguj,

I have amended the output of my code (see the "Process Name" section) based on the layout of the masterfile sheet in post#11.

try this:
Code: 
[COLOR=darkblue]Option[/COLOR] [COLOR=darkblue]Explicit[/COLOR]


[COLOR=darkblue]Sub[/COLOR] CreateNamedWorksheets()
   [COLOR=darkblue]Dim[/COLOR] wsNew [COLOR=darkblue]As[/COLOR] Worksheet     [COLOR=green]'new worksheet[/COLOR]
   [COLOR=darkblue]Dim[/COLOR] rng [COLOR=darkblue]As[/COLOR] Range           'People sheet loop range
   [COLOR=darkblue]Dim[/COLOR] SheetName [COLOR=darkblue]As[/COLOR] [COLOR=darkblue]String[/COLOR]    [COLOR=green]'new worksheet name[/COLOR]
   [COLOR=darkblue]Dim[/COLOR] rw [COLOR=darkblue]As[/COLOR] [COLOR=darkblue]Long[/COLOR]             [COLOR=green]'next available row[/COLOR]
   [COLOR=darkblue]Dim[/COLOR] weekNum [COLOR=darkblue]As[/COLOR] [COLOR=darkblue]Long[/COLOR]
   
   [COLOR=green]'sort the data[/COLOR]
   SortColumnB
   
   [COLOR=green]'loop through the data until column B(name) has no value[/COLOR]
   [COLOR=darkblue]Set[/COLOR] rng = Sheets("People").Range("B2")
   [COLOR=darkblue]Do[/COLOR] [COLOR=darkblue]Until[/COLOR] rng = ""
      
      [COLOR=green]'check the sheet exists[/COLOR]
      SheetName = rng.Value
      [COLOR=darkblue]If[/COLOR] [COLOR=darkblue]Not[/COLOR] WorksheetExists(SheetName) [COLOR=darkblue]Then[/COLOR]
         Sheets("Masterfile").Copy After:=Worksheets(Worksheets.Count)
         ActiveSheet.Name = SheetName
         [COLOR=darkblue]Set[/COLOR] wsNew = Sheets(SheetName)
      [COLOR=darkblue]Else[/COLOR]
         [COLOR=darkblue]Set[/COLOR] wsNew = Sheets(SheetName)
      [COLOR=darkblue]End[/COLOR] [COLOR=darkblue]If[/COLOR]


      [COLOR=green]'process name[/COLOR]
      wsNew.Range("B3") = SheetName
      
      [COLOR=darkblue]Do[/COLOR] [COLOR=darkblue]While[/COLOR] rng.Value = SheetName
         [COLOR=darkblue]With[/COLOR] wsNew
            rw = 18 + rng.Offset(, 4).Value
            .Range("A" & rw).Value = rng.Offset(, 3).Value  [COLOR=green]'transaction[/COLOR]
            .Range("D" & rw).Value = rng.Offset(, 1).Value  'credits
            .Range("E" & rw).Value = rng.Offset(, 2).Value  [COLOR=green]'Debits[/COLOR]
         [COLOR=darkblue]End[/COLOR] [COLOR=darkblue]With[/COLOR]
         
         [COLOR=darkblue]Set[/COLOR] rng = rng.Offset(1, 0)
      [COLOR=darkblue]Loop[/COLOR]
      
   [COLOR=darkblue]Loop[/COLOR]
   
   [COLOR=darkblue]Set[/COLOR] rng = [COLOR=darkblue]Nothing[/COLOR]
   [COLOR=darkblue]Set[/COLOR] wsNew = [COLOR=darkblue]Nothing[/COLOR]
[COLOR=darkblue]End[/COLOR] [COLOR=darkblue]Sub[/COLOR]




[COLOR=darkblue]Private[/COLOR] [COLOR=darkblue]Sub[/COLOR] SortColumnB()
   Worksheets("People").Range("B1").Sort _
        Key1:=Worksheets("People").Columns("B"), _
        Header:=[COLOR=darkblue]True[/COLOR]
[COLOR=darkblue]End[/COLOR] [COLOR=darkblue]Sub[/COLOR]






[COLOR=darkblue]Private[/COLOR] [COLOR=darkblue]Function[/COLOR] WorksheetExists([COLOR=darkblue]ByVal[/COLOR] SheetName [COLOR=darkblue]As[/COLOR] [COLOR=darkblue]String[/COLOR]) [COLOR=darkblue]As[/COLOR] [COLOR=darkblue]Boolean[/COLOR]
   [COLOR=darkblue]On[/COLOR] [COLOR=darkblue]Error[/COLOR] [COLOR=darkblue]Resume[/COLOR] [COLOR=darkblue]Next[/COLOR]
      WorksheetExists = Sheets(SheetName).Name = SheetName
   [COLOR=darkblue]On[/COLOR] [COLOR=darkblue]Error[/COLOR] [COLOR=darkblue]GoTo[/COLOR] 0
[COLOR=darkblue]End[/COLOR] [COLOR=darkblue]Function[/COLOR]


 
Upvote 0
bertie said:
Hi Faustim, and welcome to the forum.

Can I please ask you to start a new thread for your problem. Feel free to drop me a pm to with a link to the thread.

You will find you will get a faster response if you provide more detail.
Is the form on a spreadsheet or is it a UserForm?
How do the form cells/controls map to the report? i.e.,

cell/control on form => column A on report,
cell/control on form => column B on report, etc.

If it is a UserForm please provide the names of your controls.
[Edit:] The name(s) of your spreadsheets would also be helpful.

Thanks,
Bertie
Click to expand...


Thanks Bertie,
would you please advise how i can start a new thread, so that i can explain in details my question.
Thanks.
 
Upvote 0
Faustin said:
Thanks Bertie,
would you please advise how i can start a new thread, so that i can explain in details my question.
Thanks.
Click to expand...

Excel Forum
Top left
Click on Post New Thread.

Once you have posted the thread
Go to the Excel forum - find the thread - right click and select - copy link address
Click on my name - select Send Private message - paste the link.

See here for more extensive guidelines.
http://www.mrexcel.com/forum/showthread.php?127080-Guidelines-for-posting-(updated-22-Nov-2006)
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Using Sheets().Select in a Worksheet_Activate() macro
2
Replies
10
Views
424
jdun
J
C
  • Question Question
Creating a Card Flipper using VBA
Replies
0
Views
203
Cquake
C
W
  • Question Question
Macro/VBA code code for creating new excel file for each pivot table from a column filter
Replies
1
Views
357
Anthony47
A
N
  • Question Question
Finding the differences then copy and paste code to a new sheet
Replies
1
Views
582
myall_blues
myall_blues
Z
  • Question Question
VBA Process Flow Chart using Shapes & Connectors
Replies
2
Views
140
zlotowlosapl
Z

Forum statistics

Threads
1,223,237
Messages
6,170,924
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top