Excel Forum
-
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...
-
Excel cell flash when date is near Closed
Hi, I am trying to find out how to get an excel spread sheet to hightlight a date when that date gets near. There must be a way for the sheet to ...
-
Excel Closed
Hello, I need to know the easiest way to select a cell in excel?
-
MULTIPLE SEARCH $ MULTIPLE RETRIEVAL IN EXCEL Closed
Hello, I have one column with numbers or text which are repeating more than once. column 2, 3,4 contain data corresponding to that. ...
-
excel extraction Closed
Hello, I'd like to be able to extract all the data which comes after the comma from a cell in each row and insert it into a new column. Here's an ...
-
macros for dynamically generating excels Closed
Hello, Can I create a macro for a dynamically generating excel? i.e Each time when I run my ETL tool it loads the data into an excel i...
-
Cpy rows frm 1 sheet to nxt sheet dynamically Closed
Hello, I have a requirement where I need to copy rows from 1 sheet when row/record count reaches a certain count(lets say 5) to the next ...
-
Macro Help Closed
Hello, im trying to write my macro code and the code won't work because this message keeps appearing 'can't execute code in break mode' what doe...
-
comparing two excel sheet in vb 6 Closed
Hello, i am diploma student and plz plz any one can tell me how to compare two excel sheet in vb 6.0 that means there is 2 excel sheet...
-
How to remove junks in Excel Sheet Closed
Hello, Hai please Can any one help to overcome the below mentioned problem I am having thousands of records in Escel sheet if i convert into c...
-
A macro problem, find and replace Closed
Hello, I have a macro which contains the following procedure: Range("D210:D219,Z210:AA219").Select Range("Z210").Activate Application.CutCopy...
-
Macro for selecting lines Closed
Hello, please i need help for a macro. I have a list with a column named "ticket id". I want the macro to filter the list and copy all rows cont...
-
Transfer data from merged cells in excel Closed
Hello, I have a worksheet form in excel and I would like to copy the informaiton on the form to another sheet in a different workbook in excel as w...
-
Excel Macro help Closed
Hello, I am new, and know next to nothing about Macros in excel, and I was wondering if anyone could help me out. I do a report every week, and it...
-
Excel Macro Help Insert Row Closed
Hello, I need help with a macro for excel that will look at my sheet and if theirs data in Colomns D2:Z20. If theres data in any of the columns af...
-
Help in Excel macro Closed
Hi, I have a work sheet with probably say 7 columns and each of them has a index name for example Speed time distance 120 2 ...
-
Macro to group and save. Closed
Hello, I need to write a macro for a workbook with 1 sheet where i need to got to data --> then select Group/outline ---> then select group wh...
