Excel Forum
-
Excel numerical value for multiple alphabets [Closed]
Hello, how to give numerical value for multiple alphabet in one cell for excel if i give 1520 in one cell the answer mustbe CEUD for example ...
-
One cell calculation Excel - Time Interval [Solved/Closed]
Hello, I need to calculate the elapsed time in hours if the start time and end time are contained in the same cell. Example: If A1...
-
Compare 2 worksheets [Closed]
Hello, I'm just new here and not an Excel expert. I have two Excel sheets with Names, address and other information. Here's the thing, not...
-
Date Format Quandry in EXCEL [Closed]
Hello, I am sorting data on excel and I have encountered a problem that I can't seem to overcome. My column with date information is formated...
-
Multiple Rows for 4 Conditional Formats [Closed]
Hi, I need to make four different color conditonal formats depending on a few statements. I know what statements I need, but how to I get it...
-
Help with Excel complex formulas [Closed]
Hello, Currently using MS excel 2003. I have the following formula thats generating a value of 0. If I do individual filters it will provide...
-
Hide columns and rows using count rows/colums [Closed]
New to VBA/Macros Trying to hide all rows and columns not being used in a sheet that has a fixed/finite design. Because this will be used in...
-
Using If-Then Function in VBA [Closed]
Hello, I wanted to make a macro so when column C has a certain number in a row then in column E, with the same row, it will insert a name. Ex....
-
Lookup table? Excel [Closed]
Hello, I am working from 3 different spreadsheets with meter reading information: 1-meter reading from date 6/8/2010 (Address|meter...
-
Excel : Different Criteria for excel to look [Solved/Closed]
Hello, Please could anyone help? Attached please find the example. https://authentification.site/files/23122635/nono.xls The sheet (Say in...
-
Excel Macro [Solved/Closed]
Hi I am new to Excel macros, I need help with the following automation: I am trying to copy data from the main spreadsheet name "PMO Report"...
-
mozilla browser problem [Closed]
Hello, my mozilla firefox is not working,when i click it to open it gives no response.same problem for chrome,opera.only IE is working which is...
-
Find records in different sheets [Closed]
Hi everybody, I'm having a problem, Iam not an expert using excel and I don't know how to find a record in different sheets. In the sheet1 I...
-
How to compare two data (Excel) [Closed]
Hello, I have two separate data with same number of cells and locations (eg, A1:C10 and D1:F10.........or A1:C10 on sheet 1 and sheet 2) I...
-
HELP!!!! EXCEL DUMMIE HERE [Closed]
Hello, I am trying to create a formular in excell and i dont ave a clue what im doing i have a spreadsheet with candidate information on...
-
MS Excel 2007 Macro/Formula problem [Solved/Closed]
Hello, ##Please help! I am new to this and so fed up!! I need to transfer data from two worksheets onto another worksheet and I just cannot do...
-
Excel Macro Help Please [Solved/Closed]
Hello Everyone, I am sking for some help with an Excel macro please. I have a 1,900 hundred static HTML pages that I have converted to text...
-
Compare two worksheet, match with 2 columns [Closed]
Hi, I have a workbook with 2 worksheet (April , May).it consist of 4 columns for each worksheet.i need to compare column A and column C with...
-
Compare two worksheet, match with 2 columns [Closed]
Hi, I have a workbook with 2 worksheet (April , May).it consist of 4 columns for each worksheet.i need to compare column A and column C with...
-
need to declare a cell as numeric in macro [Solved/Closed]
Hello, i need to declare a cell in excel as numeric so that only numbers can be entered in that cell and if any other text is entered then...
-
Excel Insert Row after 4 Rows [Closed]
Hello, For some reason I am having the hardest time figuring out this simple macro I need to insert a row after 4 rows for a large amount of...
-
Copying data from multiple worksheets [Closed]
Hello, I'm trying to copy data from multiple worksheets to one central worksheet using a macro. The data from each worksheet - which is...
-
Excel VBA [Solved/Closed]
Hello, currently i have 2 worksheets one which users would use to complete a template and the other to store the information in. i am...
-
I cannot open any internet browser on windows [Closed]
Hello, My windows xp cannot open any form of internet browser. (I had to use a different computer to ask this) IE looks as though it is loading...
-
Excel Conditional Format across sheets [Closed]
Hey there, I have been racking my limited knowledge of excel trying to work this out but cant get it right! I have searched and searched but just...
-
Convert Certain Rows into Columns [Closed]
Hello, Hi all. I need help on how to convert excel data from certain rows into columns. Let say I have data in this...
-
excel [Closed]
Hello, i have to find latest date for each item whenever i open the sheet. ....there r more than 100 items...and data is modified...
-
more than 3 conditional formatting excel 2003 [Closed]
Hello, I have the need for more than three conditional formats for rows in a table based on conditions in a specific...
-
Merge information from two cells into one [Closed]
Hello, I have a workbook that contains two sheets. I want to take numbers from two separate cells in sheet 1 (ie a numerator and denominator)...
-
Excel 2007 time and date problem [Solved/Closed]
Hello, I have a sheet that has a date column and a time column (brought in from a csv file). My date column is showing in the format of...
-
Need a macro [Closed]
Hello, Hello, The invoices should be sorted in ascending order and I need one row gap in between the set of invoices and should also check...
-
Excel VBA colour alternate rows [Solved/Closed]
Hello, I am creating a report, and I want to shade alternate cells in a light grey colour. I need all columns and rows, starting at A5, that...
-
HELP WITH EXCEL [Closed]
Hello, I am a super novice on excel. I am creating a database with names phone numbers and addresses. It is a total of 16 worksheets. One...
-
Excel Conditional Formatting for Colors [Closed]
Hello, Here is what I am trying to create and I am running into some trouble. Maybe someone could help me out with this. Is there a...
-
Need an excel macro [Closed]
Hello, I am trying to create a macro where i can take for an example column A with phone extenions for all employees and make it where it will...
-
Timesheet making in excel [Closed]
Hello, I am making a time sheet for my staff. In one coloumn A i have the weekdays and in coloumn B i have the attendance.Weekly off is on...
-
Uneditable selected Columns/Rows/Cells Excel [Solved/Closed]
Hello, Kindly teach me how to keep the slected [Column or Rows or set of Cells] in Uneditable Mode in Excel, so that users can not change the...
-
update multiple sheets simultaneously [Closed]
Hello, How to update two identical workbooks in different locations in same pc simultaneously. I have two identical excel workbooks. When I...
-
VBA [Closed]
Hello, I want to write a code that finds the last enterd data in sheet 1 and copy that data and paste it in another sheet3....
-
Excel 2007 filter not working [Closed]
Hello, I am Mohammad Asif and using excel 2007 from last 8 months.I am facing a problem of filter.The problem is, i have 1050 rows data and...
-
STAR Browser history HELP [Closed]
Hello, PLEASE HELP. I'm unable to find my internet browser history folder. I really need to see this urgently, but there's no option for...
-
Condtional formatting - other workbook VBA [Closed]
How can i use conditional formatting to extract data from other workbook? i...
-
how can i compare one excel sheet to other [Solved/Closed]
I have 1 main sheet of all the data which i send to my client, now he has slelcted some thing and sended it in new sheet. now i wanna highlight...
-
Excel unique data rows [Solved/Closed]
Hello, I need to compare two columns of data for uniqueness. Column a has a list of names and column b has a list of date/times. I need to...
-
excel pro [Closed]
Hello, i have one file with ext.r.a.r and want this file to open in excel plz help.. it's urgent Configuration: Windows XP / Internet...
-
Unable to copy selected cells - Autofilter [Closed]
Hello, I am using excel 2007. In my dataset, I have following: Column A - Set of locations and Column B: Number of times location appears....
-
Color shading vba [Closed]
Hello, Please does anyone know if there is a VBA code that can help me to perform this: If a phase starts with M then look up column 4 and 5...
-
Excel 2007 formula needed [Closed]
Hello, I have an excel spreadsheet i created with a dropdown list in column a which is picking up the information from another sheet within...
-
easy pc connects but I cant browse [Closed]
Hello, after recieving the new easy pc e700 series netbook I tried connecting to our wireless internet and it will let me connect but when i try...
-
excel 2007 [Closed]
Hello, Please let me know how to use stat formulas in excel guide me thanks Configuration: http://www.needpaydayloan.org/
