Excel Forum
-
macro to find lowest level from Hierarchy Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
Hello, i want to count some cell but if 2 conditions are meet.
-
Excel Sheets lookup/macro Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
Hi, I currently have over 7000 rows of data, displayed similarly to this: Iten: Value Value Value Apples x ...
-
Macro variable help Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
Hello, is it possible to connect or browse the internet without an internet connection?!!!!!!!!!!! please!! answer...
-
Macro iterate through with If Closed
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 Closed
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 Closed
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 Closed
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 Closed
Hello, can anyone plz explain to me how to connect phone to browse on pc or laptop...
-
Linking cells within Excel Closed
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 Closed
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 Closed
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 Closed
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 Closed
Hello, Is there any VBA object or Windows API access to the undo buffer/command history in Excel 2000? Cheers
-
Excel Column Sort Solved/Closed
Hello, 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 Closed
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 Solved/Closed
Hello, 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 Closed
Hello, i am prasath explain the various addressing modes supported in excel that can be used in the formulas prasath
-
worksheet name Closed
Hello, in sheet 1, i need to get the name of other worksheets using formulas. thanks,
-
How to run Flash Macro Closed
Hello, How to run flash macro srinivas pattem
-
MACRO TO DEL SPACE IN CELL Closed
Hello, I need a macro that after I goto a cell I start the macro that then goes home in the cell. Then it deletes the empty space in the begining of...
-
stock sheet Closed
Hello, i wondered if you could help , i have created a worksheet with code of stock item,value of item , amount in stock and value of stock availabl...