excel 03

I have three sheets: Zipcode_Funnel (list of select zip codes) Zipper (demographic output) Master (reformatted output) I want to be able to loop through my program until the cell on sheets "Zipcode_Funnel" range ("A2") is empty. Sub Zipper() ' 'Description: pull relevant demographic data on...

Hi, I have a range where I want to find a cell address based on another function, like HLOOKUP or any other. But when I use HLOOKUP function as a 'refernce' argument in Excel's inbuilt function Cell(), it gives an error. Is there a way, that I can find a cell address based on any of the...

Hello i have just joined up after browsing through the many helpful theads on the Excel forum for different parts of spreadsheet work and i have such 2 queries regarding an Invoice spreadsheet system i am working on in MS Excel 2003. The system itself includes an Invoice sheet, customer and...

This is not my code. However, I would like to use it or some variation. My Objective: I simply would like to provide either: An address, or First and Last Name ...and have the web service present results which I can extract into an active spreadsheet. Any help would be appreciated...

My objective: I want to be able to place a first and last name combination into code (in this example Alison Smith) and see if the person is recognized by the site. If "yes", I want to download the information to the active spreadsheet. If "no", then what ever the result (i.e. nothing found...

I have created an inventory excel setup whereas we have:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> Central server for storing data and each location saves the files to the same server<o:p></o:p> <o:p> </o:p> There is my computer that I...

Thank you for your help. I need to be able to pull up the below site and fill out the form. Idealy extracting the output generated. Below is what I have so far: Sub SSI_MAcRO() ' ' SSI_MAcRO Macro ' '_PULL UP FORM Dim Ie Set Ie = CreateObject("InternetExplorer.application")...

Can anyone help? Below is a basic way to find rows that match 3 criteria, work out the average to each column G to M of all the rows that match the criteria and copy and past to a repot sheet.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> How...

Thanks in advance for any help. I have two primary questions: 1. What can I add/modify to the code below to isolate the search to a column instead of my entire worksheet? 2. How can I have the replacement text only replace the variation if it is stand alone? (For example, 123 Village...

Hi, Does anyone know what code i can use under data validation to state that data must be present? Thanks

I used the recorder in Excel 07 but when someone runs it in 03 this is failing. Can someone please help. With Selection.Font .Name = "Arial" .FontStyle = "Bold" .Size = 10...

I am creating Invoices in Excel and exporting them into Quickbooks via IIF file. The total amount of the transaction has to equal (0) ........A....... B...... C 1 Quantity Rate Amount 2 _ -10__ 20.00 -200.00 3 __-5___...

I have date and time in the format "01/00/1900 7:47:41 AM" from cell F2 to F80. The date remains teh same in every cells but the time varies. I want to use a macro to convert the every date to "01/01/1900" and keep the time unchanged. I use Excel 2003. Can anyone assist me with the macro...

I was asked by a co-worker to try to print an Excel worksheet in landscape rather than portrait as he was having bother getting it to do so. I tried and could not either. The file is an old file created on an older PC. We have been printing this correctly each month. However what changed was our...

These two references aren't on another machine: IDM Error IDM Macro I am getting stuck on the command line that has items like the following with an object error: Date Time my cell 1st block of code having issues '****************Google Quotes*****************Sub AddQuote() For Each...

A gracious individual posted a solution to my problem here: http://www.mrexcel.com/forum/showthread.php?p=2172141#post2172141 However, the solution doesn't work for me. For whatever reason I can't install (MICROSOFT INTERNET CONTROLS) or (MICROSOFT HTML OBJECT LIBRARY). I need help finding out...

I need the subject name of the email to reflect a certain cell value in Sheets("Master Appraisal").Range("B65"), rather than the attachment name that goes with the email currently. Below is the code that I have to email the saved name of the attachment as the subject: Sub Mail_workbook_1()...

I have a hidden excel sheet that houses critical usage statistics that I would like to push to a sharepoint site. I simply want to relay that data to the sharepoint site... Excerpt of something I read on line: Exporting data to Excel is well-supported in SharePoint and makes graphing and...

The below code gives a run-time error 1004 (undefined object) and it is isolating the DateDiff function as the problem. What gives? Sub Speed_DoesNotWork Dim start_time, end_time start_time = Now() end_time = Now() Sheets("SpeedLog").Select Range("C1").End(xlDown).Offset(1, 0).Value =...

I am trying to get this code to spit out the data in a cell within the same workbook but a different worksheet --> Sheet ("SpeedLog") instead of the message box. The time element works fine within the routine, but I need help converting from a message box to a value in a cell: MsgBox "This...