macro 2003 to 2007

Hi, I have a data which looks like this with headers where the columns variable. 423115000001 TYPE -- -- MATERIAL COTTON COTN WEIGHT 100 GM 100GM DIMENSION -- -- ADDITIONAL INFORMATION -- -- I am trying to get the output like below 423115000001 TYPE -- -- 423115000001 MATERIAL COTTON COTN...

Hi everyone, Am having a litter trouble with Macro in excel. here is my code. Sub sampleworksheet()</SPAN> Dim cursheet As Worksheet</SPAN> Dim j As Integer</SPAN> Dim curname As String</SPAN> Dim channame As String</SPAN> Dim modifiedchanname As String</SPAN> 'itterate all worksheets in...

Hi, I'm a beginner to excel and I'm creating a macro that will move values to column B and AI. Here's the scenario I have to check each row and with each row either have two columns that have values or one columns with values the values can either be in any ranges of columns. I know I need to...

I have a VBA object in an Excel 2003 worksheet that triggers three macros when values are attained via streaming data. It runs nicely. I would like to duplicate the worksheet, using different input data, and have both sheets run at the same time. I can have both sheets open now, but the macros...

Hi, I'm new to excel vba and I'm stuck. I need to move the bold names to column [AI]. My code searches for rows and columns that are not blank. I don't know how to move the cell values once the row is not blank. I'd really appreciate any help. This is my code I have to delete the blank rows...

I am looking for a macro to cut a row from a worksheet titled Open QN's to a worksheet titled Closed QN's when the drop down in column A is changed to closed, in excel 2003 (all they use at work). I found a macro on these forums that looks like it will do exactly what I want, but when I copy it...

I would like to use this macro on multiple sheets within this workbook with the same ranges. I would like to copy the Hoffman formats to the next new worksheet. I tried removing "Vierthaler", however my syntax or something is not formatted properly. I want to copy multiple times using this...

I developed a spreadsheet to score golf tournaments, do skins, various flights, etc. to help the Men's Club. It has been fun but an Excel expert, I'm not. If I could solve the problem below without using a macro that would be preferred. Once upon a time I was a programmer, but that's moons...

I have just changed from 2003 to 2007. I have a macro that is written within each sheet (see below) from what i have read, it seems that macros written within each sheet (i right click on the worksheet, and paste the code into the 'view code' bit) are not supported with 2007. therefore I don't...