Hello, I am slowly making my way through macros, but can't seem to find the answer to the following:- I have a master sheet - which is a budget...
Hello, just want to ask how to change the date of weekends in excel 2007. please help. thanks! Configuration: Windows XP / Internet Explorer...
Hello, I have a 10 column x 500 row spreadsheet A1:J500 I would like to name ranges as follows: Range A1:J1 should be named with the content of...
Hello, I need help with a formula or macro. My situation is this: I have one sheet of data (Sheet1) with unique values (item numbers) in Column A...
Hello, could you please tell me how I get excel to automatically use a color in a cell that I write something into? The blank ones can remain colo...
Hello, I have a spreadsheet called 'TRADE' as follows: Column: A B C Sept 200 1000 ...
Hello, I'm Mike, I'm new to Macro excel I need a Macro that read from a table the name of projects and create for each project a sheet named th...
Hello, Configuration: Windows 7 / Firefox 11.0 Office 2010 Excel I often need to record UPS tracking numbers into designated fields in Exce...
Hello, I have the same problem on my browsers, ie has encountered a problem and need to close. Sorry for the inconvenience. error signa...
Hello my most humble computer users, I have a hard one here...And I think it will be harder to explane... I have an excel file that has a several ...
Hello, I need help copying the names from the master cell (A), if the other cell's (B) given names exist from the master cell, then copy to next c...
Hello, So we track sales on a weekly basis and I want to compare the text in column C to all previous weeks and if they match to turn them red to ...
Hello, How can I correct the following 2 codes (which written in the same sheet) in order to work correctly, other wise it gives me Error (debug)?...
Hello, I am trying to create a macro that can Find and Replace a variable value. For example, I want to create a cell that can have any code enter...
Hello, I have a simple question. How to delete all the rows in a spreadsheet except the first 6 rows by macro. Please reply me with an exact code...
Hello, This is my first time asking a question, so I will do my absolute best to follow and respect the forum guidelines and it's contributors. I...
Hello! I lost the sounds ONLY on my browser. Alongside this soundlessness in my browser, whenever I open a file associated with Windows Media Player I...
Hello dears, I have the following VBA code : Private Sub Worksheet_Change(ByVal Target As Range) Dim cRow As Integer If Intersect(Target, Ra...
Hello, Can anyone help? I need to run a script that will determine if a1 is blank, paste the information from a2 into the a1. If a1 is not nul...
Hello, Please, please can anyone help me, how can I move dates from ColumnA (Surname) ie various dates and date formats into the appropriate Date ...
Hello, I have a Excel file of 2 worksheets and have a list of Usernames on column B of both worksheets. Few of the usernames appear on both sheets...
Hello, I have worksheet ( AllUsers ) with two column A ( user id ) and B ( date ). Column A is a long list of user names and B is a list of dates ...
Hello, I am trying to create a macro where I want to copy a cell content from one worksheet and append it to a cell in another worksheet of the...
Hello, I have a question. I have an excel spreadsheet with 25 columns of information. There are anywhere from 3500 to 4000 rows of information. ...
Hi I have a slight problem with excel. I have inputted all my data with links on the same worksheet. Now I am trying to separate the different cate...
Hello, Hello, I have one excel column A in datasheet 1 which has a list of names. In Column A of datasheet 2 I have a much longer list of n...
Hello, I need any help if some one can help me. I make an overtime sheet in excel that allow the employee to fill in the date and time only and i...
Hello, I need help on developing a macro on grouping a set of negative amount & quantity against a set of positive amount & quantity. Using positi...
Hello, I am at the very beginning stages of trying to learn VBA in Excel 2007. I am trying to merge some cells in the next row, and I would...
Hello, I am making a questionaire. When the questionaire is complete I want to copy the answers to another worksheet then reset the answers to zero...
Hello, I used office 2003. In excell 2003 i formatted cells to dd hh:mm from dd/mm/yy hh:mm, in order to do calculations and it was ok. Now i...
I have a userform with several textboxes on it. The info that is typed into the textbox is copied into a cell in a spreadsheet where it is used to per...
Hello, I would like to figure out how to get a web address that I use to get data from the internet to always use the date that I put in cell A1. Any...
Hello, I have only worked with formulas when working with numbers but I need to know what formula I can use. I need a formula to take a column that ...
Hello, When I apply the filter option for a particual item, the last row of the data is being displayed even though it does not match the criteria. ...
Hello, Want to copy data from multiple sheet from multiple columns in one workbook can you please help me with that macro as well Pran...
Hello, I have a spread sheet created from a PDF to XLS program. I have lines in which the address appears on two lines, with the extra text fallin...
Hello, This should be simple but I can't find the solution. I need to delete rows from a spreadsheet where column A = column B. Please help. ...
Hello, I am working on log spreadsheet. The concept is to keep a log of all of our near miss activities at work like a broken chair that needs to ...
Hello, I'm trying to set a formula in below way, but it doesn't work, why?ould u plzz help? =IF(J10="Safari 4.5",650,IF(J10="Safari 7",850,IF...
Hello, This might be a long explanation, but only because I want to be clear about the problem. I have 3 different Workbooks and the names are ...
Hello, I'm hoping some of you excel wiz's can help me, I've been off the tools too long. Worksheet 1 Column A contains dates Column B contain...
Hello, I am trying to create a worksheet in excel that will allow me to add a certain amount if 2 conditions are met. So far I can only get it to a...
Hello, Configuration: Windows XP / Firefox 10.0.2 I want to insert row in excel using formula because i have dates in the and there is da...
Hello, I am trying to copy a value for from one worksheet, do some math --> say I have three values that I want to subtract separately from cell i...
Hello, Column A indicates what type of transaction I've made (ie POS/ATM/CASH/Bill Pay) Column D is the date the transaction has cleared my bank. ...
Hi. I am trying to create a macro that will create new excel files for ranges of rows in a worksheet. I want to copy the range F5:S61 and paste i...
Hello, Can anyone help me with this problem. I am updating leave availability , As soon as I enter the name in one worksheet the other workshee...
Hello, Sorry the title is really vague, it's hard to describe with a limited number of characters. I have a column (C) which contains a full li...
Hello, I've created a Macro within Excel that is supposed to Delete, Formulate and Sort data.. I've managed to get the Macro to the point where it...