The discussions

Add incremental number based on conditions in excel

 Solved

Hello, I have a column that contains variables (for example; days of the week) and I am trying to add an incremental number in the second column bas...

3 replies Last reply on 20 Jan 2017 by
Mazzaropi

Outlook on multiple pc's

Hi, At the company I work for we have 2 PC's with Outlook sharing the same email address. I was wondering if there is a way to sync this so that for ...

1 reply Last reply on 19 Jan 2017 by
Ambucias

Date formate

Hello, how to change the date format to 19-july-09 19.7.2009 23.04.2008 26.07.2010 System Configuration: Windows / Chrome 55.0.2883.87

1 reply Last reply on 18 Jan 2017 by
Mazzaropi

Increment cell value according to cell colour

Hi Guys, Can anyone help with a problem I have. I need to increase a cell count by 1 or 0.5 based on the fill colour of the cell. I am using the foll...

4 replies Last reply on 18 Jan 2017 by
SecretS

Copy/paste row based on date

Greetings, I would like to automatically copy rows from one worksheet into another based on dates contained in each sheet. The rows containing the d...

1 reply Last reply on 17 Jan 2017 by
Shawn0

Forgot password

Hello, I have forgot gmail password System Configuration: Android / Chrome 43.0.2357.121

1 reply Last reply on 17 Jan 2017 by
xpcman

Copy row if specific word is in a column

I have an Excel File with a tab named Ledger. I want to copy a row if it contains a specific word (Pets, Entertainment, Dry Cleaning, etc) and add th...

1 reply Last reply on 16 Jan 2017 by
vcoolio

Google spreadsheet importrange - continuous formula

Hi, I am finding out solution on how I can make the Importrange formula continuous on the google spreadsheet. Currently, I am manually changing the ...

1 reply Last reply on 16 Jan 2017 by
ac3mark

Excel if statement with date condition

Hello, =IF(I20=0,0,IF(I20-M20-P20-'Rate '!$D$9

1 reply Last reply on 16 Jan 2017 by
ac3mark

Outlook can receive but not send with certain wifi networks

 Solved

Hello, I moved my PC to a new home and found that my Outlook can receive but not send when connected to the home's wifi. When I set up a hotspot on...

1 reply Last reply on 16 Jan 2017 by
ac3mark

Need a macro code

Hello, need a code to copy a column from one sheet to another based on the heading name

1 reply Last reply on 16 Jan 2017 by
ac3mark

How to show a specific column

sir i want show only a specific column on another sheet.for example i have A-Z column with data and i want to print only specific column means show da...

1 reply Last reply on 16 Jan 2017 by
vcoolio

Generate excel workbooks based on excel list

 Solved

Hello, I need to generate several hundred identical excel workbooks using a macro. I'd like to standardise the file names based on a list in Excel...

23 replies Last reply on 16 Jan 2017 by
rivera

If then

 Solved

Im trying to write a formula that returns a yes or no. I have to check if product is or isnt in warranty and need to know if a date is greater than o...

1 reply Last reply on 14 Jan 2017 by
Mazzaropi

Copy specific data from master sheet to multiple sheets.

Master sheet if first tab in workbook containing following: Case # Case Name Open date Atty Destroy Box # All rows in numerical orde...

17 replies Last reply on 13 Jan 2017 by
vcoolio

Excel formulas

HI, I NEED HELP WITH CREATING A FORMULA FOR A SPREAD SHEET. THE WORK BOOK HAS THREE SHEETS (UNITS, COMPONENTS, LOADLIST). IN THE UNITS SHEET SETS OF ...

3 replies Last reply on 10 Jan 2017 by
TMASON97550

Choosing a list item

I wish to populate $values in f14 by choosing a name in a drop down list located on the same worksheet Qty Unit Price Price YT004-Oscar Terr...

1 reply Last reply on 10 Jan 2017 by
ac3mark

Email with multiple attachments through vba

 Solved

Dear All, I need to send the multiple emails via Outlook through VBA. Column A Row 2 = Name of Person, Which must be Displayed on .Body Column B Ro...

9 replies Last reply on 10 Jan 2017 by
ac3mark

Can anyone pls help me

Hello, Private Sub CommandButton1_Click() Dim orange As Range, acell As Variant, bcell As Variant, ccell As Variant Dim ws As Worksheet Dim fin A...

1 reply Last reply on 10 Jan 2017 by
xpcman

Conditional format based on another cell containing text

Hello, i want to format a cell(make it red and negative value) if the cell next to it cantains one of the words: cancelled_by_guest. thanks stavro...

5 replies Last reply on 8 Jan 2017 by
Corrina66

Separating dates using if function

Hello, I'm trying to set up an IF function, I believe...I have a spreadsheet that lists dates back to 2013 as MM/DD/YYYY. I'm trying to create a for...

1 reply Last reply on 6 Jan 2017 by
Mazzaropi

Copy rows into sheets depending on a condition in one column

Hi, This thread has been really helpful. The first part of my code works and copies data that includes the term "EMAS" into the appropriate sheet. Ho...

1 reply Last reply on 5 Jan 2017 by
ac3mark

Automatic copy paste

I want to copy same highlighted cells from one sheet to another ,for example sheet 1 contains a column with different highlighted colours now i want t...

1 reply Last reply on 5 Jan 2017 by
ac3mark

If and is text or is not blank

 Solved

Hello, Can somebody help me with this formula...I want the excel to display a computation, if A2 is a Seller, and A2 has a value, then compute Price...

5 replies Last reply on 5 Jan 2017 by
ac3mark

Conditional formatting range of date cells based on another cell

 Solved

Hi There, There is lots of stuff to do with CF when using today's date but not a for specific date entered in a cell so I was hoping someone might be...

7 replies Last reply on 5 Jan 2017 by
cleaverr

I have a problem in match function

Hello, i want to ask u that if i have a text in one cell and i want to match more than one text from cell.for ex. cell contains(buy now this is a spa...

1 reply Last reply on 4 Jan 2017 by
ac3mark

Compare 2 excel documents and find the same data in both sheets

Hi I have 2 separate excel documents, 1 which had 2015/2016 data and the second which has 2014 data. What i need is to compare the 2 documents for m...

1 reply Last reply on 4 Jan 2017 by
xpcman

Wifi connected but no internet access

Hello, wifi conected but o inetrnet access Configuration: Windows 7 / Chrome 55.0.2883.87

1 reply Last reply on 4 Jan 2017 by
ac3mark

See which names are duplicates

Hi, I have a massive list of about 12,000 names and then another list of about 1000 names, formatted in different columns such as First Name | Las...

2 replies Last reply on 4 Jan 2017 by
yg_be

Convert number to word with currency

Hello, I wank to ask you guys about exel. I want to convert number to word with currency. Ex: 150.5 to One hundred USdollars and fifty cents. H...

1 reply Last reply on 4 Jan 2017 by
xpcman

Search for a keyword. add value from another cell.

 Solved

I'm looking for something that's very difficult to search for. I balance my checkbook in excel. Each row has a spot for Date/Comments/Withdrawl/Depos...

2 replies Last reply on 3 Jan 2017 by
adam73647

A if(istext) formula that needs a trimming, please help?

 Solved

Hello, Am really struggling with a IF(is text) formula, it works its just really large and I need to be able to trim it a bit as I need to replicate...

1 reply Last reply on 3 Jan 2017 by
TrowaD

Trying to drag the formula down it just copies the same

Hello, I am using the " proper" formula on my mac , but when trying to drag the formula down it just copies the same name ? Please help Confi...

1 reply Last reply on 3 Jan 2017 by
TrowaD

Conditional formatting

Hello, I conditionally formatted cell D4 that it's color changes from white to red when value in A1 is increased from 1 to 100. Now, can I make E4 a...

2 replies Last reply on 2 Jan 2017 by
textshiva

Worksheets into workbook

 Solved

Dear All, I need to copy each worksheet into workbooks and saved in the specific path except 04 worksheets named NMS, MS, Master and Missing. Further...

2 replies Last reply on 2 Jan 2017 by
Game Start Now

Text from two different cells to give value shown in certain cel

 Solved

Hello,, I'm trying to solve a problem I have with a list of values and text. I have a schedule of with names I will get two values in different cel...

4 replies Last reply on 2 Jan 2017 by
fgadim

Conditional formatting for word and date

 Solved

Hello, I am trying to make a cell turn a different color depending on if another cell has a word in it and if the date of a third cell is between tw...

3 replies Last reply on 1 Jan 2017 by
Mazzaropi

Auto copy and paste cell range to a separate sheet

 Solved

Hello, I am new to VBA/Macro with excel, but I want my code to automatically copy a range of cells in the same row that a change is made in a particu...

4 replies Last reply on 30 Dec 2016 by
bnoboa

Need to create multiple tabs based on data in table

 Solved

Good Afternoon, I'm trying to find a way to automate a few things to save some time: -Use the data in an input tab to create multiple tabs/documents...

6 replies Last reply on 29 Dec 2016 by
vcoolio

Return value in cell address

Hello, I'm having an issue returning the value cell A32. I have "A32" stored in cell H3 (it was a long drawn out process to isolate the "A32" that i...

1 reply Last reply on 28 Dec 2016 by
Mazzaropi

Compare data

Hello, I am working on ware house. We have different code for every material which was on system. Every month I need to take physical stock. I need ...

5 replies Last reply on 28 Dec 2016 by
Mazzaropi

Copy a range of cell x number of times

Hello, Friend my query is I want to copy value from range (E1:F1) Base on the value from G1 And paste on range from A1&B1. It should continue ...

1 reply Last reply on 27 Dec 2016 by
ac3mark

Transferring data from one sheet to another in excel

I followed the instructions for transferring data between Excel spreadsheets using the +Sheet(X)!((XY) formula. So glad I found your article! This w...

2 replies Last reply on 27 Dec 2016 by
vcoolio

Lettering malfunction (appearance)

there is a problem with my LT in lettering appearance!

1 reply Last reply on 27 Dec 2016 by
ac3mark

Popup reminder excel 2010

 Closed

I am completely new to VBA and do not really know how to manipulate a code. I was hoping someone would be willing to formulate the codes I need to i...

1 reply Last reply on 27 Dec 2016 by
vcoolio

Excel arrow keys are moving the entire spreadsheet

Hello, I'm working in Excel and my arrow keys are moving the entire spreadsheet and are not moving cell by cell up, down, right or left. I do no...

1 reply Last reply on 26 Dec 2016 by
santa

Find what is the number, that will make 2 cells abs equal

Hey guys, I will appreciate your help on this. I'm trading on CFD's and trying to build something that will help me calculate different scenarios. ...

3 replies Last reply on 25 Dec 2016 by
yg_be

Function in excel 2013

 Solved

Hello Dear All. who I can do this function in excel 2013 If A2=AB return value from A1 cell , if A2 = CD return from A3 cell value Configuration: W...

1 reply Last reply on 24 Dec 2016 by
yg_be

Creating different sheets in same workbook from master sheet

Hello, I have data in master sheet from Column A to Column L and about 17,000 rows. Column H contains the name of the sales persons. I have to cre...

1 reply Last reply on 22 Dec 2016 by
TrowaD

How to spell in euro

Hello, Dear sir / Madam I apologise for my latest message. I need your help concerning the formula to spell in figures that is euro 7000. Which for...

3 replies Last reply on 22 Dec 2016 by
TrowaD
Results 1551 - 1600 out of a total of 12,259