+ Reply to Thread
Results 1 to 6 of 6

Make changes only in listed sheet

  1. #1
    Forum Contributor
    Join Date
    02-13-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    140

    Make changes only in listed sheet

    Hi,
    In attached file in Main sheet, I have list of sheet names.

    i want to perform few actitivities only on those sheets.

    for E.g. Repalce cell No.B6, add d10+e10 etc etc.


    can any one provide code example. all these functions to be peformed only in listed sheets in Main sheet
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Make changes only in listed sheet

    Give this untested code a shot.

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    02-13-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    140

    Re: Make changes only in listed sheet

    I tried bellow code
    Please Login or Register  to view this content.

    It shows compile error in line With

    ws.Name


    Pls note:

    my below code should execute in all sheets listed in Cloumn A of Main Sheet

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Make changes only in listed sheet

    Please Login or Register  to view this content.
    Last edited by shg; 08-10-2019 at 03:03 PM.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Contributor
    Join Date
    02-13-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    140

    Re: Make changes only in listed sheet

    Tried this

    Please Login or Register  to view this content.
    but replacing only in last sheet

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Make changes only in listed sheet

    Please Login or Register  to view this content.

+ 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. Hide worksheets listed in one sheet
    By Eremit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-13-2019, 04:52 PM
  2. Replies: 4
    Last Post: 03-31-2015, 11:40 AM
  3. MAcros for Copying listed to one sheet
    By cutelebel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2014, 10:11 AM
  4. Transcribing specific listed data from one sheet to another
    By Groovicles in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2013, 10:13 AM
  5. Replies: 1
    Last Post: 06-23-2012, 03:40 PM
  6. Copy from one sheet to other - only listed data
    By EggHarbor1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2009, 01:00 PM
  7. make a mailing list that sends only one piece of mail to each couple listed
    By ebaammo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2007, 12:16 AM

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