macro and formula

Hi, I have a macro that pulls in data from many workbooks. If there is no data in one of the workbooks the macro will not continue. Is there a loop or some other coding I need. The code for one of the worksheets is: (I am new to excel and know there must be parts that can be deleted in the...

Hi Team, I'm attemping to assign a Macro that has multiple parameters to an image in Excel 2003. It works with one parameter, but as soon as I add a second it can no longer find the macro. Example of what works: 'MacroName("Parameter1Value")' ' Function to open the correct UserForm. Sub...

Ok everybody this is my first post and I am completely stumped! I work for a company where we track our employees times by using gps time stamps through an iphone application. Here is the way I invision the spreadsheet working. The Meta data from the gps pings from the employees phones comes...

Hi colleagues, the context of my question is "Invoice Numbering". I would like to have a sheet where I can have an incremental number. Every time I run the macro it should strikeout the last number and it provides me an increemental number. I used such a sheet in a previous job and I cannot...

There are two separate reports as two separate Excel file. The old one is on a server and the new one is pulled once each week from a system where data is updated all the time. Column G is added to the new report as a Insert Column function. However, 100s of new rows are added each week. So...

Hi Team, I'm looking one typical formula to get the required information this can be done by using Pivot Table but looking in formula how can we integrate this requirement. Please look into below table and also out put table and I need to get the average of P1, P2 & P3 based on model &...

Hello, I have very big problem and i can't find answer for it. Maybe You can halp me. 1. In Sheet "Intro" I have row (5), in wich are formulas: (i) C5(='Sheet1'!$A$1); (ii) I5(=OFFSET('Sheet1'!$A$1;17;1;1;)); (iii) In this row also is number of my tables line, i. e B5(=1). This number "1" is...

Hi Guys, I am trying to select multiple pivotitems in an OLAP cube pivot based on a dynamic list. The code is below. when I run the macro and loop is completed, one the last item on the list is selected. I want all the items on the list to be visible. Was wondering if anyone can please fix the...

I work for Capital One as an account auditor, I get sheets of customer name, phone #s, and account numbers. What I need to do is make a sheet with ONLY account numbers and phone numbers. Most of the time there are many numbers on the account and I only need the last number or column F Example...

Hi, I'm new to this forum so apologize in advance if I'm screwing up any protocols. I have a spreadsheet whereby I'm trying to hide/unhide rows based on a formula result. The formula is an If statement that looks at a number of fields and provides either a "YES" or "NO" result. The macro was...

I am looking for a Macro that will make the process in the document as simple as possible. Its currently a lot of manual work and I would like to automate the process. The document involves a two tables in a Matrix form input Volumes and Budget and an out Actuals. In the same document we have...