PDA

View Full Version : Macro application


cool143
Nov 24, 2009, 05:37 PM
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
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.