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...
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...
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 ...
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...
Hello, can anyone help me i need a formula a*b=C
Hello, Can anyone help with a macro for hiding Row 1 if two checkboxes (BoxA and BoxB) are checked? Thanks!
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 ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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...
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. ...
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...
Hello, In my Excel Sheet Column A-------------------Column B----------------Column C 10---------------------------10------------------------3 5...
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...
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...
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...
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 ...
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...
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 ...
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...
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...
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...
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...
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 ...
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...
Hello, how to check 3columns data at 1 time.for example:- ColumnA---------ColumnB----------ColumnC 87----------------15-------------------20 10---...
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...
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...
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----------...
Hello,
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 ...
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...
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...
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...
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...
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...
Hello, I would like to know, how to copy a word and paste it into another cell using macro?
Hello Forum, I am struggling! I am trying to find a way to get a current column of data transposed into seperate columns of the same genre... Her...
Hello, I have 2 columns to transpose. The column A contains Date1..Date9..repeated. The column B contains the data I need. Country xxxx State ...
I have a workbook made that has a 'Quantities' sheet that list any number of quantities along with 'contract quantity', 'current quantity', etc. Ther...
Hello, Hie .I am working on a project in which l have to compare dates in excel and enter the difference (in days)in time in a separate column .l am ...
Hello, Can anyone tell me how to prevent the enable/disable macro box from appearing when I start Excel. Thanks Marcos