Forum
Office software
-
Conditional Formatting: Change fontcolor based on another cell [Solved/Closed]
Hello, I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell...
-
Copy/paste a range 'n' times. [Solved/Closed]
Hello, I have a highlighted portion and I want to copy and paste it 200 times. Is there a code or formula to do this automatically? Or must I...
-
Conditional Format [Solved/Closed]
Hello, I can not seem to figure out this conundrum. I am looking for conditional formatting to occur if cell $AI2 has
-
Vlook up [Solved/Closed]
Hello, I have 2 columns A & B in sheet1 and i want to Return Yes if either A or B value mactches with Coulmn A in Sheet 2. Please help
-
Spreadsheets viewing formulas [Solved/Closed]
How do I view hidden formulas on spreadsheet
-
VBA send email via Outlook using loop; No response when run [Solved/Closed]
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...
-
How to convert the tamil pdf file to tamil word file [Solved/Closed]
plz give the solution
-
VBA code in my command button doesn't work [Solved/Closed]
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...
-
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
-
Creating search and update command buttons in a userform [Solved/Closed]
I have created a userform for inputing new records in an Excel spreadsheet. I have written the code for the Save Record and Close Form command...
-
Format font colour to change [Solved/Closed]
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...
-
Copy rows to new sheets if condition is met [Solved/Closed]
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...
-
How to "Teach" Excel to Learn Names? [Solved/Closed]
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...
-
Search for a value in column and copy to different sheet [Solved/Closed]
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...
-
IF then using multiple cells and words [Solved/Closed]
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...
-
Need help with conditional formatting [Solved/Closed]
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...
-
How to copy data from sheet1 to sheet2 [Solved/Closed]
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...
-
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...
-
Copy rows based on a condition [Solved/Closed]
Hi How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains...
-
A macro to create new, copy and name worksheets based on a list [Solved/Closed]
Greetings, I need a macro that can automatically create new, copy (existing worksheet say '100') and rename the new worksheets, based on a list...
-
Need Help creating an IF THEN scenario [Solved/Closed]
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...
-
A macro to copy/paste a cell and other cells in the same row [Solved/Closed]
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...
-
Trying to simplify data in Excel through VBScript [Solved/Closed]
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...
-
How do I use conditional formatting in Excel [Solved/Closed]
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...
-
Excel VBA - Find and Expand matching cell entries [Solved/Closed]
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...
-
How to populate information on multiple sheets at once [Solved/Closed]
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...
-
Outlook 2007 is not sending mails [Solved/Closed]
Hello, Dear Sir, Have a nice day. I migrate my data from one PC to another the old one was with XP windows as well Outlook 2003 while...
-
Copy and insert rows n number of times in Excel [Solved/Closed]
I am trying to create a macro under Excel. My data is as follows: Col1 Col2 Col3 Col4 Col5 Col6 Col7 A1 1080 90 M 40 45 50 ...
-
Shortcut to edit a cell without using F2 key [Solved/Closed]
Hello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit...
-
Data in a hot key [Solved/Closed]
Hello, I want to put an email address in a hot key so I don't need to type it ever time I need to insert it. Thanks for your help in advance.
-
Conditional format if hyperlink [Solved/Closed]
Hello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has...
-
Compare the words in 2 columns in Excel [Solved/Closed]
I gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new...
-
Excel forum within a range [Solved/Closed]
Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, ...
-
Convert wordpad document back to pdf [Solved/Closed]
Hello, i as sent a file and wheni went to open it it said open with word or internet i picked word and now its not what i wanted to have done...
-
Need to delete columns based on Column header [Solved/Closed]
Hello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the...
-
Auto generation of code [Solved/Closed]
Hello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? ...
-
Excel - A macro to create new workbook and copy data [Solved/Closed]
In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2...
-
Excel - macro to create multiple sheets [Solved/Closed]
Hello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for...
-
Comparing columns and returning value [Solved/Closed]
Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another...
-
Import .pdf ...? [Solved/Closed]
Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works...
-
Running a macro in different cells [Solved/Closed]
Hello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run...
-
Formula [Solved/Closed]
I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a...
-
Conditional Formatting based on two cell values [Solved/Closed]
Hi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has...
-
Copying cond. format for entire row based on 1 cell to other row [Solved/Closed]
I have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value
-
Drop down lists [Solved/Closed]
Hi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to...
-
Removing False Value [Solved/Closed]
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an...
-
Copy rows to other sheets based on value in column [Solved/Closed]
All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way...
-
PDF file alwasy opening in Word [Solved/Closed]
Hello, What to do to disable my attachment file in pdf to open in Word application?
-
Trying to create a multi-column formula. [Solved/Closed]
Hello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the...
-
Excel problem [Solved/Closed]
Hello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...