+ Reply to Thread
Results 1 to 12 of 12

Add row in 2 worksheets

Hybrid View

  1. #1
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Why do you need to duplicate data, it is generally totally unnecessary. Where do you want to add the Row, attach a small example workbook.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  2. #2
    Registered User
    Join Date
    10-16-2008
    Location
    Neza
    Posts
    10
    Ok, I have a list iof customers and info in the tabs of Chi and Mex. In the tab Master I have a consolidation of all my data. The tab Master has a formula to modify automatically whatever changes I make in the other 2 tabs. However, when i add a new customer in Chi or Mex, I have to copy it and paste it in Master.
    Now imagine doing that when you have 10 worksheets and many many customers on them.

    Hope this helps
    Attached Files Attached Files

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You only need one sheet of data, you can easily use AutoFilter on the countries column

+ 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. Concatenate across multiple worksheets based on variable
    By rpatton1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-09-2008, 03:35 PM
  2. Automatically format multiple worksheets
    By Kez in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-29-2008, 08:25 AM
  3. Looping through worksheets in a workbook to pull data
    By fecurtis in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-02-2008, 01:40 PM
  4. Deleting worksheets, printing to Adobe, and moving to a new workbook
    By baconcow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2008, 10:03 AM
  5. Selecting worksheets in a workbook based on criteria
    By josnah in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2008, 10:47 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