Match list name of header and find blanks cell in row

**shrinivasmj** · 10-22-2012, 07:11 AM

hi,

i need to match Column 1 by the list of name in header, as it is not fixed header names every page ,so need to find by Selected name and need to search for blanks cell in row and paste the blanks header name in remarks row for each column till the end of page
need to put comma after each header name and remove last comma . if find single blank cell add ( is Not Available ),if more add ( are Not Available ) in remarks cell ends of words. NEED VB OR MACRO . all in upper case .

need to search the header name for A1 TO AL1 and look for blanks cell in the row and take in remarks

Service Point No
Source No. (11 Digit )
Mobile / Landline No
Phase (R/Y/B)
Meter Sl. No
Meter Model
Meter Mfg. Year
Current Rating ()Amp)
No of Floors
Meter Floor No

current used vb code ,it take all header and put blanks header name in remarks

Please Login or Register  to view this content.

[B]Moderator Edit: I have put code tags for you. Please do so in future. To put code tags, either select the code and click on the # icon in the toolbar above or type [noparse][code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] after it. [/B]

**arlu1201** · 10-22-2012, 08:49 AM

I see that you have a formula solution already in column AM. Why do you want to do it via code?

Is that formula working for you?

**shrinivasmj** · 10-22-2012, 08:59 AM

Originally Posted by arlu1201

I see that you have a formula solution already in column AM. Why do you want to do it via code?

Is that formula working for you?

hi it is excel formula i need to change the code were the header is there,the

the excel sheet header will be changed in all sheet so i cant change each time the formula ,so request to do a vb code for the selected header name.

**arlu1201** · 10-22-2012, 09:04 AM

But looking at the formula, it seems pretty general and should work with any sheet. Have you tried it in a different sheet with different headers?

**shrinivasmj** · 10-22-2012, 09:24 AM

Originally Posted by arlu1201

But looking at the formula, it seems pretty general and should work with any sheet. Have you tried it in a different sheet with different headers?

Hi
the header names are not in order there might be unwanted header add in every sheet so i need only listed header name to be taken which i listed

**event21** · 10-22-2012, 09:28 AM

Hi -

Just amend your codes a little bit as shown here;

Please Login or Register  to view this content.

You need to select the column name (not the entire column) you want to process before running. Use Ctrl for non-contageous header name.

Regards,
event

**shrinivasmj** · 10-22-2012, 11:10 AM

hi

i am getting this out put first header name two times like, - MOBILE / LANDLINE NO,MOBILE / LANDLINE NO,PHASE (R/Y/B) ARE NOT AVAILABLE.

cant i add all the selected header name in code were its automatically do the search

**event21** · 10-22-2012, 11:35 AM

Hi -

You can put that into array like;

Please Login or Register  to view this content.

**shrinivasmj** · 10-22-2012, 12:09 PM

i got header were i need to add to your code were its auto search and get the result for added list

Please Login or Register  to view this content.

please add the header code to the below code .

Please Login or Register  to view this content.

**arlu1201** · 10-22-2012, 02:51 PM

shrinivasmj,

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

**event21** · 10-22-2012, 09:49 PM

Hi -

I thought you can handle that already;

Please Login or Register  to view this content.

Regards,
event

**shrinivasmj** · 10-22-2012, 11:32 PM

HI

NEED TO PUT THE OUT PUT BELOW TO THE HEADER OF ( REMARKS )

INSTEAD OF TAKING THE row (AM1) ,,,,,, sh.Range("aM" & i) = Mid(strVal, 2) & UCase(ph)

NEED TO SEARCH ( REMARKS HEADER AND PASTE THE OUTPUT BELOW FOR BELOW FORMULA

Please Login or Register  to view this content.

**shrinivasmj** · 10-22-2012, 11:38 PM

HI

i want the vb code this also .

need to find ( METER MAKER ) header name from a1 to am1 and search for unmatch data for ( METER MAKER ) the data list in row and high light unmatch data in colour .(vb or macro )

List of data

LT-LTD

LANDIS+GYR

ALSTOM

INDIAN METERS

Match list name of header and find blanks cell in row

LinkBack

Thread Tools

Rate This Thread

Display

Match list name of header and find blanks cell in row

Re: Match list name of header and find blanks cell in row

Match list name of header and find blanks cell in row

Re: Match list name of header and find blanks cell in row

Re: Match list name of header and find blanks cell in row

Re: Match list name of header and find blanks cell in row

Re: Match list name of header and find blanks cell in row

Re: Match list name of header and find blanks cell in row

Re: Match list name of header and find blanks cell in row

Re: Match list name of header and find blanks cell in row

Re: Match list name of header and find blanks cell in row

Re: Match list name of header and find blanks cell in row

Re: Match list name of header and find blanks cell in row

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions