The discussions

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

Excel help with comparing one file to another

Hello, I am trying to see if file matches another file to make sure the account hierarchy is correct. I have manually checked some and they are cor...

3 replies Last reply on 25 May 2017 by
Mazzaropi

Extract year from alphanumeric serial numbers.

Hello, Cell A1 = SX17010006 Cell A2 = SX17010006 Cell A3 = SX16120001 Cell A4 = SX15070004 I need a formula which read first four alphanumeric...

3 replies Last reply on 25 May 2017 by
Mazzaropi

Matching names to id numbers

Hi, I have a list of 1,200 students. They have won awards. I want to match the students who won awards with their student id numbers. Is there a...

1 reply Last reply on 25 May 2017 by
Mazzaropi

Pull information from one sheet to another

Hello, I have a sheet called "Master Client List" that contains 4 columns of data: Counselor Name, Client Number, Client Last Name, Client First Na...

1 reply Last reply on 24 May 2017 by
ac3mark

Macro to create a new workbook from a worksheet

Hello, Please can somebody help me with the below query? I would like to create a macro which copies all of the data and formatting from a spec...

3 replies Last reply on 24 May 2017 by
vcoolio

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

Vba to find specific text and cut and past into new worksheet.

Hello, I am struggling to find anything to help me with my VBA code that I am currently trying to write. I need it to find specific text (Technica...

3 replies Last reply on 22 May 2017 by
TrowaD

Copy employee ids to same cell in multiple worksheets.

Hello sir I have 400 sheets in workbook in first work sheet from I2 to I400 i have employee numbers Which i want to copy automatically to all 399 s...

1 reply Last reply on 21 May 2017 by
vcoolio

Macro to find, copy and insert

Greetings, Despite being completely new to macros, I'm attempting to create one that will search a range of values, and insert a row directly under...

1 reply Last reply on 20 May 2017 by
Reimertoad

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

Renaming multiple sheets in a workbook

Hello, I have workbook with more than 50 sheets.. I would like to rename all sheets with workbook name. Something like workbook.sheet1,workbook.shee...

1 reply Last reply on 19 May 2017 by
vcoolio

Help with excel +sheet1!xy function please

Hello, I'm using Excel to monitor some data from my class, but I'm a fairly novice user. I've been using +Sheet1!XY to copy data from one shee...

1 reply Last reply on 18 May 2017 by
TrowaD

Have to repeat list

Dear all Please help out have to repeat two list in one list. Query: List A List B A 1 B 2 C 3 D Results List C A 1 A 2 A 3 B ...

1 reply Last reply on 16 May 2017 by
TrowaD

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

4 replies Last reply on 16 May 2017 by
tanu

Copy filtered data to sheet 2

Hello, i have a main sheet with say column Item name and BATest. i need to filter data of BATest and if Data is Analog input (for eg) then correspo...

1 reply Last reply on 15 May 2017 by
TrowaD

Drag formula down depending on number in particular cell

Hello, System Configuration: Windows / Chrome 57.0.2987.133 I don't know if it is possible but here we go :) I have data from columns A ...

1 reply Last reply on 15 May 2017 by
TrowaD

If statement excel

Hello! Im a complete green at excell, maybe i just dont understand how the if statement work or im not that smart as i think :P The thing i want...

1 reply Last reply on 15 May 2017 by
vcoolio

How to convert ounces (oz) to milliliter

Good morning to all, can someone please tell me how to convert ounces (oz) to milliliter s (ml). Thanks JPortillo

1 reply Last reply on 15 May 2017 by
vcoolio

The date does not show up as entered. date format.

I am working with excel 2007 and the dates I enter show up completely different than the data I input. For example: I enter 050116 (no separators) ...

1 reply Last reply on 11 May 2017 by
TrowaD

Future date based on text result and previu

Hello, I'm not very good at this and am struggling to find the correct formula to calculate future dates but with multiple variables and cells as ...

6 replies Last reply on 11 May 2017 by
Littlemouse71

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

Date format for excel 2016

Hello, I need to change the date format to dd/mm/yyyy in excel 2016... so that when I save as a .txt file and the date should appear in the follo...

1 reply Last reply on 10 May 2017 by
ac3mark

Introduce color gradient of col a based on the value in col b

Hello, I am looking for a small help. I have 2 columns A and B, I have text written in A and numbers in % in B. Based on value in B, i want to add...

1 reply Last reply on 10 May 2017 by
ac3mark

Trying to populate columns f, g, h, i and j

I've attached a photo for some clarity. I am trying to populate columns F, G, H, I and J based on the info from columns L, M and D. I've tried P...

3 replies Last reply on 10 May 2017 by
ac3mark

Comparing two files, exclude header from selection

Hello, please help with the comparison of two excel sheets using macro. The one I used is - Sub All_Diffs_Highlighted() Dim wb1 As Workbook...

1 reply Last reply on 9 May 2017 by
TrowaD

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

Excel formula parent/child heirarchy assistance required please

Hello and good morning, I respectfully would like to ask for assistance please with an issue I'm having to find an Excel formula to compare data f...

1 reply Last reply on 9 May 2017 by
TrowaD

Weekly data imports to track status changes and new line items

Hello, What method would I use to import data into excel that contains line item numbers that increase each week? Additionally each week the numb...

1 reply Last reply on 9 May 2017 by
TrowaD

Populate a worksheet from an imported template.

Good Afternoon Currently in my spread sheet There is a Main page, on that there is a button called 'CREATE NEW CLIENT'. When clicked it runs this m...

1 reply Last reply on 8 May 2017 by
TrowaD

Excel macro help, copy rows and paste rows x times below

Hello, I need an macro to simply the below operation. I want to copy below text x times A B C D E F G If I want to output it 3x, t...

1 reply Last reply on 8 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

Lookup formula to find names.

Hi All, Thanks for your time. column C is from 1 to 12 column D is an amount I have a table of numbers which categorized the numbers with...

1 reply Last reply on 8 May 2017 by
Mazzaropi

Picture browsing using excel data

Hello, please proving coding for above requirement thanks

3 replies Last reply on 8 May 2017 by
TrowaD

Conditional formatting

Hello, I am trying to change a text color of one column based on another columns value. For example in Column A if it shows a W then the Dollar amou...

1 reply Last reply on 7 May 2017 by
Mazzaropi

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

How to simplify data entry

Hi All ok I have a daily sheet that i fill in every day it contains 5 fields I have another worksheet that i then copy the information from the...

12 replies Last reply on 4 May 2017 by
x

(excel vba) copy paste of multiple columns

Hi All, I am stacked with a simple VBA macro. I have an excel sheet containing a number of columns and i have created a Montecarlo simulation where c...

1 reply Last reply on 4 May 2017 by
TrowaD

Onclick the button view the time in activecell

Hi, I am using this code it's run successfully but each time click the button then overall change the cells. I want each cell view the current time...

1 reply Last reply on 4 May 2017 by
TrowaD

Date drop down on front sheet that will create new dated tabs

Hello, I am trying to create a workbook for recording daily pressure readings from different systems and I am trying to create a front page with a...

1 reply Last reply on 2 May 2017 by
ac3mark

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

Unable to download complex tables data on webpage using query

Hello, I am trying to figure out a way to download the data from this webpage, which has 4 collapsible sections but no luck whatsoever yet. htt...

3 replies Last reply on 1 May 2017 by
TrowaD

Creating 1 master sheet from data from multiple sheets

Hello, So I am at a complete loss on how to solve my problem. I'm brand new to excel and any help would be much appreciated. What I'm wanting t...

1 reply Last reply on 29 Apr 2017 by
vcoolio

Populating a summary report

I've been tasked with taking a large worksheet (>20K rows and 25 columns) and populating a summary report in a (pre-labeled) different worksheet. The...

4 replies Last reply on 27 Apr 2017 by
ExcelNewb17
Results 1001 - 1050 out of a total of 7,061