The discussions

Remainder from excel vba on desktop or task bar

Hello, sir,i am venkat, when i am running the your giving I am getting task as empty, can you send whats the reason. Is it possible to get remai...

1 reply Last reply on 26 Jul 2016 by
xpcman

Formating dates

Hello, I am trying to do a VLookup between to spread sheets and having a terrible time with the dates formatting correctly. Each spread sheet com...

1 reply Last reply on 26 Jul 2016 by
ac3mark

Fill color other fields based on start date and number of weeks

Hello, I would like to add the color to other fields based on the start date and number of weeks fields. Ex: In the attached xl, for instance, for ...

1 reply Last reply on 26 Jul 2016 by
umapathireddy

Two questions for cell color and sum

Hello, Please need help. Using excel 2013 If in column E "personal" or "business" displays then in that same row the cell in column J must change ...

1 reply Last reply on 26 Jul 2016 by
Mazzaropi

Outlook backup

 Solved

Hello, how to take outlook backup one machine to another machine Plz reply me Thanks Configuration: Windows Vista / Firefox 47.0

5 replies Last reply on 26 Jul 2016 by
amolsankpal

Outlook 2010 duplicate remover free

Please suggest or resend link to a free by safe Outlook 2010 Email Duplicate Remover. Thanks very much,

3 replies Last reply on 25 Jul 2016 by
captainashish

The email and password that you entered don't match.

hello, i am not able to recover my ms outlook account, as i have forgotten my password, my email id is correct, please help me out.

2 replies Last reply on 25 Jul 2016 by
captainashish

Quick pdf converter suite not working

I have just downloaded "Quick PDF Converter Suite", launched it, and tried to convert a large WORD document to PDF. The file is really large, it has 4...

1 reply Last reply on 23 Jul 2016 by
Ambucias

Popup window when the excel file is saved/updated

Hello, I have an Excel file which is used by multiple users (saved on the network drive). They can only open the file as read-only. I'm looking fo...

1 reply Last reply on 23 Jul 2016 by
Atmandu

Macro which should add a new worksheet

Hi guys, I have a question So I have a VBA Code which pretty much does everything it should. I can choose the CSV-Files, it deletes the columns th...

3 replies Last reply on 22 Jul 2016 by
ac3mark

If formula help

 Solved

Hello, I am needing a formula like this =IF(OR(B4="apple",B4="Banana",B4="carrot"),"yes","no") but if the cell B4 is blank. I need a blank " ". ...

2 replies Last reply on 22 Jul 2016 by
GF

Creating a payback calculator with rate change

 Solved

Hey, having a bit of trouble, appreciate any help. I am trying to create a payback calculator where you input: Initial Investment Rebates Annual...

7 replies Last reply on 22 Jul 2016 by
jojosabadar

Copy data from one sheet to another based on condition using vba

Hello, Please i need help on extracting some data in excel. The data looks like this A B C D 1 3.45 2.34 3.6...

5 replies Last reply on 22 Jul 2016 by
tunnde80

Macros help in excel

Hi, I was wondering if anyone could help me please? I would like to be able to use a macro to assist in me an excel spreadsheet. The task i...

1 reply Last reply on 21 Jul 2016 by
ac3mark

Notice to purge data

Hello - Any information or help will be appreciated. Is there a formula that can alert data entry personnel when a particular entry, needs to b...

1 reply Last reply on 21 Jul 2016 by
ac3mark

Conditional formatting based on data in another cell

 Solved

Hello, I would appreciate any help you can offer on the following scenario. I tried conditional formatting, however, the columns in Row E either all...

4 replies Last reply on 21 Jul 2016 by
ac3mark

Please i need and answer about this

Hello, I want to translate this number 1647984643 into word or sentence i hope you can lightend me Configuration: Windows 7 / Chrome 51.0.2704....

1 reply Last reply on 21 Jul 2016 by
xpcman

Excel has file big size

 Solved

Hello, Hello, I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns. Each day we create a copy of th...

4 replies Last reply on 21 Jul 2016 by
RossHutton

Copy a cell in the same row as a matched cell on a sheet2

Hey, Let me try and explain this better. I need to match A2 with Sheet2!A:A, but the value I need is a cell on Sheet2 in the same row as the mat...

3 replies Last reply on 21 Jul 2016 by
Mazzaropi

Move rows of spreadsheet to second spreadsheet

Good Morning- I am keeping a spreadsheet of my projects. I want to keep the information for tracking and statistics later. Is there a way to move...

1 reply Last reply on 21 Jul 2016 by
vcoolio

Macro to copy cells and save multiple entries

Hello, I am looking to create a macro (never done this before). Here is what I want it to do. 1) I have a master store name excel file (for exampl...

3 replies Last reply on 20 Jul 2016 by
ac3mark

Conditional formating: formula cell text change color

 Solved

Hello, How do I get Text in a Cell to Change from Black to White, based on data? The cell already contains a formula to extract data from elsew...

3 replies Last reply on 20 Jul 2016 by
ac3mark

Colour in spreadsheets that are formulated

Hello, I would like to know how to do the following on excel Same sheet with the amount of calls taken in number form goes into a cell then the ...

4 replies Last reply on 20 Jul 2016 by
ac3mark

How to highlight the extra data in column

Hello, I want to get the extra data in a column when compared to other column. For Ex: If ColumnA has following data 1 2 2 3 5 & column B...

2 replies Last reply on 20 Jul 2016 by
Sumit

Transfer between excel worksheets

Hello, I would like to be able to transfer an entire row of attendance of students when it hits zero for attendance to another sheet or at the bot...

1 reply Last reply on 20 Jul 2016 by
vcoolio

Automatically transferring rows of data between sheets

Hello, I am creating an excel spreadsheet that will be used to keep track of my organization's board member and supporter attendance at events. I ...

3 replies Last reply on 18 Jul 2016 by
vcoolio

Date format *dd/mm/yyyy and dd/mm/yyyy

LS, Hello, Please help me with the following question; What is the difference between the format dd/mm/yyyy and *dd/mm/yyyy when uploading dates an...

1 reply Last reply on 18 Jul 2016 by
ac3mark

Conditional formatting when a cell says "no"

 Solved

Hello, I need your expertise in conditional formatting. I have a worksheet that where i have hidden a column ("J") with just Yes and No on it. W...

3 replies Last reply on 18 Jul 2016 by
Mazzaropi

If a cell has a certain value after certain date, color the row

 Solved

Hello, I'm working with deadlines, and projects need to progress from one stage to another by specific dates. I have 3 deadlines: A: Create BR...

4 replies Last reply on 18 Jul 2016 by
ManxMaggie

Matching 2 values from one spreadsheet

 Solved

Hello, I have 2 spreadsheets.. first has 3 columns id, date, time value second volume with id header across of date would like to populat...

3 replies Last reply on 16 Jul 2016 by
sargiesan59

Change text in cell if other cells have any values

 Solved

Hello, I am working on a spreadsheet where I have 5 important columns. Column B is the "Completed" category. Columns C, D, E & F will all contain ...

5 replies Last reply on 15 Jul 2016 by
C.J. Leffel

How to count how many times a number appears in a spreadsheet?

 Solved

Hey~ I need to count the number of times a number appears in a spreadsheet. For example, how many times the number 1 appears in an entire spreadshe...

4 replies Last reply on 15 Jul 2016 by
kimipapineau

Conditional formatting from other spreadsheet

Hello, Every day I update my excel spreadsheet based on customer demand. My boss uses a separate spreadsheet that pulls from mine. He wants to be ...

1 reply Last reply on 15 Jul 2016 by
ac3mark

Automatically copy data from one sheet to another

I have read numerous articles about this and none have really solved my issue. I decided to post my own specific question. I have an excel workboo...

1 reply Last reply on 15 Jul 2016 by
vcoolio

Removing false statement

Hello, I would like to remove a FALSE statement, want it to show nothing. My formula is as follow =IF(A23=1,G23,IF(A23=2,G23,IF(A23=3,G23,IF(A23...

1 reply Last reply on 14 Jul 2016 by
Mazzaropi

Excel formula

 Solved

Hello, I am having trouble getting the right formula for: Column O is equal to column N if Column C contains the text "Mastercard." Nothing I'...

1 reply Last reply on 14 Jul 2016 by
ac3mark

Send email when a cell changed in excel

Hello, hi guys, straight off, im stupid, extremely stupid so if you can help me please keep it simple as im barely technical at all :) anyways, im...

4 replies Last reply on 14 Jul 2016 by
Haval

Recover corrupted pdf files

 Solved

Hello, I'm trying to recover a folder with some critical data that was damaged or corrupted, likely by a virus. It’s a 10GB folder that contains P...

1 reply Last reply on 13 Jul 2016 by
Ambucias

Creating multiple lists from one master data table

Hello, I am trying to create a master data tab where expenses will get coded. I need each subsequent tab to be for a specific account and that ta...

2 replies Last reply on 13 Jul 2016 by
vcoolio

How do i extract specific data from a cell in excel?

Hello, what function would I use to extract just the city name from the cells below?...thanks! 6211 E Holmes Rd ,, ,Memphis, TN 381418310, U.S.A. ...

5 replies Last reply on 12 Jul 2016 by
ac3mark

Changed pdf to word, now all documents are gibberish

Hello, I changed one of my documents with "Open with" from PDF to word. I has now changed all my word documents to gibberish. How do I get it to ...

1 reply Last reply on 12 Jul 2016 by
xpcman

Change color of text or cell if the value entered is same

Hi! Can someone please share me how to change font or cell color if a value entered in a cell is already selected before. Ex. I wanted the font or...

1 reply Last reply on 12 Jul 2016 by
Mazzaropi

Ms word 2007 files converted in to ms word 2003

Plz help me. M research scholar I have created my file in ms word 2007 but after few hours I have opened then I have seen my all files have converted ...

1 reply Last reply on 12 Jul 2016 by
Ambucias

Comparing the two names respective of upper & lowercases letters

 Solved

Hello, here am trying to know something about the compare of 2 names in excel below is my format Http:CCM_net_C2E http:cCM_Net_c2E i have ...

7 replies Last reply on 11 Jul 2016 by
ac3mark

Macro for inserting multiple rows between data

Hello, I need a macro that will insert 45 new blank rows between each existing row that I have now. can someone help me with this? Also, I have li...

1 reply Last reply on 11 Jul 2016 by
TrowaD

Count if it is monday?

Hey all; I could not manage to work this out after 1 day research and try my chance here. I have dates on column A and numbers (both positive,negat...

1 reply Last reply on 11 Jul 2016 by
tunnde80

Transferring data by row onto new tab unpaid and paid sales

Hi I am new to this forum. I have an excel spreadsheet which looks like this: Date Description Invoice Destination Amount Status ...

1 reply Last reply on 11 Jul 2016 by
vcoolio

Using if statement to add 1 to total

Hello, I am trying to get a formula to add + 1 to a total cell based on the word typed. Example : If I type the word Duty in cells B3:B18 then ad...

3 replies Last reply on 9 Jul 2016 by
jimbo

Totaling amount from 1st tab depending on another column states

Hello, I have 2 worksheet, 1st worksheet shows 2 columns A1 ($0.00) and A2 (names). 2nd worksheet I want it to calculate if the name column A2 sta...

1 reply Last reply on 9 Jul 2016 by
Mazzaropi

How to populate data to another tab

Hey there, If anyone could please spare a moment to help me with this, it would be much appreciated, more than you will know ! What I want to d...

4 replies Last reply on 8 Jul 2016 by
RicSan
Results 1951 - 2000 out of a total of 12,269