+ Reply to Thread
Results 1 to 3 of 3

Help with looping formula needed

  1. 05-27-2019, 12:24 PM #1
    dangorka
    dangorka is offline
    Registered User
    Join Date
    01-09-2016
    Location
    Poland
    MS-Off Ver
    2007
    Posts
    6

    Help with looping formula needed

    Hi everyone

    I have a quite simple Excel sheet with two tabs in it (Sheet1 and Sheet2)

    Sheet 2 contains numbers in row Q and hyperlinks in column T
    Basically any time when there is a number "1" in row Q, macro should copy paste hyperlink from reflective row to A4 in Sheet1, call few macros and then move back to Sheet2 and proceeds to another row with number "1" in row Q

    So far I came up with this but I am not sure how can I add copy-pasting from one sheet to another into loop

    Please Login or Register  to view this content.
    Will be grateful for any help!
    Reply With QuoteRegister To Reply
  2. 05-27-2019, 01:02 PM #2
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Help with looping formula needed

    Cross-posted at: https://www.mrexcel.com/forum/excel-...a-formula.html
    When you post in more than one forum, always include a link to the other forum. In this manner, members won't waste time working on a solution if one has already been found on anther forum.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  3. 05-27-2019, 01:03 PM #3
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Help with looping formula needed

    It will be something like 

    Please Login or Register  to view this content.
    Martin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Looping through checkboxes - HELP NEEDED
    By mikebowman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2019, 07:27 AM
  2. Looping help needed.
    By vibajajo64 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-15-2018, 08:28 AM
  3. [SOLVED] NON-VBA: FORMULA NEEDED - Looping through string and stop on non-numeric
    By dluhut in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-09-2014, 12:37 PM
  4. [SOLVED] Looping Help needed in Recorded Macro
    By zaska in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2012, 11:03 PM
  5. Simple Looping Example needed
    By msmithdynamicsgp in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2011, 09:45 PM
  6. A spreadsheet for a coil winder - looping help needed!
    By HankMcSpank in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-09-2009, 09:46 AM
  7. Help needed - seriously (looping? macros? formulas?)
    By jarski in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1