Excel Support

Hi,

I am looking to build a macro that examines B87:B(rest of the coloumn) and if the value is #N/A, hides the row. There will be new information recuring every month so it should be able to unhide, calculate and hide again.

I hope someone can help me with this problem:)

Thanks in advance!

/A

I have a number of Access Databases. I create queries in Access, then use those queries to import data into a tab in excel. I have multiple queries and multiple tabs in a single workbook.
From time to time, I change the selection criteria for some of the queries. Inside the worksheet, I use Vlookup and Hlookup formulas to gather the data I want, so the import tab name must always remain the same. Each workbooks has maybe 10 to 15 tabs with these lookup formulas.
Is there a simple method to manage the changes in the queries? I currently I have to rewrite the query in access then try to modify the tab it relates to in the excel workbook.
Paul Merrill

I could really use a macro that combines multiple (single-worksheet) workbooks into a single workbook, with the worksheets the source workbook becoming individual worksheets in the new workbook. The icing on the cake would be having the source workbook(s) file names become the tab names in the new combined workbook. I searched the web and found one, but it was not very useful.

Also, what would be the best way to get some (entry-level) training in using the VBA editor?

Thanks,

Hi,
I am working on an internal audit of our accounts receivable activity where I would like to match our billings with the customers payments, both of which are referenced by an order number. The twist is that the order number assigned to the billings and payments is listed multiple times in each schedule, each time referring to a different item on the billing and payment. I would like to have a lookup that first finds the order number, then finds the item number and returns the payment data for the item, so I can determine the differences between the amounts billed and amounts paid. Here are the details:

Billing information-
Order No. Item No. Description Invoice No. Invoice Date Lines Billing

Hi,
I copied this Macro from another forum to enable me to hide rows with specific columns with zero values in the cells. The orginal macro apprears to apply only to a single column of cells. What I would like to do is have Excel hide the rows that have zero values in 2 columns in the same row, ONLY if the values in both cells are zero. Can someone help me out with this one? This will be a great help since I produce financial statements for several different departments of a company.

Thanks so much Jeff for setting this up. I have attended many of your CalCPA classes and have benefitted greatly from them.

Sub Hide_rows()
Dim LastRow As Long
Dim Rng As Range
LastRow = Range("A65536").End(xlUp).Row '
Set Rng = Range("A1:A" & LastRow) '
Application.ScreenUpdating = False

I am new to Excel Macros, but I think I understand how they work. In short, it appears that, when I run the Macro, part of it works, but part of it doesn't.

I go in and start recording the new macro, then I go through the steps, then I stop recording. When I run the macro, it does most of my steps, but not all of them.

I can send the Excel file on request, but let me tell you how it's set up.

I have a template where I record all the food I eat. I have summary pages in the beginning sheets and a sheet for each day of the week. I made the macro to clear out the food template at the end of the week so I can start a new file for the next week. When I run the macro, it tends to clear out the Monday through Saturday worksheets, but not the Sunday worksheet.

I had macros as part of my Excel 2003 workbooks. Now that I am using Excel 2007 I keep getting the annoying macro warning message. How do I make them go away permanently?

Hi Jeff,

During one of your classes I learned how to do custom Menus in Excel 2003. I have recently migrated to Excel 2007. I have been unable to figure out how to create custom menus in 2007

Thanks,
John

Excel 2007 tables by default create a named range. Further, new records entered directly under the table cause the table and its related named range to automatically expand to include the new data. Thus, any formulas or pivot tables or charts that are based on the table's name will automatically include the newly inserted data.  This is a wonderful feature of Excel 2007 tables!