cell range

Hi. I have a macro that looks at a cell for a name, references another sheet and gets the email that corresponds to the name, and sends an email. I hopped into VBA and thought I entered the correct data to expand my vLookup. The original expression is: Recipient =...

I am trying to create a summary page for a large data collection workbook. I am running into an issue however when trying to drag my formula down through the column. The formula is set to show as Done if there is a value in cells F4:F15 using =IF(COUNTBLANK(Sheet1!F4:F15)=12, "","Done") I want...

I am using =Datedif() to determine time frame of some stock. It's currently set into a pivot table as I only need some of the data from the main workbook, which is different to the workbook I am using. Because not each row has a date reference, there are a number of them that show a #VALUE...

So I am having a pretty hard time getting this working... :confused: AIM: Click "UpdateSheets", "ServerTemplate" is copied and the value in each cell in E column is used as the Sheet Name, once done, hyperlink the cell in column E to the respective sheet. ISSUE: The hyperlink is only linking to...

I need to compare to columns using index/match but round each value before comparison. Could create a dummy column but that is very cumbersome and ugly. is there a way to perform an operation on each cell value before the comparison =match(round(a6,1),Sheet!A6:A1000) I need...

Below Mentioned Module Sends Replyall to all mails available in outlook. I need to send replyall only mail Subject matches the subject in the cell value can any one help me out... Sub ReplyMail() Dim olApp As Outlook.Application Dim olNs As Namespace Dim Fldr As MAPIFolder Dim olMail As...

Hello all, I feel like there should be a way to successfully do this, but I can't quite wrap my head around doing it properly. (I know I can do a very very long version to achieve what I want, but I'm trying to get better at writing more efficient code.) If Sheets("Period" & P).Range("R" & R...

Hi experts, Just wondering how can I do to find a value inserted into a specific cell within a table and return the row number. For example, I have a table range A1:T2000 and I want to find within this table without specifying a column a value that I type in U2, so what I need is to check all...

I have the following table sorted by Column A, X = my input value. I want value Y =corresponding value in B to: - Return Y value in column B (rounded up to the next row value). - If value is less than the minimum return the minimum - If value is more than the max return an error message. i.e...

Ok, here's my problem: Sheet A: In A4:A I've got dates (actually in an ascending order) In H4:H I've got numbers (that are not supposed to sum, only LAST number is always significant) In all other columns I've got numbers to sum up. Sheet B: (Sums up data in months) In A4:A I've got MONTHS...

Hi there, I am using excel 2013 and I am wondering if there is a way to make a dot (location of a building) appear on a picture of a map I inserted into excel if I type a specific number in a cell range. For example: Range A1:A120 would be the numbers for the buildings (A1:1234, A2:1235...

First off, sorry to ask about runtime error 1004, but I am not that familiar with VBA and I cannot find a solution anywhere that I can make sense of. The problem I get is: Run-Time error '1004' : Application-defined or object-defined error Here is my code: Sub DateInsertion() ' '...