Ask Experts Questions for FREE Help !
Ask
    cool143's Avatar
    cool143 Posts: 7, Reputation: 1
    New Member
     
    #1

    Nov 24, 2009, 05:37 PM
    Macro application
    Hello,

    I have a query in macro.

    I have 2 excel sheet. In 1st sheet I have list of rows. For eg: 20 rows (may vary)(5 columns).

    In 2nd sheet 1-3 names.

    Now, If in 2nd sheet, I have one name, then in 1st sheet at the end column (6th column) , I want that names to be displayed.

    If in 2nd sheet, there are 2 names, then in 1st sheet, I want 1st row as 1st name, 2nd row as 2nd name, 3rd row as 1st name, 4th row as 2nd name and till last row.

    If in 2nd sheet, there are 3 names, then in 1st sheet, I want 1st row as 1st name, 2nd row as 2nd name, 3rd row as 3rd name, 4th row as 1st name and so on.

    Is this possible in macro??
    Perito's Avatar
    Perito Posts: 3,139, Reputation: 150
    Ultra Member
     
    #2

    Nov 24, 2009, 07:40 PM

    I don't quite understand what you're wanting to do. You're going to have to be much more explicit than you have been. I'll say this. It's possible to reference cells directly in other sheets.

    When you create a "macro", you really create a VBA (Visual Basic for Applications) program. If you know understand programming in Visual Basic, you can do pretty much whatever you want to do.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Is ITIN application and tax refund application different? [ 2 Answers ]

I applied for ITIN with my tax return this year. Do I need to apply again for my tax return separately or tax return application with ITIN is sufficient?

Macro application [ 3 Answers ]

Hi, I wanted to create an macro application. In 1st sheet, I have 5 columns and 1000 rows (may vary). In 2nd sheet, I have 5 columns and 1000 rows (may vary). Now I wanted to compare 1st sheet with 2nd sheet (Only one column) If cells in sheet1 is not equal to sheet2, copy that entire...

Macro help [ 3 Answers ]

Hi all, I am currently working with a dataset where the data in column A is empty until a user enters a rank (i.e. like ranking grades in ascending order). Currently the macro takes the number and moves the row entry to the top by assuming that the rank is to be the highest rank (it then takes...

Pending appeal of your old application for benefits, can you file new application? [ 1 Answers ]

Pending appeal of your old application for benefits, can you file new application?

Application to accelerate & application to revoke [ 14 Answers ]

Application to accelerate and application to revoke? What are the different. :cool:


View more questions Search