cell (value)

Hi, first off I have gone through a number of posts that seem the same/similar to my request but the code will not work for me. I have 33 worksheets that I would like to be renamed by the value in A2 on each of those sheets. Ex. If Sheet3 has 12345 in A2, I would like that sheet named “12345”...

Hi everyone, I haven’t used excel in many years, so am more than a bit rusty. I have the following code to hide Column P if cell A1 contains the value “Text 1”. I am trying to add additional arguments so if A1 equals “Text 2”, it will hide Column T or if A1 equals “Text 3” it will hide Column C...

Hi All I'm a novice and looking for help to fix and resolve this. I thought it would be straight forward but I've been going around in circles to get it to work. I have sheet1 with check boxes (across columns) that informs sheet2 rows if they are checked (True) or un-checked (False). On sheet2...

I have a macro program where I save the name of the excel file with the values I get from certain cells. After this save, I have to say "Don't save" when asked if you want to save the sample file so that it is empty. Otherwise, it will come with the last values in the next opening. I want the...

Hi everyone, I have another question for everyone. This one is a bit complicated as several aspects of the code need fixing, and I am having a hard time doing so. If there are any helpful mind out there please have a look at he the problem below. What the VBA code should do: Each time text is...

I have a simple code to draft emails to different sub-recipients. This is a draft closeout email and I would like to include the dollar amount of the check they need to send back. The $$ check amounts are in column B, rows 2-43. Column A has the sub-recipient name. The code below works great...

In D7, When I increase value to 10 years or more. (Max is 40 yrs) it's automatically calculated in cells. But when I decrease value to 5, I see #Div/0 error in cells. How do I leave cell blank if cell has #DIV/0 value? I was trying with IFERROR function, but it doesn't work for me. see...

Good evening everyone, I'm looking for some code in vba that can find specified dates in a line, if the date is not the same I need to delete the 3 columns, I want to leave only dates in the line that correspond to date1 and date 2 as in the example before later

Hello, I am trying to make a cell change color if a range of cells on another worksheet are not empty ie cell on worksheet TEST1 that need to change color is E3 and have to check if a range of (lets say B2:C10 cells on Worksheet TEST2 are not empty. Can this be done with conditional...

I need to convert these cells that contain elapsed time in the format shown, to total minutes. The data in the cell is texts and numbers – there is a space on both sides of each number. The formula is a Value function with a nested Find – it’s not working for me, however...

Hello everyone, I would like to know how I could transfer cells from a worksheet to another, regarding the content of the cells. For instance, I have a first worksheet with cells that can contain "january" or, "february", or any months, and then I have a different worksheets for each month. I...

Need help with this. Looked through some similar posts but couldnt figure out how to adapt them. I got a value in cell B2 and a value in Cell B1 (a value between 0-10). They are values that are not allowed to be the same. If the value in B2 ends up to be the same as in cell B1 i need to call...

I am looking for a Excel Formula or function or VBA which is simple to understand. The actual data is Text and not a Numeric values The cell contents is to be divided into different sets with flower brackets and a comma separator. It should separate the data equally based on values in...

Dear Helpers, I am looking for VBA Solution which is very peculiar situation and crack my head to do it as Simple but could not do that. I request this could be done by a Macro and seeking your kind Help. - Overview Sheet 1 contains Column A and Column B - Column A has unique values to be...

I want to rename the worksheet based on cell value and delete the row where cell value 1.Worksheet 1 contains cell value A1 have fruits. Worksheet 1 will be renamed as fruits. In the worksheet fruits, Cell value row should get delete. Worksheet 2 contains cell value A1 have vegetables. Worksheet...

I am using the below code to update pivot another pivot table filter off a cell value that is chosen from a slicer on another sheet. It works but I have to go into the sheet and click on the cell range in A23 in order for it to update my other pivot tables. How to I get this to update pivot...

I found this great article (http://www.xl-central.com/list-the-files-in-a-folder-and-subfolders.html) and it is exactly what I needed. I’ve tweaked it to reflect my circumstances, my issue is, I’m trying to pull certain cell Information rather than all the information about the file itself...

I have a list of positions for employees that are in one cell that I needs to be in rows for each employee. Text to column doesn't work and neither does any sort of text formula like =left, =mid, etc. I have over 2500 employees and th <tbody> Active Status Emp ID Worker Hire Date Position ID...

Hi Excel Gurus, I'm looking for some post here regarding naming of files but can't find a suitable one. Basically I have these folders on my documents: Folder 1: Math Folder 2: Science Folder 3: History Inside the folders are different files like in the form of PDF, Excel, Text,jpg and Word...

So I got an excel file where within I got a list of Perks from a game. Now the problem is, when the sheet is Protected, the function to move a cell's value(the perk names in this case) under or above another perk in the list. Is there a way to enable the ability to use this feature somehow...