The discussions

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...

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

Worksheet_selectionchange event not working

 Solved

Hello, I wanted to execute a Worksheet_SelectionChange event code. But its not working. I searched on net to find that if I change (General) to Wo...

2 replies Last reply on 13 Nov 2017 by
Omi Kat

Give a response by comparing 2 times (in different columns)

I have a sheet which has a dispatch and arrival time in 2 separate columns. Our response time should be no more than 1 hour during office hours (7 AM...

1 reply Last reply on 13 Nov 2017 by
sailingdemon

Working out the difference in times between two columns

 Solved

I have various times in Column B (Departure time), and another set of times in Column C (arrival time). If the time in B is between 07.00 and 00.59...

5 replies Last reply on 12 Nov 2017 by
sailingdemon

How to load data from various sheets into one master sheet?

Hi Guys, Hope for an expert in excel who can help!!! I have a spread sheet that contains: 1st sheet is master file with the number plate number...

1 reply Last reply on 12 Nov 2017 by
vcoolio

Excel macro to insert two rows.

Hello, System Configuration: Windows / Chrome 61.0.3163.100 I have similar problem as this. Just that, I wanted to insert row in different ...

1 reply Last reply on 12 Nov 2017 by
vcoolio

Convert in to rs in word

3456755332578097 convert in to rs in word

1 reply Last reply on 11 Nov 2017 by
xpcman

Inserting day of week along with date

Hello, I found an previous post with same question that is closed and it was helpful except for the format. I am looking for an outcome of: Su...

2 replies Last reply on 10 Nov 2017 by
jmoricone

Multiple cell copy to a single cell

Hello, I am trying to copy the contents of multiple cells in workbook A to a single cell in workbook B. This worked fine in the 2010 version but,...

1 reply Last reply on 10 Nov 2017 by
ac3mark

How to copy columns to a specific column header and repeat?

 Solved

Hello all, am new to using macros in excel. i have data and i want to be able to columns and paste it under some specific columns repeatedly. Examp...

2 replies Last reply on 10 Nov 2017 by
stylus33

Auto populate data from invoice.

Dear CCM.NET, Hope you are doing well. I am working for a yarn whole-seller company. I to keep record of various kinds of Yarn purchase, Yarn sell,...

1 reply Last reply on 9 Nov 2017 by
xpcman

Changing format of date in excel

 Solved/Closed

Hello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to dd/...

Last reply on 9 Nov 2017 by
Dnbaugh

How to create new sheets by column with repeated values

Hi Have lines with various tables in rooms. Rooms numbers are in column, but sometimes room have 2 or more tables so room numbers repeats. Code s...

1 reply Last reply on 8 Nov 2017 by
ac3mark

Getting rows from one sheet to populate to another

Hi, I am working in Excel 2016. I have several separate rows of data on one sheet (lets call it my mother sheet) that I want to automatically popul...

1 reply Last reply on 8 Nov 2017 by
ac3mark

Max(if..?

hello, i have a table with 2 columns. the first column sometimes has text (any text), sometimes not! the second column contains the amounts. i wa...

1 reply Last reply on 8 Nov 2017 by
M_me

Calculation using alphabet instead if number

Hello, Dear Sir, If I assumed A=1 B=2 C=3 D=4 F=5 G=6 H=7 I=8 J=9 K=0 For example Numeric column > 9949 = JJDK 9949 ...

1 reply Last reply on 7 Nov 2017 by
xpcman

Copying formula by changing only one rule.

 Solved

Hello Team, I want to copy the formula "=INDEX((Sheet1!B2:B99),MATCH(B24,Sheet1!A2:A99,0))" 1000 cells by changing only "B24" to "B25, B26" and so ...

2 replies Last reply on 7 Nov 2017 by
shan_asa

Month and year format in forms in excel

Hello, Hello sir I am using forms to enter data. In form i used drop down list function to select particular month from pre-entered months from Nam...

4 replies Last reply on 7 Nov 2017 by
kishore.koka

Autopopulating multiple sheets from main sheet by date

Hello, My name is Ana and I have a situation. Every day we have hunďreds of rows with diffrent info about our customers. On column H we have cells...

4 replies Last reply on 4 Nov 2017 by
Anabrega

Automatic add and sub

Hello, Hi everyone,I need help from u regarding excel formulas and workout basics.My question is..If i add particular row or column it should be a...

1 reply Last reply on 2 Nov 2017 by
ac3mark

Looking to enter a name and then want it to be pasted in x numbe

Hello, Looking to enter a name and then want it to be pasted in x number of rows. Then enter a new name in the x + 1 row and want that pasted y n...

1 reply Last reply on 2 Nov 2017 by
ac3mark

Vba macro loop

Bare with me here, I just started learning VBA code so it may look a little ruff but what i am trying to do is to use a loop to copy and paste each su...

1 reply Last reply on 1 Nov 2017 by
ac3mark

Compilation

Good day to all, I am looking for help and I have asked all the knowledgeable people at work to no avail. As per the uploaded picture, I am lo...

2 replies Last reply on 30 Oct 2017 by
Wade526

How to compare a range of data in excel?

 Solved

Dear Team, I want to compare a range of values from columns in row A (A1 to A6) with date input in column C1. If C1 is equal to data in A1 then D1 ...

4 replies Last reply on 29 Oct 2017 by
shan_asa

Adding and subtracting using vlookups

Hello, =IFERROR((E2)-(VLOOKUP($B:$B,'Forecast Pivot'!$A:$AB,3,FALSE))," ") I need to add in another vlookup to the formula but have tried a few...

1 reply Last reply on 27 Oct 2017 by
ac3mark

Pictures insertion

Hello TrowaD, With this code, pictures are linking to the file and not inserting. i.e. If I send the file to someone in email they cant these picture...

1 reply Last reply on 27 Oct 2017 by
ac3mark

How to use vba to loop copy and paste

Hello, I have a formula in raw # 12 (E12: TNF12) and would like to paste this formula in the raw below (raw# 13) and then copy and paste its conte...

3 replies Last reply on 26 Oct 2017 by
ac3mark

Copy paste special values macro

Hi, I am not good with Macros so I am looking for help creating a macro that takes data from formulas, copies the formulas down to the next row and t...

9 replies Last reply on 25 Oct 2017 by
ac3mark

How to update data of sheet2 in sheet1 with excel?

Hello, I have data in SHEET1 A1-5 A2-6 A3-9 I am entering data in SHEET2 A1 B1 C1 D1=SHEET1!A1-C1 I want to update this D1 value...

1 reply Last reply on 25 Oct 2017 by
ac3mark

Use conditional formatting to highlighting cells based on name

Hello, Im in the process of redesigning a roster that involves employees from a number of different contractors. I have all employees on a sepe...

1 reply Last reply on 24 Oct 2017 by
ac3mark

Vba for copying from data entry sheet to corresponding sheets

 Solved

Hi, I am new to excel and would need some help. I wanted a vba for copying from data entry sheet to corresponding sheets automatically in the same ...

7 replies Last reply on 24 Oct 2017 by
TrowaD

How to extract data using vba in excel?

Hello, Need some help to create a VBA for Excel 2016.. Basically i have 2 workbooks. Workbook 1 is Master File. Workbook 2 is the monthly d...

1 reply Last reply on 20 Oct 2017 by
ac3mark

Calculate a percentage when the values are text

I need to calculate the values of J1-J20 where J21 is a percentage complete. 100% completion is met at J14 and anything over J14 is over 100 percent. ...

1 reply Last reply on 19 Oct 2017 by
ac3mark

How to count the number of occurrences in a range

I would like to know how to count the number of occurrences of each number in a range. Example would be, how many times each number from 1 thru 50 occ...

3 replies Last reply on 17 Oct 2017 by
Mazzaropi

Formula for unique id's following a predefined rule

Hi, I am in need of a formula that can deal with the following situation: We have many projects each year. Each new project gets assigned a 4 d...

1 reply Last reply on 16 Oct 2017 by
TrowaD

Dates conversion

Hello, How do i convert dd/mm/yyyy to mm/dd/yyyy for this date 05/10/2017 into 10/05/2017? this formula (MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A...

1 reply Last reply on 16 Oct 2017 by
TrowaD

Reformat date field to plain text

I have access to a spreadsheet posted on the Web. I have copied it and pasted it into a MS Excel 2010 spreadsheet. There is a column that I would ap...

1 reply Last reply on 15 Oct 2017 by
vcoolio

How to give a students two ranks

Dear sir, I have made a result sheet with ranks. I want to give a student two ranks one in his class and other in all sections. For example, if class ...

4 replies Last reply on 13 Oct 2017 by
Fayyaz295

Delete or insert rows in a workbook

 Solved

Hello, sir how i can delete or insert rows in a workbook between sheet one & sheet two for example when i insert or delete row in sheet one i wa...

1 reply Last reply on 12 Oct 2017 by
TrowaD

How to make one summary file with 29 sum up sheets

Hi My self Dr. Seema Mehrotra working as an Urban Economist at National Institute of Urban Affairs, New Delhi, India. I am working on a very large...

1 reply Last reply on 11 Oct 2017 by
ac3mark
Results 751 - 800 out of a total of 7,065