+ Reply to Thread
Results 1 to 3 of 3

Duplicating Data on a different sheet

  1. #1
    Registered User
    Join Date
    09-23-2008
    Location
    London
    Posts
    2

    Duplicating Data on a different sheet

    Hi,

    I have a macro question. I have 10 rows, and in column A I insert the data A1-A10 in each column consecutively. Then in column B I put data at random, e.g B12, B3, B144, B1, B3, B45 etc. If I run a macro in the same workbook but on a different sheet I can get column B to repeat the order exactly. But if I muddle the A column in sheet 3, so in A1 I write A5, in A2 I write A1 etc, the B column repeats the information from before.

    What I want it to do is to read what’s written in column A and respond accordingly – e.g if in sheet 1 the data A1 has the data B12 next to it in the B column, then wherever the data A1 appears on sheet 3, the data B12 will appear next to it. Does this make sense? And can you help? I have attached a relevant spreadsheet.

    Thanks,

    Graeme
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862
    Hi Graeme ... try this:

    Please Login or Register  to view this content.
    Note that this relies on consecutive data with no blank cells in col A; if you need something more robust, then use specialcells instead of Range("A1").End(xlDown).

    Hope that helps. MM

  3. #3
    Registered User
    Join Date
    09-23-2008
    Location
    London
    Posts
    2
    Thanks Matrix Man, I'll give it a go.

+ 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. Gathering and listing data from another sheet
    By Jonibenj in forum Excel General
    Replies: 10
    Last Post: 10-26-2008, 09:55 AM
  2. Replies: 3
    Last Post: 02-13-2008, 06:28 PM
  3. Macro to Search, Copy/Paste onto New Sheet
    By JADownie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2008, 04:57 PM
  4. Searching for a sheet and using data from the matching sheet.
    By meacho in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-06-2007, 09:51 AM
  5. reference to external data sheet
    By matrixknow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2007, 08:44 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