based on cell value

Hi, this is a very simple request... i know there must be another way around, but this is what i have based on my limited knowledge... please shorten this formula for me...

I need a macro that inserts a row above each cell in column B that partially contains 2 e.g. A2, B2, C2 - W2. Many thanks in advance!

Hi, I am currently working on a sheet, where I wish to achieve the following: Whenever one or multiple items with status (Column E) In Progress and Awaiting info (ONLY!), has been in the sheet for exactly 7 or 14 days, I receive an e-mail notification which lists the items in the e-mail body...

Dear Mr. Excel, After days of searching for answers to no avail, I thought I'd reach out to you. Any help will be greatly appreciated! I am trying to accomplish the following: I have a column (from Cell C54 to C105) that displays the file names (they are results of formulas). Some of them...

Hello, I'm using this BruceWayne code that works fine in the worksheet whith the command button. But, I want the macro to run in all sheets except were the command button is? Sub RowsToHide() Dim myVal As String Dim mainRow As Long, tweakRow As Long Dim hideRange As Range, showRange As Range...

Long story short I am always reading about VBA and trying to implement pasted code I find on this site...all with no success. Can someone make an idiot proof set of instructions for how to do the following? I have a workbook: Sheet 1+2 are for user data input Sheet 3 is user notes Sheet 4...

Hello, Does anyone now how I can sum rows based on columns values using vba? For example, Name Salary Felipe 800 Ricardo 1000 Felipe 800 It would become, Name Salary Felipe 1600 Ricardo 1000

Dear Experts, I found a macro from your forum which copies the entire row based on a cell value ("y") -Courtesy Mr. jindon MrExcel MVP. If we type "y" in column D, the entire row is copied & pasted to sheet 2. The code is as follows. The only point for clarification is how will the code change...

Hi, I need help figuring out a code that will do the following: I am trying to copy a range of cells from sheet 2 to sheet 1 as many times as the number in cell A1 (in Sheet 2) indicates (the number in A1 will change on its own). I would like to copy range of cells in sheet 2 starting in from...

Hi Guys, i know theré's a very similar post on this subject, but it is intended for use when you knwo the other workbook name. In my case, the workbook name will depend on date, client name and product. To cover this i have used some simple formulas using "concatenate" and "&" functions to get...

Hello everyone. I want cells to be automatically be locked, based on a value of another cell. If there is no attendance: Lock cells 'test score, result, re-test score and re-test result'. If there is attendance: Unlock cells 'test score, result, re-test score and re-test result'. BUT: If the...

(Spreadsheet can be downloaded at the bottom of this post, with all notes included). Hello peoples! I've always enjoyed trying to crack formulas myself and used this forum many times to help me, thank you. This one's got me stumped and I would really appreciate a nod in the right direction...

Hi all I have a cell built into my spreadsheet that serves as an error check (i.e. returns the word 'ERROR' if certain criteria are fulfilled on the spreadsheet). I'm trying to write something into a Macro that will check this cell and not allow it to run if it states ERROR, returning a dialog...