Excel Forum
-
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...
-
Template sheet with changing variables Closed
Hi, I am working on a project where I need to make county data sheets for an entire state with different data in each because of the changing data of...
-
Having Excel IF formulas print text and calc Solved/Closed
Hello, I am trying to get Excel IF formulas to print text and calculation based on true/false. Such as, if I have some dates, and I don't need to s...
-
Excel Formula Closed
Hello, I wonder if somebody can help me with a pretty basic (I think) Excel formula. I would like for it to go through column A and search for a n...
-
Dynamic seletion of rows Closed
Hello, I need to select the entire row based on cell value. Ex: Students and marks is avialable in one excel sheet. I need to display the students ...
-
excel macro to copy cell content highlighted Closed
Hello, I am trying write a macro assigned to a button that copies the content of a cell into highlighted cells. Please can anyone suggest a soluti...
-
how to check 3columns data at 1 time Closed
Hello, how to check 3columns data at 1 time.for example:- ColumnA---------ColumnB----------ColumnC 87----------------15-------------------20 10---...
-
inserting customer address to Excel invoice Closed
Hello, I have designed an invoice template in Excel and want to be able to import the customer name and address fields automatically (currently hel...
-
VBA code for copyg rows Closed
Hello, m gettg problm while copyg rows from one Excel sheet to another sheet. plz its urgt me if anybody have sol yhn plz snt me. my problm is:- i...
-
how to solve this problem in Excel Closed
Hello, how to check 3 column data together and it has to check the same 3 column and it has to give the result example ColA-----------ColB----------...
-
vba conditional formatting Closed
Hello,
-
browser icon buttons Closed
Hello,i've been trying to get rid of the browser icon buttons like forward, back, mail, fav., n so forth. every time i use customize n move them over ...
-
help with excel formula Closed
Hello, i am working on a spreadsheet that keeps track of machine hours. i need help with a formula that when themachine hours gets to 3000. the numbe...
-
Copyspecified data from a ldif/txtfile2 Excel Closed
Hi There Good Day! I am having ldif file and and i need to populate an excel workhseet with some selective data from the ldif file . Basicall...
-
whatisthe formula to get higer number inexcel Closed
Hello, Hello, i'm jai krishnan im having a big problem in excel 1. in column A i'm having set of numbers in Column B also Having some set of numb...
-
Excel Macro- Need Help Closed
Hello, Could anyone please help me with Excel Macro logic/ or if more generous with macro code for the following scenario: I have a Dashboard with...
-
Need Help in Excel Closed
Hello, I am SHANU I will explain what i want to do please help me out if any know about it I have 2 Sheets in Excel in Sheet 1 the names are retu...
-
creating a macro Closed
Hello, I would like to know, how to copy a word and paste it into another cell using macro?
