Results 1 to 3 of 3

While in loop Change value in Cell and copy down

Threaded View

  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
« 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