replace cell value

Hello Excel/VBA People, I am looking for a vba code that will replace the value of a cell (with yellow color) to zero for those columns having Dates as the Header column only. Example: In a certain excel file there are tabs/sheets that contain the column names Supplier name, Amount, and dates...

Hello All, I have trouble running the following macro (See the attached image). Sub Translation() Dim fndList As Variant Dim rplcList As Variant Dim x As Long fndList = Array("Pound Sterling", "Outgoing amount ATM/Dispenser", "Banknote") rplcList = Array("Libra Esterlina", "Salida dotación...

Hello Gurus, I have a Binary excel file and want to update a particular column using the unique identifier from an xlsx or xls (get open file) . Do you think it is feasible? Example Binary Sheet: Number Name Country Note 001 Mark Finland Checked 002 Sean United States Example...

Hello, I have a spreadsheet where I want to replace the contents of a cell with the contents of another cell based on a table. I've written a VBA code that'll work if the replacement content is less than 255 characters, but gives me an error is the replacement text is longer than that. Can...

Hello, Actually I have to update a master google excel sheet daily with numeric values. There are thousands of names across which value to be updated daily by datewise (new date in new column). Daily I get names with num values which eventually to be entered in their respective cell of a new...

I am trying to get the code to search for the replacement criteria and then loop a replacement sub until there are no more replacement criteria. The main reason I am doing it like this is the active cell reference is important for what the criteria is being replaced with. The main issue is my...

Hi there, I want to fill in the blank cells in between two designated text strings. I column L, I have either blank cells or the words "DNIS:ARC" or "DNIS". I need the replace the only the blank cells between "DNIS:ARC" and "DNIS" with the word "ARC" all the way through the data set in column...

I have a spreadsheet where users can paste employee census information with varying formats. Is there a formula that would locate any stand alone letter (A-Z) within a cell and replace it with ""? Here is how the names can be formatted: <tbody> Washington,Richard Y (Last,First)...

Hi Guys, Can you possibly help me on this? I'm trying to create a macro wherein in Column A, I need to look for these words Football, Basketball & Tennis and will replace as Sports. In column A as well, I need to look for Math and Science and replace as Subject. I have below codes for the...

Good morning all, I have a quick question, not actually a problem. I have a very simple piece of code that will replace all the spaces in a selection with underscores. I mainly use it to clean up header rows. My question is, based on the code below, is there a way that this can be done...

Hi, I had hoped to attach the small troublesome excel file (size: A1:F374) but just discovered I do not have permission. Not sure how to demo what the problem is without attaching the file - can I be given permission please? The file has numerous zeros (0). I want to use Replace to replace all...

Hi All, I want to have a button that will run a macro to change any cell in a range that has the value of "-" to "md" (for 'Missing Data', as this is what the program will detect). How can I write the code for this? For reference, the column that I would like the changes to be made in is...

Hello! So I am facing a problem with an excel problematic for my work I can't figure out on my own, even after researching a lot online (or when I try them they don't work). I have attacher the file if it helps: https://we.tl/7hopolpjUV. So I would like to replace à value in a cell by a...

Hello, I am working with a spreadsheet with numerous validated lists from named ranges; I'm good at the beyond-data-entry functions of Excel, but a novice a VBA. I've googled a ton, and I think I have the gist of how the code I'm looking for should work, but no idea on writing it or defining...

So I have to take symbols for electronic components (like CK and CK#), and I have to come up with a program that formats them in Latex. I typed in the original symbols to be formatted in separate columns in Excel. Then I created a column next to each column of the original symbols. What I am...

I have a list of asset numbers that are on sheet 1, column A. Then on Sheet 2, column A I have to enter the asset number (not in the same order listed in sheet 1, column a) along with the member its assigned to. However sometimes the asset numbers change... What I would like to have excel do is...

I've spent a good 1/2 day searching for the topic, but it either does not exist or I am not explaining it correctly. I hope someone can help. I have a worksheet that tracks everyone's itinerary. If he/she is on "VC" (Vacation) or "SK" (Sick), the person is required to use specific codes...

Hi All, I am new here and was hoping for some help I have some VB code that changes details across a who workbook I only want it to run on sheet1, can someone help me redesign to get this working. I have taken this list of names out of the fndlst as they are sensitive. Sub test() Dim sht As...

Hello, I very new in Excel. I need to change my columns data with my original data. ColumnA ColumnB ColumnC green tom table blue james chair blue tom wall blue marie table I need change this values with...

I have a worksheet with a data validation dropdown list which the users will select from. The values contained in the dropdown list are the short (i.e. "user-friendly") descriptions of the values in a larger list. What I'd like to do is, when the user has selected the value they want from the...