No announcement yet.


  • Filter
  • Time
  • Show
  • New Topics
Clear All
new posts
No content found
Show More
  • Filter
  • Time
  • Show
  • New Topics
Clear All
new posts
Please log in to your account to view your subscribed posts.
Directory Topics Posts Last Post
Pick the APPROPRIATE category below to post your question and/or answer questions.
Topics: 109,603 Posts: 603,770
109,603 603,770
Excel VBA / Macros (5,103/25,464)
Excel Formulas (940/4,728)
Excel General (103,314/573,126)
Excel FAQ (165/175)
Code Review (21/87)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,455 Posts: 16,652
1,455 16,652
Topics: 6,457 Posts: 28,475
6,457 28,475
Excel and/or Word Help (1,258/5,226)
Excel and/or Access Help (2,604/11,478)
Excel and/or Email Help (1,269/5,466)
Excel and/or SQL Help (824/3,825)
No questions in this forum please.
Topics: 596 Posts: 2,420
596 2,420
Topics: 992 Posts: 6,566
Last Post: Vba Book Suggestion
992 6,566
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (504/4,077)
Test Area (459/2,379)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 20 Posts: 22
20 22
Newsletters (0/0)
Excel Blogs (1/1)
Charts (0/0)
Pivot Tables (0/0)
Solver (0/0)
Games (1/2)

What's Going On & Who's Online?


There are currently 5353 users online. 23 members and 5330 guests.

Most users ever online was 13,741 at 02:14 on February 3rd, 2012.

Free Excel\VBA Help Forum Statistics


Topics: 123,817   Posts: 674,093   Members: 316,779   Active Members: 670
Welcome to our newest member, herronjoanna.

Welcome to OzGrid!


Welcome to the community! Please take a moment to:

and if you have any questions - drop by in the HAV A CHAT forum!

Latest Topics


  • krupp825
    Dynamic AVERAGE or AVERAGEIF formula; multiple column average range
    Hello -

    I am attempting to create a dynamic AVERAGE or AVERAGEIF formula that can reference the selected vendors in F2:F5, and return their average from the main data table. Vendors in F2:F5 are subject to change, therefore the dynamic formula is required.

    Currently my attempt at an AVERAGEIF formula is not working correctly....Any help would be appreciated!

    Data table columns A-D
    • Col A = Vendor List
    • Col B-C = Numerical Figures (to average!)
    34 minutes ago
  • igotmailyay9
    Want to take my excel formula and use it in VBA? Part 2
    I wrote in a different post and unfortunately I am having trouble reconnecting into that post. It was posted on 3/20. These are the 2 photos I needed to post to go along with it that was requested....
    1 hour ago
    Code to write numbers to cells

    Iím trying to get some code to write numbers when a set of numbers are found. I have copied an Excel sheet (just a very small example of what I use so I need specific cell locations to alter the code). To make it as clear as possible if I could draw your attention to the Excel sheet. I have a step by step process of what Iím trying to do.

    Below Iím using the found number in cell B4.

    1) The code must first search the range B4:B10, B13:B19 (need to be able to change) for any sets of numbers (1-1, 20-5, 7-7 etc).

    - For each set of numbers found (B4 would be the first) the code must match cell A3 the ď1-1Ē by searching specific cells H3 and H12 (cell locations in the code so it can be changed).

    - The code also has to match...
    1 hour ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • Zacccc
    Assign Shortcut key for Macro Excel 2003

    I am a complete newbie to VBA and I've just started trying to learn it using an online tutorial.

    Following the tutorial, I've got a little macro which adds two cells in the sheet. The tutorial then gets you to set up a keystroke which will trigger the macro and this is where I'm stuck.

    The tutorial says:- From the menu bar select "Macro/Macros". A dialogue window appears and here the macro is highlighted and the tutorial tells you to click the "Options" button in the dialogue window.

    Well, on my menu (Excel 2003) there's no "Macro/Macros" so I'm going to "Tools/Macros" but there's no "Options" button there so I'm unable to assign a keystroke to the macro.

    Can anybody help...
    December 1st, 2010, 22:24
  • malani2
    Update existing data using a UserForm

    I am very new to VBA and have created a UserForm for adding data to a worksheet by basically cutting, pasting and editing codes that I have found by searching the internet. Therefore, I know that my command button codes are not very consistent. I have gotten to the point that I can add new records to the sheet, find an existing record and populating the data back in the UserForm, however I am now stuck at updating an existing record that I just found.

    Here's what I got. The cmdUpdate_Click() area is where I'm in trouble. Instead of updating the info that I just found with cmdFind_Click(), it adds a duplicate entry with the new information. (Note I deleted some code that is working fine for dropdown lists as I didn't think you needed all that info, but...
    July 13th, 2016, 16:26
  • brioche
    PROMPTLY. help repair a corrupted Excel file (2003 release version)
    help repair a corrupted Excel file (2003 release version)
    July 18th, 2018, 21:07
  • eden101
    Excel Macro - Copy worksheets from multiple workbooks
    Hi, really hoping someone can assist.

    I have a file that I want to use a table of variables set out in columns A:D to find specific sheets in multiple workbooks and copy them across. I've tried multiple methods but the limits of my VBA knowledge are starting to show.

    In the columns I have,
    A a list of the files (filepaths+filenames) I want to open
    B the passwords to open those files
    C the filenames (i.e. in order to allow ability to select workbooks)
    D the sheet names that I want to select/copy across in the files

    So, I want the macro to start at A1, open that file using the password (B1), copy a specified sheet (D1) then loop down the list of files I have.

    Below is as far as I have got - it works, bit only if I include...
    2 weeks ago
  • t0mrogers
    Need help with a formula/VLook up to pull data from a feed sheet
    Hi everyone

    I am hoping someone can help me with a problem I have.

    I have 2 worksheets and I need a formula/VLookup to pull data automatically once the feed sheet is pasted in.

    The 'Payroll' spreadsheet need to pull any exceptions from the 'Hours' sheet. (The hours exception codes are located in cells AF11 - AF20)

    So for example Tom Smith has 3 separate periods of holiday hours within the 'Hours' sheet (totalling 8 hours) and I would like this to be pulled into the corresponding cells within the 'Payroll' sheet.

    I hope I have explained this correctly and any assistance would be greatly appreciated.

    Kind regards
    1 week ago