The discussions

Spreadsheets viewing formulas

 Solved

How do I view hidden formulas on spreadsheet

3 replies Last reply on 29 May 2017 by
TrowaD

Vba send email via outlook using loop; no response when run

 Solved

Hello, the above code is not functional as described. Is there a way to check what is wrong? the screen does not show anything upon clicking the r...

9 replies Last reply on 29 May 2017 by
TrowaD

Vba code in my command button doesn't work

 Solved

Hello, I have a sample table below, I was trying different VBA code in my command button but doesn't work well. Column G is already programmed t...

1 reply Last reply on 28 May 2017 by
vcoolio

Vba column

 Solved/Closed

Need to know how to added data in column field if column is not empty then go to another column and paste data

Last reply on 28 May 2017 by
Ambucias

Color cell based on two worksheets' matching values.

Hello, I am in the logistics field; one task that I have to do daily is compare two automatically populated workbooks (yesterday's and today's) and...

1 reply Last reply on 28 May 2017 by
vcoolio

How to automatically copy selected cells to different sheets?

Hello, I am trying to build an Excel workbook that records information from certain invoices in one sheet and then categorizes them into other spe...

10 replies Last reply on 27 May 2017 by
vcoolio

Copying cells if condition is met

Hi everybody, I'm trying to make a spreadsheet with a "master sheet" with all the information for the people registered in our club. In this master...

1 reply Last reply on 26 May 2017 by
ac3mark

Open office not opening

open office 4.1.3 will not open. I have windows 7 and this editon of office has been working all along. Should I download this version again?

1 reply Last reply on 26 May 2017 by
ac3mark

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

Turn off "enter network password"

How do I turn off "Enter Network Password" in Outlook 2007. Using Windows 7. At present it is happening when I try to use my VPN

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

Air tv and windows

will powerpoint run on apple tv

1 reply Last reply on 16 May 2017 by
ac3mark

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

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

Powerpoint.the file cannot be opened

 Closed

Hello everyone. When i attempt to open a .ppt presentation in PowerPoint, i receive the following error message: The file cannot be opened because p...

Last reply on 11 May 2017 by
jacksomathew

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

Commands "cut", "paste" are not highlighted

Hello everyone! Just need a little help here. I just installed Office 2007 on a new computer using Windows 7. It installed pretty well, the only thing...

1 reply Last reply on 8 May 2017 by
Ambucias

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
Results 1301 - 1350 out of a total of 12,266