The discussions
Excel
Hello, when users enter a date in excel using this format 12-01-2008, i need the cell to automatically change the format to 12/01/2008 i have...
Excel - dropping zeroes from time
Hello, I have a set of times in column A in Excel (HH:MM:SS). In column B I need those same times, not rounded, to have 00 as the Seconds value. ...
Calculate the sum of rows using macro
Solved/ClosedHello, I need some help with the folowing problem. I have a table with changing length of rows and columns. I need to calculate the sums of the rows ...
Macro to find lowest level from hierarchy
Hello, please see the excel file i have below i need to search the lowest level from the heirarachy level list which i have as output of my standar...
End of excel data throurh vba
Hello, Is there any method to find a particular value in the excel through VBA. Alternatively: how can i get the colunm and row of the cell where ...
Excel worksheet
Hello, I have to update the excel worksheet column which has prices of all the products. ill give the example: I have a list that contains : ite...
How i connect many worksheet in a single work
Hello, Sir, I'm Robin Sarma and i have problem in MS-EXCEL, Sir, how i connect many worksheet in a single wokbook
Editing be done in particular sheets
Hello, I have 4 sheets in a workbook, one sheet where i would input the parameters name it Input, & other sheets where it would b updated. suppos...
Referencing multiple cells to one cell
Hello, I have a table of values that i have screenshott here, for you: http://tinypic.com/images/goodbye.jpg I also have what resembles a query ...
Excel formula
Hello, i want to count some cell but if 2 conditions are meet.
Excel sheets lookup/macro
Hello, I have a excel spreadsheet with around 50 sheets. In each sheet, in square D3, there is a name of the person who that sheet applies to. I ...
Can't get worksheetfunction to work
Hello, i have a column of data where i am trying to find the maximum for each 96 values. you'll understand this better when you see my macro below...
Unable to paste excel on my local hd
Hello, I copied excel file from the repository of our company and wanted to paste it on my local HD. When I right click on the desktop, the paste opt...
Macro comparing two columns
Hello, I am trying to compare two entire columns in excel, Column A and Column B. If any cell in column A= Lead and any corresponding cell in column ...
Urgent help needed in excel
Hello, please help me out with this.. formula to find out a value from the list of values in an column. will appreciate a quick responce.. t...
Excel
Hello, if i want the same result in cell E1 as in C1 what should i do for eg : January Febra...
Hypelinked combo box in excel
My Query is I Have made a Combo Box in Excel Sheet 1 in that Combo Box i have 2 sheets Sheet 1 and Sheet 2 . Now i want to Hyperlink / vb...
Matching cells
Hello, I would like to know if there is any formula for this situation. I have Column A: account numbers. Column B: Account Balance Column C:...
I want excell to calc based on input data
Hello, I want to be able to put in a number and then excel does a cal all in one cell. I know I could put 6 in C3 then in D3 put =c3*178 but ...
Spreadsheet
Hello, I'm currently working on a spreadsheet for a timesheet. I want to format a cell to display the date of a certain day of the week. e.g. I ...
Stopping at bottom of spread sheet
Hello, I often have to format a whole column with the same formula. I click the corner and pull it down which works fine. The frustrating part is tha...
Excel 2003 vb macro for finding txt strings
Hello, I am trying to write an Excel 2003 Visual Basic Macro that searches a cell for a particular word. But the cell contains several words. So I can...
Help using excel macro to insert rows
Hi, I currently have over 7000 rows of data, displayed similarly to this: Iten: Value Value Value Apples x ...
Macro variable help
Hello, I have declared a variable Dim x As String x = Cells(x + 10, 10).Value I am getting the value of a cell in x. I want to use that val...
Macro or formuale help required comparing cel
Hello, I've got Excel 2003 with 2 columns of data A & B with people names in it. Column A is always populated with data (a name), column B isn't alwa...
Copying the first four columns data
Hello, I want to copy the first 4 column of data from one sheet to another sheet in the same excel. Basically the first 4 columns of data in sheet1 ...
Format cells excell
Hello, I would like to format a cell in excell to accept dd/mm/yyyy or just yyyy. Excel 2007 using windows vista premium. If not excel, I would...
Conditional formatting (more than 3) in excel
Hello, I want to select a colom containing discription's Example (HATS)(bats)(cats) if this criterea is found i want the rows to the left that coris...
Relative sheet reference
Hello, I am trying to write a macro (new to VB) that shifts contents in a branch layout to be aligned on the left, column A. I have this code that ...
Excel: convert oz. to milliliters inside text
Hello, I've been looking for a solution for the following issue: I have a very long excel list of product description that contain product with ...
Naming range in a macro
Hello, I am tyring to name a range say a14:d14 (working_cap_formula) and then copy of past into range a15:d15 (working_cap_paste). I have set up...
Cell date creates a new sheet
Hello, I am working on an excel worksheet for a construction project. I have an "Additional Work" worksheet set up so that I can enter a date in a...
How to create a clickable button and macro in
Hello, I am trying to create a button in an Excel worksheet that will continuously recalculate the formulas on a given sheet. I have seen a button...
Internet conected but can't brows in day time
Hello, Internet connected but can't browse during only day time . After 8 p.m. to 9 a.m.{appro.} i can browse easily My ISP is TATA broadband . Tat...
Browse the internet w/o internet connection
Hello, is it possible to connect or browse the internet without an internet connection?!!!!!!!!!!! please!! answer...
Macro iterate through with if
Hello, I am trying to write a macro in excel but it has me completely stumped. I want to paste into column P the word 'resolved' for each cell wher...
Reagerding macro
Hello, I am using ofice 2003(Excel).While opening the excel every time i am getting a popup reagarding the enable macro option,what i am doing is set...
Internet browsing in computer through china m
Hello, Thank you very much for providing gee pee 7310 pc suite link. But gee pee pc suite does not have any option for the browsing internet ...
Excel formatting and sorting dates
Hello, Problem.... I'm entering dates into Excel. I need these dates date in the format "ddmmyyyy" with leading zeroes where the day is < 10 e.g. ...
How to connect phone to pc and browse
Hello, can anyone plz explain to me how to connect phone to browse on pc or laptop...
Linking cells within excel
Hello, How do I change one cell in a worksheet one and have it update the other worksheets at the same time within the same Excel file. Keith
Auto copying from sheet to other sheet text a
Hello, i had one excel sheet which contains one tracker of four sheets. I want a formula to copy that data's from one sheet to other sheet au...
Match two columns in different sheets
Hello, I have three work sheets with columns namley process code, process name, quantity produced per day. I need to create another sheet comprises...
Regular epression in excel
Hello, I have 2 questions in excel 2007: 1) I have excel columns with the format 12,4 17,1 8,2 etc.. I want to replace it with ...
Excel undo buffer macro access
Hello, Is there any VBA object or Windows API access to the undo buffer/command history in Excel 2000? Cheers
Excel column sort
SolvedHello, i have a list of numbers/letters titles written like: 1KFLS921 there are around 2000 of these listed down column A. i have the same l...
Tips for writting macro in excel
Hello, I have one excel file which contains more than 15000 records. for one column i need to find and replace (ex : -500 to 0) number starting wi...
Excel - reset / replace seconds to zero
SolvedHello, i have an Excel 2007 file which has in sheet1 the time people enter to the system with the format ex. 11:55:31 AM and i need to reset all the ...
Excel
Hello, i am prasath explain the various addressing modes supported in excel that can be used in the formulas prasath
Worksheet name
Hello, in sheet 1, i need to get the name of other worksheets using formulas. thanks,
