Excel Forum
-
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...
-
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 so ...
-
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 all t...
-
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 sheets...
-
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 manually. Kin...
-
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 gives th...
-
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 des...
-
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 pipe di...
-
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 contain...
-
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 "SM" an...
-
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 it i...
-
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 on ...
-
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 whe...
-
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 it. ...
-
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 detaling...
-
Excel Help [Closed]
Hello, In my Excel Sheet Column A-------------------Column B----------------Column C 10---------------------------10------------------------3 5...
-
Excel macro: copy between sheets [Closed]
Hello, I have sheet1 and sheet2. I want to create a macro: -copy Bx:Dx from sheet1 to sheet2 Bx:Dx -where x from 6 to "get count row number, w...
-
Excel loop, inner loop [Closed]
Hello, I have an excel file that has data in a cell that looks like "abcd-123456-efghijk-7890". My problem is that i have about 2000 of this type of...
-
Macro problem!!! [Closed]
Hello, Can anyone help me with the following problem I need to build a macro that can do these steps. step 1: the macro has to start when cell B...
-
any one know about graphs on excel? [Closed]
Hello, How on earth do you convert data from the new 2007 windows xp thing in to a normal bar graph. i need the x axis to say 'number of words in a ...
-
I can't browse any part of microsoftwebsite [Closed]
Hello, I have problem with my browser, I can't open any part of microsoft website in spite of I can open other website. I have the same problem in fi...
-
I need help creating an Excel formula [Closed]
Hello, I work in Human Resources and need to create a formula for Personal Time Off. The employees accure PTO time at the rate of 0.46 per regular ...
-
Naming Cells [Closed]
Hello, TIA: I have 16000 data pairs in each delimited text file.. Which l have quite a lot of.. and l have the wriitten the code for opening the fil...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- How to Disabled Write Protection on a USB
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account
- How to Get More Followers on Instagram
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Get Free Diamonds in Free Fire