Search results for query: *

intresting...No I didn't. I am glad it worked for you. I will try again in a bit. Thank you so much for looking into this! Ray.

I stand corrected I hit the star but did not complete the next step. I did now. Yes I did run the macro and it works great. The only thing is when I replace the B column with a HX0001 then I get an error on this line. intLstRow = Range("A" & ActiveSheet.Rows.Count).End(xlUp).Row Thanks!

Hi Guys, I do believe I clicked the star for John. Now that I am understanding this a bit, can you answer another question?What if the B column is not an integer and you would like the same output? Ho do I call the character instead of the integer? Sector Neighbor HX00081 HX00082 HX00081...

WOW! Thank you so much anotherhiggins! It work perfect. Bottom up approach is a very nice touch! Thank you! Thank you! Thank you! Ray

Thank you Anotherhiggins and Gavona. Anotherhiggins I posted to the below thread and I read a bit of your FAQ 182 doc. Gavona your method works well. Unfortunantly I forgot to state that the repeated input varies in length up to 75 repeats so I have to paste 75 times for this methond to...

Hi, I am having a hard time to create a macro that will format the following in excel. I have 20000 inputs like this and vary in quantity of sector and MAIO. SECTOR MAIO TX00021 3 TX00021 2 TX00021 1 TX00021 0 TX00022 0 TX00022 2 TX00022 1 TX00023 2 TX00023 1...

Hi, I am having a hard time to create a macro that will format the following in excel. I have 20000 inputs like this. SECTOR MAIO TX00021 3 TX00021 2 TX00021 1 TX00021 0 TX00022 0 TX00022 2 TX00022 1 TX00023 2 TX00023 1 TX00023 0 TO the following. SECTOR...

Thank you

Hi, I am having a hard time to create a macro that will format the following in excel. I have 20000 inputs like this. SECTOR MAIO TX00021 3 TX00021 2 TX00021 1 TX00021 0 TX00022 0 TX00022 2 TX00022 1 TX00023 2 TX00023 1 TX00023 0 TO the following. SECTOR MAIO TX00021 3 2 1 0 TX00022 0 2 1...

Thank you once again PHV! Cheers, Raymond

Hi, I would like to select the nonblank cells in a row using the select command. This row contains several different items I need to select. How do I do that? Thank you in advance for your help! If you use excel then you can filter by nonblank cells but my file has too many data points to...

I did start one of the three projects that are similar. If you have an easier way I am all ears. I tried to create a macro but had no luck. Thanks! Cheers, Ray

Thank you so much Alex...this worked great! I really appreciate your help! Cheers, Ray

Hi 937, Thank you so much for taking the time to lend a hand. Yes this is Access. The idea behind this approach is excellent. I made the new table (RO351_RO409C_TABLE) with no problem. Now when I run the INSERT INTO Approach I get an error for the UNION command. If I drop the UNION...

HI EXPERT, I AM COMPLETING THE FOLLOWING COMMAND TO UNION 50 TABLES. THE DATA POINTS EXCEED 1.5 MILLION AFTER THE QUERY COMPLETES. I NEED TO GET THIS NEW DATA INTO A TABLE. ANY SUGGESTIONS? IF I TRY TO USE THE MAKE TABLE QUERY WITH THE UNION COMMAND IT STILL CHANGES BACK TO A UNION QUERY...

LOL...TOO BAD...I GUESS SOME TASKS WILL REQUIRE MANUAL WORK. I JUST HAVE TO ROLL UP MY SLEVE. THANK YOU FOR ALL YOUR HELP! RAY

R937....THANK YOU SO MUCH! IT WORKED PERFECTLY! YOU HAVE SAVED ME HOURS OF WORK! I TRULY APPRECIATE YOU! I BELIEVE I UNDERSTAND THE T AND M ADDED NICE APPROACH! CHEERS, RAY

Hi Expert, I am new at sql so go easy. : ) I have 2118 tables I need to update with a new column name of "SECTOR". In each new Sector column I need to fill down all the blanks with the same value. I can accomplish this separately by running the following commands one at a time. Is...

I AM A BEGINNER AT SQL. : ) IF THE X COLUMN HAS EQUAL DATA ENTRIES (10...10 EXAMPLE) AND THE Y COLUMN HAS EQUAL DATA ENTRIES (7...7 EXAMPLE) THEN I WOULD LIKE TO SELECT OUT THE LARGEST VALUE IN THE POWER COLUMN. I APPRECIATE YOUR HELP IN ADVANCE. ORIGINAL DATA ID X Y Power SECTOR 1 10 7 1...