+ Reply to Thread
Results 1 to 2 of 2

Capture data across worksheets

  1. #1
    Forum Contributor
    Join Date
    02-16-2006
    Posts
    200

    Capture data across worksheets

    I am trying to copy data across worksheets in a workbook. Problem is that the data I am trying to copy is captured within merged cells and the destination cell is not merged.

    So on sheet 'SLC STATS'! the data is held in merged rows / columns G28:P28 and G29:P29. The destination cell is on sheet ‘synthesis’ G12

    When I try a straightforward = sheet ‘slc stats’ on the synthesis page it wont capture the data, it just shows the formula: am I trying to do something which is not possible when rows and columns are merged? I’ve tried different combinations but it doesn’t seem to work?

  2. #2
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    Another good reason for not merging cells!

    You can get all the appearances of merging by using borders, fill colour and centre across selection
    Ed
    _____________________________
    Always learning, but never enough!
    _____________________________

+ Reply to Thread

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