jayzeus
06-23-2008, 12:33 PM
Hello,
I'm working on a project where I have to write an Excel macro. I've never worked with excel that extensively, but I have a good computer/programming knowledge. I've worked with vb .net before, but looks like excel's macros have their own set of methods, and commands. So bear with me.
What I'm needing to do is to write/build a macro that will build a table and fill the columns according to some simple logic that I have here, while parsing two other column/worksheets for data.
It sounds pretty simple but I just don't know the syntax enough.
Here's an example of the logic:
Column W (all cells that is) in worksheet "worksheet A":
If column BT on worksheet "worksheet B" = 'some string' then Column W = "Y", else "N"
Of course this needs to run through as many times as there are entries in the corresponding columns, so I'm assuming that there needs to be some sort of a loop? Unless there's a method for that.
Any ideas on how I could accomplish this?
I'm working on a project where I have to write an Excel macro. I've never worked with excel that extensively, but I have a good computer/programming knowledge. I've worked with vb .net before, but looks like excel's macros have their own set of methods, and commands. So bear with me.
What I'm needing to do is to write/build a macro that will build a table and fill the columns according to some simple logic that I have here, while parsing two other column/worksheets for data.
It sounds pretty simple but I just don't know the syntax enough.
Here's an example of the logic:
Column W (all cells that is) in worksheet "worksheet A":
If column BT on worksheet "worksheet B" = 'some string' then Column W = "Y", else "N"
Of course this needs to run through as many times as there are entries in the corresponding columns, so I'm assuming that there needs to be some sort of a loop? Unless there's a method for that.
Any ideas on how I could accomplish this?