The discussions

Excel macro - create multiple workbooks

Hello! I have a 4 tab workbook I need to create multiple copies of (one for each employee to use throughout the entire coming year). I have my Dat...

2 replies Last reply on 15 Dec 2017 by
snjblackbourne

Formatting cell based on text in another sheet

Hello, For e.g, I have "numeric" in cell B11 on sheet 1 with formula. However, I want the font color to change based on the text value in cell B2 ...

1 reply Last reply on 13 Dec 2017 by
ac3mark

Macro for copying group of cells and paste as row

Hi, I need some help i need a Macro Code to arrange certain cells and prepare it as a row. I export the file from SharePoint in Excel Format. ...

11 replies Last reply on 13 Dec 2017 by
ac3mark

If function in excel error

 Solved

Hello, anyone can tell me where the error Is. =IF(G:G>="0:05", 0:30Min, IF(G:G>="0:20",1:30hrs, IF(G:G="0:00",0:00hrs , 4:00hrs))) * * ...

3 replies Last reply on 12 Dec 2017 by
AngelaTyq

Auto populating sheets from data in main two sheets

Hello i have found VBA code from auto populating data from excel main sheet to new sheets for each record in main sheet column, i need code to crea...

1 reply Last reply on 11 Dec 2017 by
ac3mark

Can i have any training to using excel?

I wish to learn how to use excel

2 replies Last reply on 11 Dec 2017 by
loeyjon

Autopopulation of mutiple files from 1 master sheet

Hi All, Firstly many thanks to anyone who takes the time to read and try to help. It is greatly appreciated. I have 1 master sheet that I input dat...

1 reply Last reply on 8 Dec 2017 by
ac3mark

He cell checks 3 different columns each in different tables

how would the formula look if possible, the cell checks 3 different columns each in different tables on different sheets, if the value is=< todays da...

1 reply Last reply on 8 Dec 2017 by
ac3mark

Transfer data from main sheet to multiple sheets.

I have more then 5000 rows that contains each row have one person details with 15 different column(ex,name.contact no,address.etc), and i have to copy...

3 replies Last reply on 8 Dec 2017 by
vcoolio

Product key of office 2010

 Solved

I don't K now product key of office 2010 please send me this key Regards Pardeep Gur

2 replies Last reply on 8 Dec 2017 by
Ambucias

Code works fine on 2010 but not 2016

Hello, My company is having an issue we just updated our excel from 2010 to 2016, we have user forms that open a form to enter data but after we sub...

1 reply Last reply on 6 Dec 2017 by
ac3mark

Can i set a formula for sorting in excel.

Hello, Is it possible to set a rule in excel that the entered details will be sorted automatically by a set criteria?

3 replies Last reply on 6 Dec 2017 by
ac3mark

Conditional formatting with multiple rules and blank text cells

 Solved

Hi, I wonder if someone would be able to help me with this. This is probably really simple, but I can't get it to work. I need excel to change a c...

6 replies Last reply on 6 Dec 2017 by
PaiviM

Matching a value and returning location of next empty cell

Hi all I'm new here and I have been really stuck on this for ages, I'd really appreciate any help. I'm trying to write a macro which will work t...

1 reply Last reply on 5 Dec 2017 by
ac3mark

Excel sheet to add conditions

Hello, I am trying to do an excel sheet, so that if i put an x in a cell it adds the value from the top row. For a window schedule, where I assig...

1 reply Last reply on 5 Dec 2017 by
ac3mark

Setting up excel formula

 Solved

Hello, I need some help with the excel formulas I have new taxation laws that apply my organization from January. The current taxes are 10%...

7 replies Last reply on 4 Dec 2017 by
ac3mark

Post it digital notes

 Solved

Everytime I try to download Post it Digital Notes I get the 404 error. What do I need to do?

1 reply Last reply on 4 Dec 2017 by
xpcman

Where can i download a free word document to pdf converter

 Solved

looking to download a free word to PDF converter

2 replies Last reply on 3 Dec 2017 by
watzi

Percentage calculation

 Closed

Hello, How to know the percentage. Example total bill amount is Rs. 25000 and we are paying Rs.18000. Can u please help me find how to get the perc...

2 replies Last reply on 2 Dec 2017 by
m.thenmozhi

Cell formatting

Hi How do I get the cells I am typing in today to turn blue? With historic date remaining black?

1 reply Last reply on 1 Dec 2017 by
ac3mark

Comparing data between two excel sheets

 Solved/Closed

Hello, I have two excel sheets with the same columns. Essentially Name, Email, Phone. One sheet is the 'original" data and the other is the "upd...

12 replies Last reply on 1 Dec 2017 by
dubla89

How to: when a column has 1 of 3 values, copy text

Hello, I have an Excel book with 2 sheets (1 has a macro view and 1 has a micro view). The micro view sheet has a column B where the user enters a...

1 reply Last reply on 30 Nov 2017 by
ac3mark

Change a cell color in excel once it is activated

Hello, I have a little program in a Book with two sheets one called DATA and another called FORM, in this sheet I have placed the formula =DATA!$A$8...

1 reply Last reply on 29 Nov 2017 by
ac3mark

If cells match 3 criteria return the data already in 3 others

Hello, Hi, very basic knowledge but I have a sheet which my team can pick the name of an inspector on a drop down from a list of 5, the date they ...

1 reply Last reply on 29 Nov 2017 by
ac3mark

What does this excel formula mean?

Hello, Wondering if someone can assist and tell me what the following excel formula is doing: =IF($C$68$D$98,$D$98,N12),0) Context: Foreca...

3 replies Last reply on 29 Nov 2017 by
ac3mark

Corrupt powerpoint file, the file extension does not match the i

 Solved/Closed

Hello, I have several PowerPoint presentations that I can't open them now it says " file may be corrupted when use PowerPoint or expansion file ma...

1 reply Last reply on 29 Nov 2017 by
xpcman

Combobox select add values in other column in new cell

Hi I have a set of Comboboxes populated with the same 3 text values in each one. I also have a column of numeric in the same rows as each combobo...

1 reply Last reply on 28 Nov 2017 by
ac3mark

Autopopulating multiple sheets from one main sheet

Hello, I am trying to create a spreadsheet that uses one Master sheet (called Master), and then populates other worksheets with the data from that...

1 reply Last reply on 27 Nov 2017 by
vcoolio

Numbering create automatically

PO Number Qty In PO Total Quantity In PO I Need Numbering Like This 1111 1 1 1/1/1 2222 ...

1 reply Last reply on 27 Nov 2017 by
xpcman

Excel - if conditions

Hi All, I am trying to create a formula to show the outcome of a status based on 4 conditions. 1. IF cell A2 = Approved and B2 = Approved then C2 ...

1 reply Last reply on 27 Nov 2017 by
Mazzaropi

Product key

Hello, where can i find the product key to proceed further. System Configuration: Windows / Chrome 50.0.2661.102

1 reply Last reply on 26 Nov 2017 by
Ambucias

File permission error

Hello, i cannot save a file in microsoft word due to file permission error, how do i fix it? System Configuration: Windows / Firefox 57.0

1 reply Last reply on 25 Nov 2017 by
Ambucias

Help in sd card's password

Hello, I have lost my micro SD card password in my blackberry z3 pls if there is someone who is able to help me, may do that. System Configurat...

1 reply Last reply on 25 Nov 2017 by
Ambucias

How to create serial numbers

 Solved/Closed

Hello, I have an excel format shows different values of schedule of correspondence and some of the mails are gone to different addresses and the ma...

17 replies Last reply on 24 Nov 2017 by
Reham

I have the key, but can't download microsoft office 2010

I have the key, but can't download Microsoft Office 2010 on my new computer (Windows 10). Will be grateful for any advice.

1 reply Last reply on 23 Nov 2017 by
xpcman

Find word in a column from list of words and report word found

Hello, I have a large data set that I would like to search one column that contains sentences or purchases. I'd like to search from a group of wo...

4 replies Last reply on 23 Nov 2017 by
Jmrb2356

My intex basic phone .

 Closed

Hello, Sir I forget my Intex basic phone how to unlock the mobile.password 8 numbers System Configuration: Android / UC Browser 10.10.5.809

1 reply Last reply on 23 Nov 2017 by
Ambucias

Conditional formatting dates

Hi I am trying to format a date column on my spreadsheet and just can't see to get the formula right Simplified, I have 2 columns, one with a deadli...

1 reply Last reply on 22 Nov 2017 by
ac3mark

Formatting cell

 Solved

Hello, I want to highlight the coloumn B, if the coloumn A is greater than 0, In column A having numbers and the column B having texts. here so...

3 replies Last reply on 21 Nov 2017 by
sheeba

Macro that extracts info from changing number of worksheets

Hello, I'm trying to find a way to insert a summary of several worksheets (I'm calling them analysis logs), but want to make it in such a way th...

3 replies Last reply on 21 Nov 2017 by
vcoolio

Drop down look up

 Solved

Hello all, I have a 40 sheet workbook. I want to hide 39 of the tabs and use one sheet as the "master" to pull all of the data. I have the tabs in ...

14 replies Last reply on 21 Nov 2017 by
vcoolio

Automatically update master worksheet from other worksheets

 Solved

Okay, first I should mention that I'm a complete amateur when it comes to excel. No VBA or macro experience, so if you're not sure whether I know some...

18 replies Last reply on 21 Nov 2017 by
vcoolio

Help- conditional cell formatting

 Solved

Hello, I am trying to do some conditional formatting and having a little trouble. Here is what Im looking to get. I have a column A (estimated ...

2 replies Last reply on 21 Nov 2017 by
campbellty10

Transfer data to individual sheets from master sheet.

Hello, I am currently building a worksheet to track where cars are at a certain time. I have three places the car could be (west bullpen) (East Bu...

1 reply Last reply on 21 Nov 2017 by
vcoolio

Group duplicates and move to new worksheet

Hello, I have a data file and here's what i'm trying to accomplish as efficiently and automated as possible because I will need to repeat this dai...

4 replies Last reply on 19 Nov 2017 by
vcoolio

Auto populate from master to individual sheets

Hello, I have an excel sheet that I would like to auto populate from a master sheet to individual sheets. Basically it is an assignment list that I ...

1 reply Last reply on 15 Nov 2017 by
vcoolio

Make a macro run when data entered in a cell

 Solved/Closed

Hello, I have a macro that runs when the user clicks on a button. Instead, I want the macro to run when Cell D10 is populated. The data for D10 c...

36 replies Last reply on 15 Nov 2017 by
Rajiv

Need help with #value!

Hello, Hello, I need a formula that will change answer based on selection from drop down box (the formula that I used keeps giving me a #valu...

1 reply Last reply on 15 Nov 2017 by
Mazzaropi

Excel formula/vba assistance

Good Morning, I would appreciate some advice/assistance with formulas and VBA code. http://ge.tt/3wxXEJn2 I am trying to create an equipment ...

3 replies Last reply on 14 Nov 2017 by
vcoolio

Word 2010 showing dots instead of spaces

 Solved/Closed

Hello, when I press space tab in the keyboard, a dot is printed in the Microsoft word 2010. How can I fix this problem? faithfully you Con...

10 replies Last reply on 14 Nov 2017 by
Hugh
Results 951 - 1000 out of a total of 12,259