Announcement

Collapse
No announcement yet.

Forums

Collapse
  • 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: 110,055 Posts: 605,870
Last Post: Loop code help
110,055 605,870
Mumps
Loop code help
by Mumps
Sub-Forums:
Excel VBA / Macros (5,450/27,108)
Excel Formulas (1,000/5,019)
Excel General (103,344/573,237)
Excel FAQ (165/175)
Code Review (22/95)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,468 Posts: 16,745
1,468 16,745
Topics: 6,461 Posts: 28,485
6,461 28,485
Sub-Forums:
Excel and/or Word Help (1,259/5,229)
Excel and/or Access Help (2,606/11,479)
Excel and/or Email Help (1,270/5,468)
Excel and/or SQL Help (824/3,829)
No questions in this forum please.
Topics: 596 Posts: 2,422
596 2,422
Topics: 992 Posts: 6,573
Last Post: Word Play
992 6,573
Raina
Word Play
by Raina
Sub-Forums:
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (504/4,083)
Test Area (459/2,379)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 20 Posts: 23
20 23
Sub-Forums:
Newsletters (0/0)
Excel Blogs (1/2)
Charts (0/0)
Pivot Tables (0/0)
Solver (0/0)
Games (1/2)

What's Going On & Who's Online?

Collapse

There are currently 5299 users online. 19 members and 5280 guests.

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

Free Excel\VBA Help Forum Statistics

Collapse

Topics: 124,288   Posts: 676,326   Members: 317,592   Active Members: 480
Welcome to our newest member, shernel07.

Welcome to OzGrid!

Collapse

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

Collapse

  • shernel07
    Default VBA to copy cell value from the last row of the workbook to another workbook
    shernel07
    Hi there,

    I have two workbooks eg. Data.xlsx and Final.xlsx

    In Data.xslx I have the sum of A2:A3 in cell A4 ( I want the macro to always choose the last row in column A as the last row will always change )

    Now I need a macro code to copy the data from cell A4 and transfer it to the Final.xlsx workbook in cell A4 for example.

    P.S I need to data to get transferred not the formula present in A4.

    Can you guys help me in this? Thanks
    2 hours ago
  • koubor
    Simulate the touch Enter in CMD (command Windows) with vba
    koubor
    Hello, I would like to know if it's possible to simulate the touch "enter" on the CMD with Vba.

    I have a script opening the command Windows and I have to press "enter" to continue this script. I can't change this script so I would like to create a vba script to simulate this key.

    I know we can launch some script cmd.exe with vba, I know we can simulate the touch "enter IN vba, but I didn't found anything about simulate the touch Enter with vba in the cmd, or maybe just on the computer?

    Thanks in advance,
    Koubor...
    2 hours ago
  • NikyShah
    Macro to create PDF files from word documents
    NikyShah
    Hi there,

    I am looking VBA code to create macro to make PDF files by searching word in that current page. i have word documents with 40 pages (invoices of different companies on each page). I want to search first company name and then to make pdf file of that current page. the reason i do not want to add From and To as sometimes any company has no invoice then i get word file with different numbers of invoices. I even try to remove From: and To from the code but it is only making PDF of first page. Thank you.

    Regards,
    Niky
    4 hours ago

Recent Blog Posts

Collapse

There are no results that meet this criteria.

Trending on OzGrid

Collapse

  • Restrictedz
    Reference/copy data from another workbook based on another cell's value
    Restrictedz
    Hi,

    I have the following 2 workbooks:


    The aim is to be able to click on the command button, which everytime when clicked (a check is ran that checks whether there is a cell within workbook 'Book1_Adventure' with the value of "Not yet activated", and if so, obtains the values from both 'foo1' and 'foo2' columns of the same row, and dumps these two values into the cells G5 and H5 within workbook 'Book2_Adventure'.

    I would presume a mixture of VLOOKUP, offset, and perhaps Range.Copy and PasteSpecial, or is there a more efficient way to do this?


    So far, my current solution is to ask the user to select the range which they want copied, but this is very inefficient and I thought a button that automatically searches and...
    2 weeks ago
  • NGM
    Code Checking if Workbook is Open is not Working
    NGM
    Hi all

    Here is my code, but the AlreadyOpen is not being turned to True if the workbook is open.

    Code:
        '   The code below is from the following sources:
        '   https://www.ozgrid.com/forum/forum/help-forums/excel-general/31023-open-workbook-if-closed-close-workbook-if-open
        '   https://www.encodedna.com/excel/how-to-open-a-file-dialog-box-in-excel-using-vba.htm
        AlreadyOpen = False
        For Each wb In Workbooks
            If wb.Name = "Job Expenditure Review.xlsm" Then
                AlreadyOpen = True
                Exit For
            End If
            With fd
                .Filters.Clear      ' Clear all the filters (if applied before).
                ' Give the dialog box a title, word for doc or Excel
    ...
    2 days ago
  • willianrc
    List (Sort by/ Filter) birthday of the month in .txt file
    willianrc
    Hello folks,
    I have a little problem here, I would like to filter out the birthdays of the month of the listbox, and I would like to hide the symbols "|" of the listbox and keep only in the .txt database. I would also like the EDIT, DELETE buttons to work.
    Follow the code so far and the download link. Thank you very much.
    Code:
    Option Explicit Private Sub UserForm_Initialize() With ComboBox1 .AddItem "01 - January" .AddItem "02 - February" .AddItem "03 - March" .AddItem "04 - April" .AddItem "05 - May" .AddItem "06 - June" .AddItem "07 - July" .AddItem
    ...
    2 days ago
  • JoshDeM
    Return to sheet after a macro that adds sheets is run
    JoshDeM
    Hi Everyone,

    I have a macro that adds new sheets depending on the previous name of the previous one. So here we have day shifts and night shifts so each day has 2 sheets allotted to it. There is a template sheet that this macro copies and uses to make the new ones. It looks at the previous sheet name
    (ex: 06-17-2019 DS). This is for June 17th Day Shift. If I run the macro it will make a sheet called 06-17-2019 NS for June 17th Night Shift. It will run for as many days as I tell it to (this is referenced in another sheet in the workbook).

    My problem I'm having is that I want it to automatically open the proper sheet once it is done running. If I run the macro for "7 days" then it will open up on 06-24-2019 D. But I want to call this days shift. ...
    2 days ago
  • Desauv
    Max function + Partial criteria
    Desauv
    Hi

    Let me see if I can explain what I'm trying to achieve here.

    I'm trying to find the max value in column C based on several criteria. But the max value should repeated in those rows, where the criteria are met.
    Column A, B, C is how the data is shown in my file. The other column is only for explanatory purpose.

    In range A2:A5 the criteria is the same, however the values are different in column C. The max value in range C2:C5 is 100519, and should therefore be repeated in A2:A5.

    Column F is the output/result.

    ...
    5 days ago
Working...
X