excel 03

Hello All, Thank you in advance for any help offered on this most frustrating problem. Details I have a Userform with a listview on it. The user selects a row using the Up+Down arrows, then presses Enter to add detail to that row. This shows a second userform with controls for the info. My...

hiii, Anyone please help me with this...I am pretty new to Excel macros. I have two different workboooks with approx 15 columns and 50k rows in one workbook and 10columns and 1000 rows in another workbook and only 2 columns(partnumber, changelevel)are in common. So i want to pull two reports...

Hi, I joined this forum hoping someone will be able to stop me tearing my hair out! I have just completed vistor surveys of nature reserves and am looking to do some simple analysis of the results using excel, this is fine until i reach a few of our questions. We were asking what improvements...

Having some issues with the conversion of this formula is there another way to do this =_xlfn.IFERROR(_xlfn.AVERAGEIFS(H:H,A:A,J3,B:B,K3,C:C,L3,D:D,M3),"") the if error function changes and error to a blank but excel 03 doesn't recognise the if error and averageifs function.

Hi, I have this file like: Column1 Column2 Column3 111 A11 011 111 A11 012 111 A11 013 ---------------------------- 111 B11 012 ---------------------------- --------------------------- 14213 XXX1 011 14213 XXX1...

Hey everyone, thanks in advance for your help on this. I am not sure that I phrased this correctly in the title, which may be why I haven't been able to find an answer anywhere else. I am not sure if it is even possible. Essentially, I have two lists -- one is Division, the other is Region; I...

The below code snippet only handles one value for one cell: StrURI = Range("F2") In the same column ("F") I have 800 values that I need to cycle through. Any help would be appreicated...

Const strURI As String = "http://www.google.com/#sclient=psy&hl=en&safe=active&source=hp&q=site:+squidoo.com+%22space saver treadmill%22&aq=f&aqi=&aql=&oq=&pbx=1&bav=on.2,or.r_gc.r_pw.&fp=d69918eb06677aa8" This code snippet deals with one single hard-coded http, but I need the code to reference...

So this code works fine (it was provided by another member here at Mr.Excel.com): Sub GetTextOrHtmlFromIe() 'Standard module code, like: Module1. Dim bln As Boolean Dim NPOFile$, myFile$ Dim ie As Object, objDoc As Object, f As Object, fs As Object Const strMsg As String = "To get a text...

Hello, I am working with Excel 2003 on Windows XP. I have a master workbook with 14 different worksheets and I am trying to create 7 different workbooks from it; two sheets per workbook. To give you an idea of what I'm trying to do, I've outlined 8 of the worksheets below: Equipment...

I have an Excel 2003 workbook that has many buttons on different worksheets within it and I was wondering if there is a way to tell which button was clicked?

Hi, I have two sheets named as sheet1 and sheet2 in the sheet1 i have two coloumns Column A contains Emp IDs and Column B contains Stationary taken. Column A and B will be updated whenever someone will take any stationary. on the second sheet (Sheet2) in the Column A i have the unique list...

Hi, I've just upgrade to 2007, to encounter numerous problems. The most frequent error ir the eomonth function being replaced wtih #N/A in files saved in 2003 format due to the need to distribute the file to other people. I believe this is because there is no separate need for the Analysis...

Hello, I am new to this site and Excel VBA.. Thank you all in advance for your assistance. I am trying to automate the workflow of a spreadsheet in my business. Currently operators fill out a spreadsheet (template) and manually submit this to the reviewing team, who review and confirm the...

Hi, Depending on the text in column B I need to assign values to column D. these values need to be incremental. so if B1 = A it is given the value 4, and then if B5 = A it should be valued as 5 and so forth, I have got the following code that assigns the value but it doesn't add as I need. To...

Using vba can I code so that it will find theearliest date and the latest date in a column and then return this to a cell as the text 'dd/mm/yy to dd/mm/yy'. Guess this is available but until now I have done this manually after a macro some one else wrote has finished and they have left so...

Hi, I am looking to copy data from one worksheets to another. I will be filtering on column "U" using an array to show the 'to be filtered by' data. The code I have for this is: For d = 1 To 21 Worksheets("Raw Data wo ACT").Activate Range("U1").Select Selection.AutoFilter Field:=21...

Hi, I am trying to delete any duplicate row based on column "C" data. I have sorted the data so the data is sorted by "C" the account number and then "E" the date with the eldest first. When I run this code it does not pick up all the duplicates and does delete some that are not duplicates...

I am having the hardest time trying to figure out how to show my monthly numbers from a budget detail worksheet onto the budget summary worksheet. Here is a sample of what my summary worksheet looks like: CurMnth YTD Budget Air Surv 10 245 816 Enf Cas 24 36...

Hi, I've been scanning the web for a solution to my problem and what help I have found I could do with it expanding a little. Right, I'm after inserting the current logged on user's name into an excel cell. It may sound simple enough to some of you pro's but if you could help with the...