excel 03

when review formulas done by others, you have to go back to the original quoted cell to see whether they correctly quoted, is there a good keyboard shortcut to trace?I know ctrl [, and that will only get back to one of the cells, if the formula contains several cells, i.e. =A1*sheet1!B6, is...

I am looking for a macro to cut a row from a worksheet titled Open QN's to a worksheet titled Closed QN's when the drop down in column A is changed to closed, in excel 2003 (all they use at work). I found a macro on these forums that looks like it will do exactly what I want, but when I copy it...

Column A ------ acne pimple scar Column B ----- treatment surgery cure medication Column C ------ mumbai delhi chennai ahmedabad pune I want to combine the data and generate all possible combinations such as acne treatment mumbai acne treatment delhi acne treatment chennai acne...

i have 2 sheets. First sheet contains 3 columns(A,B,C) and second sheet contains 4 columns A,B,C,D, Column A is common in both the sheets. Please refer the foolowing exaxmple Sheet1 Sheet2 A B C A B C D 1 PL O 1 K 3.5 8 1 LC U 1...

I'm trying to create a macro that compares two excel worksheets and highlights the rows that are different. Basically, there is a sheet with rows of information. The first 3 columns contain various text that unique to that row of data. There could be a unique identifier for a row in all 3...

I currently have a macro that grabs information from another spreadsheet and copies that information to a tab in the workbook I am using. This information is updated every week, and copied over the old information. After the information is copied I would like a marco to grab the sum of 2 cells...

Help! I have a spreadsheet which includes columns like: January 2012 £30.00 £20.00 £48.99 and so on, for each month this year. What I need is for anything for £30 or over to be bold and in blue. I have at the moment the following conditional formatting: Cell Value is greater than or equal to...

Excel.Application.Interactive = False, prevents excel from accessing it. But this property is not working in windows7. In XP, open excel VBA. Try the following code snippet in a button click, Excel.Application.WindowState = xlMinimized Excel.Application.Interactive = False This will...

While running one of my application, excel will be opened at the middle. I need to minimize the excel and stop interacting with it, which means even if I click the excel task bar it should not open excel. It should be always in minimized state. I have an code which works in XP and is not...

Hi. My first post but I hope I can get some help from You guys :) I've browsed the forums, but it's just to much for me at this time :/ I'm an intern and my supervisior asked me to do this task - but my experience with coding is meh What I need to do is to get a sting from column x row 1 to...

Using Excel 2003, I have a workbook with 7 worksheets each containing 160 rows plus a header, each worksheet has a key field (employee number) and several unique columns. Looking for an easy to understand solution to merge the columns from all the worksheets into a new sheet - once data is...

Hi, Forgive me as this will probably be so simple for most of you but my searches haven't returned anything that I can use and my knowledge is limited to an extent in VBA. I have several lines of code that require certain rows numbers to be used: 'Copys The Row Specified...

Hey everyone. I'm currently a student and my studies have nothing to do with excel, but I have am in the middle of an internship where all I do is work with spreadsheets. Currently, I'm working with a paper company in Alabama, where they asked me to create a spreadsheet that measures efficiency...

I need to find out how to do the following. A1=15 - B2=20 = C3= -5 easy part. now i need have add 5+1 to A1 to make it greater then B2 by 1. result is A1=21 and that A1 and B1 needs to be saved. I need to auto fill for 10K entries. Does this make sense at all? Almost forgot. if C3 +1...

I have a workbook that HAS to run excel 2003 because of 2010 not being able to import the proper file extension any longer. I have an excel menu with a lot of hyperlinks to different workbooks that run fine on 2010. I need a code to open an excel 2003 file within excel 2003 when either a...

I imported data from a system which has no interface with excel (we use excel 2003) the text in the date column is like this: "16.03.2011 06:52" I'd like to trim the last 6 character, and transform the text into date formula. How can I do that? THX lekcso (Hungary)

Sir, I have developed a customized register to enter & retrieve stock information using Excel 2003. Now I would like to copy-protect that file from unauthorized use. I heard that there is a function called "fileExists" in MS-Excel. Can you please help me how to write a code that will check for...

I want to set one worksheet cell range reference to another worksheet using aspose.cells.For example i have two worksheet(wrk1 and wr2). I have some data on wrk1 and wrk2 is balnk.Now on wrk2 i want cells refrence of wrk1(like want cell reference of wrk1 sheet A1:A10 on wrk2 with same style as...

Hi guys I have un problemo!! im trying to devise a spreadsheet with vlookup basically to calculate the charges of processing someones payroll for them. The price will depend on the number of employees the client will have. These are the price listing rules i have been given...

I have a worksheet that is used to log phone calls. We can get several calls from the same person and I would like to identify the dup call. I am doing this with this statement: =IF(COUNTIF(C$2:C$1000,C2)>1,"DUP","") This works well to identify the duplicate callers. My challenge is that...