Excel Forum
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 ...
-
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...
-
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...
-
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,...
-
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...
-
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...
-
ms excel help [Closed]
Hello, can anyone help me i need a formula a*b=C
-
VBA: If 2 checkboxes checked, hide row [Closed]
Hello, Can anyone help with a macro for hiding Row 1 if two checkboxes (BoxA and BoxB) are checked? Thanks!
-
Excel Macro help Required [Closed]
Hello, I have an Excel Workbook that has 140 names/ID's that have different Composite roles agianst it, I want to create a macro or run a macro...
-
excell Macro Help Required [Solved/Closed]
Hello, I have 3 Excell Workbooks, i need to create a master sheet, but when ever i update the master sheet the data updated shouls reflect in...
-
Moving tabs from 2007 excel to 97-2003 [Closed]
Hello, I need to copy many tabs in a 2007 excel workbook to 97-2003 excel file and I am getting following message: Excel cannot insert the...
-
sheet creating macro [Closed]
Hello, I want a macro which can collied sheets from different workbook and make one excel and the sheet sequence can be selected...
-
Excell Macro Help [Closed]
Hello, I am wanting to create an excell macro - that filters out the names in 1 column of the spread sheet - I pull a report everyday that...
-
Letting the user specify which sheet my VBA [Closed]
Hello I have been using many of your very useful articles in the past and they have allowed me to solve many problems. However I am now Very stuck...
-
Complicated Excel Formula Problem [Closed]
Hello, I need to create a user form based on several columns of data and what ifs and calculations. In my user form the user will enter in a...
-
How to comp more than one coln in a excel [Closed]
Hello, i have two work sheets which have 4 columns of data in sheet. i need to compare the sheets. But the data's are in the different rows...
-
EXcel Del text - other than-start letters MB [Closed]
Hello, Input Excel file with one column. Conditions I would like to delete text other than which is having starting letters of "MB" or...
-
Need help in Excel Macro [Solved/Closed]
Hello Ivan, Ive' been reading a lot of your answers and i'm quite facinated of your skill. I need to create a macro for one of my project and...
-
using access macro to update sheets1, 2, 3, i [Closed]
Hello, I have an access macro that uses several queries to copy data into excel. my problem is that i can only get the macro to perform correctly...
-
Excel 2008 [Closed]
Hello, I have a order form in excel 2008 that lists all my stock the unit price and the total price, I then have a Qty column, the idea is that...
-
Excel Help [Solved/Closed]
Hello, Ok am not that experienced with excel, so if any one can helo would be great. I have a huge spreadsheet and i am constantly updating...
-
Checking a row of cells and reporting [Closed]
Hello, I have an audit spreadsheet listing rooms by the building its in, the room number and a series of answers to questions afterwards...
