I am trying to select the most current data for a particular month from a spreadsheet and copy that number to another cell. I run a query weekly that updates the spreadsheet and places a date updated in a column. I need to find the most recent number from column P and copy it into another cell. The following week I need it to change to that weeks number. Thanks!!
P M C F 8 Updated
245 346 35 18 0 6/1/2011
223 368...
John Gresko
Last Activity: Jul 25 '11, 11:46 PM
Joined: Jun 7 '11
Location:
-
Most recent data selection
-
Rodney, I used the 2nd option and it worked great. Thanks!! -
How to set range for multiple items?
I am struggling to shorten the amount of code I am using. I currently have 10 different subs that look for a specific letter in column L and replace it with the letter "P" (see code below). I want to search for letters "A-B, D-E, G-L, N-Z" in column "L" and replace it with the letter "P". Is this possible or do I just cut and paste numerous times for different sheets?
...Code:Sub Change_ReturnTypeN()
-
This worked great!!
Thanks!!
I have another problem when I use the same code, but to search for a part number beginning with 700 and return M. Using the code below it finds every part number with 700 anywhere in the number. I only want part numbers that begin with 700. How do I specify a specific text or number? Thanks!!
...Code:Sub Change_ReturnType700() 'Changes 700 part numbers to return type M' i
Leave a comment:
-
Thanks Rodney! Inserting this line worked on the first occurance of "UPGRADE", but did not go past the first occurance. After returning "M" to column L it went into an endless loop. What did I do wrong? How do I make it continue throughout my entire spreadsheet of approximately 800 rows?Leave a comment:
-
I am a vba rookie. Could you show me where this would go in the code I already have or do I need something totally different? Thanks!!Leave a comment:
-
How to search string for specific word and return "M" in next column
I have a spreadsheet with 800+ rows and 18 columns. I am trying to write vba code to search column K for the word "UPGRADE" and return "M" in column L if found. Need to search all rows and if not found do nothing. The code below will only work if UPGRADE is the only word in the cell, but it rarely is. Thanks!!
...Code:Sub Change_ReturnTypeM() 'Changes return type Blank or U to M' i = 2 Sheets("Listed").Select
No activity results to display
Leave a comment: