The discussions

Search for input criteria, return designated cells.

 Solved

Hey all, I am trying to write a VBA command/macro that essentially takes a criteria input from the destination worksheet, searches and matches the ...

12 replies Last reply on 19 Aug 2017 by
vcoolio

Copying dates to another worksheet.

 Solved

Hello, I found this script from vcoolio, thanks for that! Sub Advise() Dim x As Integer Dim lRow As LonglRow = Range("E" & Rows.Count...

12 replies Last reply on 17 Aug 2017 by
vcoolio

Excel formula - add days to date based on drop down selection

 Solved

I want to add days to a date based on options selected from a drop down list. For example, if cell C5 reflects "New Hire" or "Post New Hire", I want ...

3 replies Last reply on 17 Aug 2017 by
Mazzaropi

How to auto-populate values from certain cells into a new sheet

 Solved

Hello guys, Hope everyones doing okay. I've been working on a billing sheet for a company with multiple product codes and rates etc to be pulled f...

18 replies Last reply on 12 Aug 2017 by
vcoolio

Highlight only one column which has greater value

 Solved

Hello, i am inputting numbers in column A , B , C and D so i wanna highlight only one column which has greater value from others. is there any pos...

3 replies Last reply on 11 Aug 2017 by
Mazzaropi

True or false value based on 3 difference cells' criteria

 Solved

Hello, I need a True or False (or Y/N) return if for example: A1>=30 AND B1>=80 AND C1>=80 but I have been unable to get IFS to work with t...

1 reply Last reply on 26 Jul 2017 by
ac3mark

Repeating a simple macro loop up to 1,500 times

 Solved

Hi All, Office 2013 user here with a first time macro question... I have a large XLSM file with simple text labels in Column A. There are 1,500 ...

5 replies Last reply on 20 Jul 2017 by
TrowaD

Excel external data connection not working properly

 Solved

Hello, I made a connection between two workbooks where there is a master workbook and non-master workbook that uses the master as an external sourc...

1 reply Last reply on 19 Jul 2017 by
kvil

Create a date from 3 different cells

 Solved

Hello, In excel I have date spread across 3 cells; 1 with the day (A1), 1 with the month (A2) and 1 with the year (A3). I want to put these 3 numb...

11 replies Last reply on 13 Jul 2017 by
Udeni

Macro to insert multiple rows between existin

 Solved

Hello, I am trying to create a macro that will insert 2 blank rows into an existing spreadsheet after every 2 entries. The amount of rows needed wil...

7 replies Last reply on 11 Jul 2017 by
Pedro

Copy and past the not equal value using macro

 Solved

Hi guys!! Please help me with this. I'm trying to compare two sheets in excel. If it is NOT a match then copy the entire row into a new third sheet. ...

3 replies Last reply on 10 Jul 2017 by
Sam

Script is really slow and sometimes crashes

 Solved

Hi, My script is really slow and sometimes crashes when there's too many rows. Can someone help me figure out how to make it faster? Dim b A...

5 replies Last reply on 7 Jul 2017 by
vcoolio

Need help with script or formula

 Solved

Column A shows "Date" while column B shows "Passenger #" I want to Copy and paste the Passenger # to Column C "Total Passenger" The problem is I o...

5 replies Last reply on 5 Jul 2017 by
josh07429

Matching cells but exclude blanks

 Solved

Hello, I am trying an "IF" formula to see if A1 matches B1 and if so I want to return C1 but if the two cell are blank its working I want to exclud...

11 replies Last reply on 4 Jul 2017 by
Hira

Rounding up time

 Solved

Hi, Im having a problem on rounding up time, I've use =mround(A1,"1:00") it works fine on dates and time like this "5/2/2017 7:01 AM" but whe...

1 reply Last reply on 30 Jun 2017 by
nickname missing

Vba compile error: do without loop

 Solved

Hello, So I modfied this code from an CCM post. I have Do I have an End IF Why am I getting the Error? This query is copying data from s...

1 reply Last reply on 28 Jun 2017 by
ac3mark

Problem with script in excel

 Solved

Hello, I have a problem with my script. What I want is IF the value in column J is equals to "0" then I want the column H to be blank. Ex. J1 ...

6 replies Last reply on 26 Jun 2017 by
josh07429

Cell colour containing specific info

 Solved

Hi, I am currently using Microsoft Office Excel 2016. I am busy doing a spread sheet for work and need to know how to change a cell colour if a differ...

6 replies Last reply on 23 Jun 2017 by
JohannGC

Validate copied data in excel

 Solved

Hi, I have a below scenario one row is copied and pasted, this pasted row needs data validation such that total of each cell shouldn't exceed the r...

2 replies Last reply on 22 Jun 2017 by
chint99

Multiple worksheet data input

 Solved

hi TrowaD, I am an on the job trainee at a company, i was ask to encode data from our furnace but its too much time consuming for me to encode all...

2 replies Last reply on 20 Jun 2017 by
vintacu

Conditional format based on text in same row

 Solved

Hi all, New to this forum. I'm running Excel 2016 on Win7 -- my spreadsheet has results of inspections in columns E, G, and J. The possible valu...

3 replies Last reply on 20 Jun 2017 by
Mazzaropi

How to manage hours and rounding in excel

 Solved

Hello, I need to know how to add a function to a cell in which I have figured a days hours worked with a lunch. The current formula is =(C7-B7)+(E...

2 replies Last reply on 19 Jun 2017 by
Theresa

Formula

 Solved

I am trying to find a formula that will add up all blank fields in a range of cells. For example, if cell 1,2,3 have data and 4,5 are blank I want the...

7 replies Last reply on 15 Jun 2017 by
x

Convert date of birth in word

 Solved

Hello, pls tell me formula for convert date of birth in word in excel

1 reply Last reply on 10 Jun 2017 by
Ambucias

Comparing values of two excel sheets

 Solved

Hello, I have two excel sheets with IP Codes. I need to find which IP Codes are not available in Sheet#1 and highlight them, i.e. Sheet#1 Column ...

2 replies Last reply on 10 Jun 2017 by
dh

Copy/paste a range 'n' times.

 Solved

Hello, I have a highlighted portion and I want to copy and paste it 200 times. Is there a code or formula to do this automatically? Or must I hit ...

3 replies Last reply on 9 Jun 2017 by
vcoolio

Conditional format

 Solved

Hello, I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell $AI2 has

3 replies Last reply on 6 Jun 2017 by
Azion

Vlook up

 Solved

Hello, I have 2 columns A & B in sheet1 and i want to Return Yes if either A or B value mactches with Coulmn A in Sheet 2. Please help

2 replies Last reply on 6 Jun 2017 by
Sri

Spreadsheets viewing formulas

 Solved

How do I view hidden formulas on spreadsheet

3 replies Last reply on 29 May 2017 by
TrowaD

Vba send email via outlook using loop; no response when run

 Solved

Hello, the above code is not functional as described. Is there a way to check what is wrong? the screen does not show anything upon clicking the r...

9 replies Last reply on 29 May 2017 by
TrowaD

Vba code in my command button doesn't work

 Solved

Hello, I have a sample table below, I was trying different VBA code in my command button but doesn't work well. Column G is already programmed t...

1 reply Last reply on 28 May 2017 by
vcoolio

Vba column

 Solved/Closed

Need to know how to added data in column field if column is not empty then go to another column and paste data

Last reply on 28 May 2017 by
Ambucias

Format font colour to change

 Solved

Hello, Using Excel, I have a range of cells K2-K15 that contain numeric values and I want the font color to change in any of those cells that are g...

2 replies Last reply on 26 May 2017 by
jandc111

Copy rows to new sheets if condition is met

 Solved

Hello , please help... I'm trying to copy rows from master table sheet to different sheets based on the value of the cell in the column: The colum...

7 replies Last reply on 24 May 2017 by
vcoolio

How to "teach" excel to learn names?

 Solved

Greetings to all, I'm desperate to find a solution to my tedious work. So, each day i will go through hundreds of records and change product names...

2 replies Last reply on 23 May 2017 by
HoomanCz

Search for a value in column and copy to different sheet

 Solved

Hi I want to search for an employee ID in column EID and copy the whole record into another worksheet within the same workbook if the EID is found...

3 replies Last reply on 23 May 2017 by
raghuprabhu

If then using multiple cells and words

 Solved

Hello, D3,D4,D5 that all need to say either 'Compliant' or 'N/A', for result in E3 to say "yes", else "No". Please help. System Configurati...

4 replies Last reply on 22 May 2017 by
Matt Louisiana

Need help with conditional formatting

 Solved

Good morning, I am trying to change the color of a cell(A) if another cell (D) contains text. The text will contain both a date and other text. Can...

8 replies Last reply on 22 May 2017 by
x

How to copy data from sheet1 to sheet2

 Solved

Hello, I have a worksheet, there are 2 sheets. What I need is to do is copy all the column and rows from sheet1 and paste it to sheet2. The copy butt...

10 replies Last reply on 19 May 2017 by
nisa

Excel formula for percentage

 Solved/Closed

Hello, I am trying to get a formula to calculate the percentage of cell O3 from cell N2. The format is what percentage is my expense (O3) from my ...

Last reply on 16 May 2017 by
tanu

A macro to create new, copy and name worksheets based on a list

 Solved

Greetings, I need a macro that can automatically create new, copy (existing worksheet say '100') and rename the new worksheets, based on a list that ...

35 replies Last reply on 11 May 2017 by
vcoolio

Need help creating an if then scenario

 Solved

Hello, I am looking for some help with a problem. I have a big list of items within Excel and I am wanting to consolidate the big list of items do...

12 replies Last reply on 10 May 2017 by
vcoolio

A macro to copy/paste a cell and other cells in the same row

 Solved

I have two wooksheets in a workbook. I need that a value of each cell in a range C3:C52 in sheet 2002 is being searched for in the range B2:B101 of th...

3 replies Last reply on 9 May 2017 by
TrowaD

Trying to simplify data in excel through vbscript

 Solved

Please help desperate novice: In Excel, I have 5 columns: Bob Dad 12 13 blank Sue Mum 34 56 22 Gill Daughter 23 67 34 Jock Son 24 55 blank ...

3 replies Last reply on 8 May 2017 by
TrowaD

How do i use conditional formatting in excel

 Solved

Hello, i am new on this excel things but, i need it for work.. so, here it goes. is it possible if it like this ? example : A B C if A conta...

3 replies Last reply on 6 May 2017 by
Mazzaropi

Excel vba - find and expand matching cell entries

 Solved

Hello I have a list of 10 digit numbers in each row of a column range. Some of the numbers start with 3 zeros (000) which results in Excel ignoring...

1 reply Last reply on 2 May 2017 by
x

How to populate information on multiple sheets at once

 Solved

Hi all, I hope someone can help me figure this out. I have been imputing information on multiple sheets in an excel workbook for quite a while now ...

14 replies Last reply on 2 May 2017 by
TrowaD

Shortcut to edit a cell without using f2 key

 Solved

Hello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit F2, bu...

7 replies Last reply on 25 Apr 2017 by
BenFromSingapore

Conditional format if hyperlink

 Solved

Hello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has font co...

12 replies Last reply on 24 Apr 2017 by
ac3mark

Compare the words in 2 columns in excel

 Solved

I gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new colu...

11 replies Last reply on 24 Apr 2017 by
TrowaD
Results 301 - 350 out of a total of 1,690