+ Reply to Thread
Results 1 to 2 of 2

How can edit subsheets directly from Master Table?

  1. #1
    Registered User
    Join Date
    07-14-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    1

    Exclamation How can edit subsheets directly from Master Table?

    So I have around 20 worksheets with the same columns (They are product reference lists for different country's ) I have made use of power query to merge them all together to one big one where I can filter whatever I need to look for and see what countries have that reference. The problem is when I need to either add a new product or eliminate a product from all of the countries or sometimes just some. I would like to know if thereīs a way I can do this from the master table as right now if I add a new row or eliminate one when i press refresh it will go back to how it was before as I havenīt deleted/added the row from every individual worksheet.

    Thanks.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: How can edit subsheets directly from Master Table?

    .
    If you are searching for a single unique term, you can do that for the entire workbook then when found you can use

    ActiveCell.EntireRow.Delete

    Keep in mind, if the term you are searching for exists in any other area that you DON"T WANT DELETED, the code will delete that row as well.
    Make certain you are searching for a single unique term.

    An example would be: the product order code which is different from all the other product order codes.

+ 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. Replies: 0
    Last Post: 09-19-2013, 12:29 PM
  2. Distributing Information from Master to Subsheets
    By Bonzilla in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2013, 08:42 AM
  3. [SOLVED] Edit Multiple Excels To Match Master Template (I.E. Table Headers, Sheet Name)
    By ub3rm0nk3y in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-30-2013, 03:23 PM
  4. Automatically create subsheets based on master sheet category type
    By upsidedownjim in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-10-2013, 02:21 PM
  5. Replies: 7
    Last Post: 03-02-2013, 07:05 AM
  6. Edit directly to cell
    By Kennyc in forum Excel General
    Replies: 2
    Last Post: 04-27-2012, 07:24 AM
  7. [SOLVED] Auto copy data to Master sheets after I enter data in subsheets
    By Uzwal Gutta in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 05-13-2010, 04:40 AM
  8. Macro to edit directly in cell
    By nazimscr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2009, 11:25 AM

Tags for this Thread

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