Results 1 to 2 of 2

How to copy some columns from sheet1 to sheet2 or sheet3

Threaded View

wlarson How to copy some columns from... 09-30-2007, 08:49 AM
VBA Noob Would typing =Sheet1!A1 ... 09-30-2007, 08:58 AM
  1. #1
    Registered User
    Join Date
    09-30-2007
    Posts
    6

    How to copy some columns from sheet1 to sheet2 or sheet3

    I have a workbook with 3 worksheets. Sheet1 has 50 columns and multiple rows. Sheet2 & 3 are blank. I want the data in columns A, D, G & H to relect on sheet2. I also want data in columns B, C, E & F to reflect in sheet3. The goal is to have all data in sheet1 and any changes or additional rows added to sheet1 will automatically be added to sheet2 or sheet3. Is there a simple way to do this?
    Last edited by VBA Noob; 09-30-2007 at 08:52 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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