help in need!!

Hello Everyone, Been using this site for a while but I can't find the answer to something I am looking for so I joined up and am hoping the community here can help me out. I am trying to find out if a customer has come into the store once they have placed a phone call to the company. I want...

Hi Experts , I dont know excel, but want to learn it asap specially for the current requirement i have . Requirement description (Excel 2007) : Code comaparison 1 workbook contains 3 sheets Comp , Jack , Jill named repectively , Jack has more code when compaired to Jill always :- Step 1 - we...

Hi Guys! I'm using the looping condition for extraction of years. And heres my code. I having a trouble when i run it. Suggestion or clarification please. Thankss! Sub GetLoans() Dim i As String Dim strYrFlag As String Range("E1").Select For i = 1 To 4876 Range("H1:J1") As Range If...

Trying to replace a macro for a conditional format. Can I use conditional formatting when I have a cell that is coloured - for eg. Cell BN30 is coloured in pink. IF that cell has a colour - I want that same colour to populate in cell BZ30. Is this possible? hope I explained well enough!! Thanks!

Hello All! I am looking for some assistance. I am looking to do an average for travel times based on a certain day of the week. For example I keep the number of travel days in range AI2:AI100. My days are indicated in column AM2:AM100...

Hi everyone, this is my first time posting to this forum and I'm still mostly a VBA noob, so bare with me. I created a userform where if a value from cell x is true then the label caption changes to value in cell z. While everything works fine, the label caption does not seem to appear in my...

:) Okay here goes!! I am new to this so if its an easy question I am really sorry!! :( I have to get this done for my boss as soon as possible!! Basically this is what I need as a formula. Plus it's over two sheets. If B1 (sheet 1) = "TEXT1" ,FIND the content I1 (sheet 1) within a1:a3000...

Basically I have data in columns I and J. When i drag the following formula (in column K) down, it checks if any two consecutive values in column J are equal to the top two (J3 and J4), and if so, it returns an answer. IF(AND($J$3=$J5,$J$4=$J6,),($I$3-$I5)+($I$4-$I6),0) My problem is that I...

After more Googling and experimenting then I care to discuss, I have run into a brick wall attempting to create a formula that can help me through my objective. I found a few threads with similar questions, but no answers, so am hopeful someone can provide direction. I am comparing several...

Hi guys, I've been working on the for 3 days now and cannot find a solution. what i need to achieve is the following I need a formula to count (Paid Weeks) how many cells for each row have a value higher than 0, between the Week Ranges (Week 1_13 etc) in the top row, based on the "Start week"...

<tbody> date email jan feb mar may jun jul aug sep oct nov dec 1/1 bob@gmail bob@gamail 2/2 eric@gmail eric@gmil 5/5/2014 helpme@excel.com helpme@excel.com </tbody> so what I'm working on is a sheet some what looks like this and Im...

I will admit, I am a bit of a noob when it comes to Excel anymore. I am trying to make an Excel Document that will hold a set of serial numbers in a hex format that will not repeat and can be referenced from outside excel to be printed onto labels for my company. I found a formula to create a 16...

Hi, I recorded a macro yesterday with about 10 steps, and was very pleased that I got it working for Sheet 1, I then entered data into sheet 2 in exactly the same format (all columns the same etc), and ran the Macro, without any errors, but the results it gave weren't accurate. I read a load of...

Hi guys, I have a spreadsheet exported from from Access, where I have a "False" or "True" cell values which relate to a Country name (If Destination is Costa Rica it's "True"). Now I'm trying to create a formula which would work, if Value is "True" in a range of cells (C4:AG4), then give a Name...

can this be done? i would like to set a work sheet up like this..... and when date is =TOday() then send out email to the email to the email that is scheduled to send though Gmail and the subject would be the subj. column be "d","g" ect.... the email waould be the emailed on the date that is in...

my front work sheet looks like this or something like it <tbody> today's work day 2/21/2014 total bills total people bar sales food sales 10211 1020 205.22 320.95 </tbody> and my work sheet is named "master" then i have 7 other sheets there names are monday,tues,wed,thur,fri,sat,sun...

Hi I have been trying to write a loop macro that will delete various rows in my spreadsheet. It is deleting the right rows but i can't get it to stop. I have tried including a counter, sticking a safeword at the bottom of column A and stopping at the first empty cell in column A, but it keeps...

hello im working on a userform in excel i would like to have a combobox that has the words "yes" and "no" then after the user picks "yes" then it would take the textbox187.value * 4 (it needs to times it by 4) then it puts the value in emptyrow, 26 ...... OR if the user picks "no" then it would...

So my problem is, i have a row of data, but due to cell merging and it's layout the cells i want are spaced 3 columns apart. I would like to be able to use the above cell's formula, but then add 3 onto the column number for the next cell. i.e. A1 formula = 'Worksheet1'!D2 I'd want A2 formula =...

Good day everyone. I'm newer into the excel formulas and I've run up against a scenario I just cant seem to beat. Ive got an excel file containing two separate workbooks; 'Fastener Calculator' and 'Fasteners'. 'Fastener Calculator' contains a series of look-ups and formulas to auto populate...