The discussions
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...
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?
Format font colour to change
SolvedHello, 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...
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...
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...
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...
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...
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
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...
Copy rows to new sheets if condition is met
SolvedHello , 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...
How to "teach" excel to learn names?
SolvedGreetings 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...
Search for a value in column and copy to different sheet
SolvedHi 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...
If then using multiple cells and words
SolvedHello, 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...
Need help with conditional formatting
SolvedGood 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...
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...
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...
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...
How to copy data from sheet1 to sheet2
SolvedHello, 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...
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...
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...
Air tv and windows
will powerpoint run on apple tv
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 ...
Excel formula for percentage
Solved/ClosedHello, 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 ...
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...
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 ...
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...
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
Powerpoint.the file cannot be opened
ClosedHello everyone. When i attempt to open a .ppt presentation in PowerPoint, i receive the following error message: The file cannot be opened because p...
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) ...
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 ...
A macro to create new, copy and name worksheets based on a list
SolvedGreetings, I need a macro that can automatically create new, copy (existing worksheet say '100') and rename the new worksheets, based on a list that ...
Need help creating an if then scenario
SolvedHello, 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...
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...
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...
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...
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...
A macro to copy/paste a cell and other cells in the same row
SolvedI 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...
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...
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...
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...
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...
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...
Trying to simplify data in excel through vbscript
SolvedPlease 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 ...
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...
Picture browsing using excel data
Hello, please proving coding for above requirement thanks
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...
How do i use conditional formatting in excel
SolvedHello, 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...
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...
(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...
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...
