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,432 Posts: 603,045
109,432 603,045
Excel VBA / Macros (4,979/24,977)
Excel Formulas (915/4,588)
Excel General (103,300/573,064)
Excel FAQ (165/175)
Code Review (20/84)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,448 Posts: 16,570
1,448 16,570
Topics: 6,456 Posts: 28,474
6,456 28,474
Excel and/or Word Help (1,257/5,225)
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: 595 Posts: 2,414
595 2,414
Topics: 992 Posts: 6,565
Last Post: Chat Room
992 6,565
Chat Room
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: 19 Posts: 21
19 21
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 2932 users online. 14 members and 2918 guests.

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

Free Excel\VBA Help Forum Statistics


Topics: 123,635   Posts: 673,251   Members: 316,376   Active Members: 647
Welcome to our newest member, Pyro966.

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


  • zohar
    to Eliminate row needed for gapup and reoccurance function and data
    Had posted in two other groups but cant get the solution so posting here

    Respected ,
    in calculation of gapup and reoccurance,

    Is there anyway so that formulas done in a10,b10, A13,B13 & A16,b16) can be accomodated in A11, a14 & A17
    Results & formula in Row 10,13,16,.......... has to be maintained , as it is referenced by formulas in A11, a14 & A17 which complicates...
    2 hours ago
  • hillmas
    Random Unique Match from list

    I have a list of names (40 deep), and the departments that those people work in (as below) .What i would like to do is to randomly match each person with another, in a different department. So in the example below Joe Bloggs would not be matched with Tony Peters as they do the same job. He could be matched with either of the other two though. If there is an odd no. of people then the person who is unmatched would just be entered on their own eg. Joe Bloggs & MR Jones, Murry Hill & . I would like every time i run this macro, for it to match each person with a person they have not been matched with previously.
    Name Department
    12 hours ago
  • reggieneo
    find the closest match in one cell string to range of cells string (column)
    Hi All,
    Kindly assist to create or teach a suitable formula for this situation : the answer should be "Curtain_簾" (the value in C6).

    I need a formula to look for a closest string match in column C from strings in A1.
    A1 value is constantly changing or dynamic.

    I have tried index match but this is too complicated for me to crack.
    A1 CorpComm Office Curtain Project 二樓金沙中國 辦公室的公共關係部需要造窗簾 Accessories_飾品
    15 hours ago

Recent Blog Posts


There are no results that meet this criteria.

Trending on OzGrid


  • RBLearning
    VBA to count how many users and send to word
    Hi all,

    I've been working on a new userform and so far everything works out great apart from one thing. I just can't figure out how to count how many users are attending an event and send this to a word document.

    I select from a combobox a date of an event, a populated list displays (all working great) the list of guests. I then click (AttendPrintBtn) a button to print out the attendance sheet using the code below, but I just figure out the code to show how many users (brain freeze) are attending at the bottom, can someone be kind enough to help me out please?

    I'm using a comboboxes next to their name (data taken from a 'User' sheet) for me (cboAttend1 through to cboAttend5) to select if the guest have attended or not, if the guest attended then I select...
    1 week ago
  • d444nyc
    Dropbox Box selects day for entry
    Hello All,

    Absolute VBA Noob here and have spent the last week or so trying to get this to work and for the life of me I can't and I think its a bit too much for me but still something I want to know how to do as I've seen it done by somebody I used to know.

    Basically, my Aim is to have a Excel document where users will select the 'Day' from the dropdown box and it will allow them to enter sales data into that day and if the user changes to a different day it will save that information into a table on a different sheet and allow then to then access the information for that day and so on and so on. Also when the user selects a day that already had information enter it will 'pull' that information that the sheet back into the entry sheet.

    Sorry if that...
    1 week ago
  • RickSimpson
    Populate 2nd listbox by selecting first listbox
    I have a spreadsheet that contains Authors and books. I have a listbox that has authors name. I need to be able to select Author and have it return all the books that have the author on spreadsheet....
    6 days ago
  • aeonstorm
    lognormal graph

    I've been struggling with the lognormal function in excel for the past week now.

    There's a particle analysis that I've been trying to replicate in excel, using formulas, instead of probability graph paper, and so far it has been challenging.

    The data stated the following :

    Dvs (mean volume-surface diameter) = 231 um

    Dvs transformed to D50 using Hatch-Choate transformation

    log d50 = log dvs + 1.151 log2(S)

    D50 (mean drop size diameter ) = 264um

    Standard deviation (S) = 1.7

    The d50 diameter was then transformed to d16 diameter by using d16 = d50/S

    d16 = 155 mm

    This represents the drop size diameter equivalent to 0.1587 wt fraction of the dispersion....
    5 days ago
  • V31121985
    VBA for day to day activity with external run software
    Hi Gurus,

    I am trying to create a VBA for day to day activity which contains below are the follow steps.

    On running the macro I am ending up with empty excel file.

    Please guide me where i am going wrong.

    Is this possible to do with VBA?Thanks in advance.

    Vignesh V...
    3 days ago