+ Reply to Thread
Results 1 to 5 of 5

Formula repopulating macro Help

  1. #1
    Registered User
    Join Date
    01-08-2014
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Formula repopulating macro Help

    I am trying to create a macro which will start in E2 with
    =IF(Dealers!B2=930,Dealers!A2,"") and continue down to E26 and the Formula would end there with
    =IF(Dealers!B26=930,Dealers!A26,""). This is what I have so far.

    Please Login or Register  to view this content.
    This however gets stuck in a loop and I have to force excel to shutdown or it runs forever. Also its just pasting the same formula into each cell and not changing it to correspond with the following cell. Any help with this would be great

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Formula repopulating macro Help

    Try:

    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    01-08-2014
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Formula repopulating macro Help

    OllyXLS that worked extremely well thanks. However as I tried to extrapolate that to the next column it did not work. Example:

    Please Login or Register  to view this content.
    While Column E is B2:B27 Column F needs to be B28:B51. With the above code though Column F restarts at B2. Do I just need to change the RC2 and RC1?

  4. #4
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Formula repopulating macro Help

    Change it to:

    Please Login or Register  to view this content.
    This returns values from the range B28:B53 in Column F.

  5. #5
    Registered User
    Join Date
    01-08-2014
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Formula repopulating macro Help

    Thanks OllyXLS

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Macro: Plugging an Array-Formula into a Cell and Dragging Formula Down Columns
    By Brianandstewie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2013, 02:57 PM
  2. Replies: 1
    Last Post: 01-27-2013, 11:05 AM
  3. Macro: Applying formula to multiple cells in excel (formula editing)
    By city in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 06:41 AM
  4. Repopulating the Combo boxes from Access database
    By shivboy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2006, 05:38 AM
  5. [SOLVED] Formula expected end of statement error, typing formula into cell as part of VBA macro
    By DavidGMullins@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2006, 03: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1