cell value

Hi I have a worksheet, “Required Data”, which has data in columns A:M. In column A I have a list of numbers which are derived from criteria in the worksheeet. Starting at cell A2 (A1 is a header) this presently runs 1, 2, 2, 2, 2, 3, 4, 4, 5 etc to 76. Each of these values have a...

I'm looking for a code that will copy certain columns and paste them into a new sheets that will be created based on cell value. for example lets say I have a huge list of data in cell A contain A 5555-01-120-121 5555-01-120-123 5555-02-120-255 5555-05-150-220 I would like to be...

I need a macro code which I can attach to a command button which will expand specific rows based on cell values. My sheet has a series of questions. or each question, there are 4 possible answers in a drop down menu in column A. If the answer has more than 4 characters in length, I need the...

Hello, I try to find a way to integrate A3 cell value into formula I got a folder full of invoices. File names are consecutive numbers starting with 180000.xlsx I want to extract for each file five differents cells. I'd like to manually write in colon A all file names without extension...

Hi, Im sure the title is like others, but I couldnt find a solution and couldnt think of another title. :0) This is my dilemma. I pull a value into a cell everyday by way of formula. I need to start collecting this number in a historical way, so I can identify the change patterns. Example...

Hello everyone! I want to build a macro or use a formula which allows me to search the value of (let's say)"search" cell K10 in a table spreadsheet. Jump to it, replace the background with color green, and jump to the cell next to it to the right (The value of K10 is in E171, fills the...

Hey guys, This is my first time posting, but I've definitely used the forums for help before. I need to expand and collapse columns based off of the numerical value in cell A1. And I need to use VBA to do so. Columns B:Z will expand and collapse. For ex. A1 = 0 then no columns show. A1=10 then...

I am trying to add a column to a score board, in which I can write custom comments which I want to appear as data labels on a graph (e.g next to June entry, "New manager starts" and such information I have found a way I believe in Excel 2013, but this doesn't work in 2010 as there is no option...

Good Day Dear Experts, I wish to use the text value in a cell to refer to a defined Name with a specific numerical value. Somehting like this: A1 = bwt Using Name Definition: bwt = 100. C1 = bwt* (another number). However, I want to use the cell value as a reference to the defined Name, i.e: C1...

Hi there, Hopefully the title is correctly describing what I need, but here I will elaborate. I will for example have the following worksheets: - Overview - Adam - John - Nick - Tess On the Overview sheet you will find the total of expenses per employee. The name in column A and the value in...

Hi, I have a sheet where it would be handy to have/not have frozen panes depending on how you're filling it out. Other people without excel experience will also be using this sheet, though. I have a cell (x) with data validation that has two options: Freeze Panes/Unfreeze Panes. I'd like to...

Hello, I am new here. I am trying to extract the cell value based on the cell color within a row range. I have looked around and haven't found anything that has worked for me. So I am trying to lookup between B2:Q2 the cells that are colored magenta and then return the cell value of the...

Hello! I am a teacher doing some data sheets for the upcoming school year. I am mainly self-taught and google solutions often, but can't get this to work. (I'm actually in Google Sheets so that admin can get live updates) Two different things, but wanting the same result: 1. I am doing a...

Hi All, I am trying to create a vba code that shows a userform if C14 + C15 > C13. I have tried the below but it does not work. If Range ("C14:C15").value > Range ("C13") then userform1.show

Hi team, I need a macro that fill or not fill color (grey) to the cells of two adjacent columns based on change in values of the second column. Please see the example below. Here both cells in a row are either filled or not filled(including the numbered one). <tbody> grey color 1 grey color...

Hi, I need to create a macro so that on the basis of the cell values the mail template must be created automatically and it should send mail automatically to the Distribution list. I have below data is excel: <tbody> <tbody> Complaint Type Student Name Roll No Level Teacher Principal...

Hello, In A1 I have 27. Is it possible to make 27 (the value in cell A1) cells in Row 2 from B2 to AA2 populated with a formula? Yes, I know how to do this in VBA, which will be my last resort, but is it possible without VBA? Thanks for any advice.

Hello All, I'm having a hard time wrapping my head around making this work, so hopefully someone with a clear head can help! I have 12 rows (U44:X55) Each row may not have data in it. When I run my macro, I need to copy the values of each row with data and add it to Log!B:E, at the end of...

Hello Hopefully someone will be able to help I have a worksheet and i need some <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color...

Hello all, I've been trying to look at similar code to try to put together what I want, and I'm still struggling to get it right, so I figured maybe somebody on here could help me out. I am trying to copy the values of multiple cells in a single row to a different sheet. The trick with...