+ Reply to Thread
Results 1 to 3 of 3

While in loop Change value in Cell and copy down

  1. 12-23-2020, 12:58 AM #1
    Grahamfeeley
    Grahamfeeley is offline
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    While in loop Change value in Cell and copy down

    First of all Merry Xmas to all you ExcelCoders and hope you keep safe...
    Now in saying that I would like some help
    I am looping in a folder and changing the Sheetname and this macro works fine
    However I would like to add a formula in this macro as well
    I have attached both sample macro (with the changes I would Like and one of the files)
    Regards
    Graham
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-23-2020, 02:35 AM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: While in loop Change value in Cell and copy down

    Please try

    Please Login or Register  to view this content.
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 12-23-2020, 02:42 AM #3
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    15,026

    Re: While in loop Change value in Cell and copy down 

    Please Login or Register  to view this content.
    Edit...see Bo_Ry got it while I was posting...
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    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. Insert lines at change of data and add sub totals to copy to new tab (do through a loop?)
    By theglitch in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-01-2019, 05:07 PM
  2. [SOLVED] Loop until cell values match then copy, move to next cell and loop and copy again
    By potga in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2016, 08:51 PM
  3. loop change value for same cell
    By DavidRoger in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-03-2015, 03:30 AM
  4. Loop Through all Worksheets, Change cell Value based on another conditional cell
    By Spswytch in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2015, 12:01 PM
  5. VBA to copy data with each change in reference number, save & loop
    By Marijke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2015, 10:23 AM
  6. Loop - change value, calculate formulas, copy to new sheet, rename
    By gmn734 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2013, 11:00 AM
  7. Copy cell values until change of value with loop
    By sdadswell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2011, 08:40 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