vba code to replace the column names for those column name "Proposal that starts with "1."

**mvneema** · 03-31-2014, 09:25 AM

I am in need of help to build up a macro that will replace the column names at row 4. I have an excel sheet that looks like the sheet1 in the attached. I need to replace the column names for those column name "Proposal#" that has values 1 and 1.* that starts from row 5. It has to loop columnwise and check for each proposal# and if the value is 1 or 1.* then it should replace. The desired output is in the Sheet2. Can anyone please help me on this.

**sktneer** · 03-31-2014, 09:51 AM

Try this code to see if this helps........

Please Login or Register  to view this content.

**alansidman** · 03-31-2014, 09:57 AM

Try this:

Please Login or Register  to view this content.

**mvneema** · 03-31-2014, 10:18 AM

Hi sktneer, i tried your code but it replace all the Proposal# to First Proposal. My requirement was to replace the Proposal# and Votecast for those values with 1.*
Hi alansidman, i tried your code but it didnot replace the Votecast to First Vote Cast but it did replace Proposal# except the Range Q:S

Can you help me on this?

**alansidman** · 03-31-2014, 10:25 AM

Try this:

Please Login or Register  to view this content.

It does not change Columns Q:S because in line 5 they are blank. Your criteria in the first post references row 5 as the source of 1.*

**mvneema** · 03-31-2014, 10:38 AM

Ok alansidman, but I need those Proposal# and Vote Cast from Merged Cell "Current Year" to be replaced by First Proposal# and First Vote Cast for which the values is 1 or 1.*. It has to change the columns Q:S even if the line 5 are blank since I would get data that will be blank sometimes. I have attached an updated excel sheet. Your code did not update the Vote Cast. Can you help me?

**mvneema** · 03-31-2014, 12:18 PM

Can anyone help me on this?

**mvneema** · 03-31-2014, 12:49 PM

Hi, alansidman. I just modified your code but considered only those cells that has 1.* in it and selecting its corresponding offset(0,2) and changing it to "First Vote Cast" But I am still not able to change the columns for the range (Q:S) since its values for the row is blank. Can you provide some help in this.

Please Login or Register  to view this content.

**mvneema** · 03-31-2014, 01:15 PM

I figured it out myself

here is the below code that worked.

Please Login or Register  to view this content.

**alansidman** · 03-31-2014, 01:19 PM

Your lateste explanation is confusing. In your new example I do not see a first vote cast. How about explaining what specifically you want and don't want and forget about me chasing down 50+ columns of data trying to figure it out. Be specific as to what you want changed and what criteria would change it.

**alansidman** · 03-31-2014, 01:21 PM

Ok. I see that you have solved it. Good. Been away for the morning.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

vba code to replace the column names for those column name "Proposal that starts with "1."

LinkBack

Thread Tools

Rate This Thread

Display

vba code to replace the column names for those column name "Proposal that starts with "1."

Re: vba code to replace the column names for those column name "Proposal that starts with

Re: vba code to replace the column names for those column name "Proposal that starts with

Re: vba code to replace the column names for those column name "Proposal that starts with

Re: vba code to replace the column names for those column name "Proposal that starts with

Re: vba code to replace the column names for those column name "Proposal that starts with

Re: vba code to replace the column names for those column name "Proposal that starts with

Re: vba code to replace the column names for those column name "Proposal that starts with

Re: vba code to replace the column names for those column name "Proposal that starts with

Re: vba code to replace the column names for those column name "Proposal that starts with

Re: vba code to replace the column names for those column name "Proposal that starts with

Thread Information

Users Browsing this Thread

Similar Threads

replace all defined range names in the sheet that start with "Street" to "Road"

[SOLVED] Replace all BLANK cells in column with header title "Balance" to "0"

Macro to copy cells from workbook,where column C is = "num1" AND Column D ="num2"

[SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"

Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"

Bookmarks

Bookmarks

Posting Permissions