+ Reply to Thread
Results 1 to 3 of 3

Read values on other worksheets

  1. 01-06-2016, 06:45 AM #1
    Emirates is offline
    Registered User
    Join Date
    12-23-2015
    Location
    outerspace
    MS-Off Ver
    not sure
    Posts
    17

    Read values on other worksheets

    Hello everyone!
    A little help required with reading cells in different worksheets.

    I have to replicate a value on cell B3 from worksheet 1 to cell A1 on worksheet 2.
    Any help on how to do this?
    Thanks
    Reply With QuoteRegister To Reply
  2. 01-06-2016, 07:00 AM #2
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,921

    Re: Read values on other worksheets

    =sheet1!b3 ??
    Reply With QuoteRegister To Reply
  3. 01-06-2016, 07:04 AM #3
    Emirates is offline
    Registered User
    Join Date
    12-23-2015
    Location
    outerspace
    MS-Off Ver
    not sure
    Posts
    17

    Re: Read values on other worksheets

    thanks a lot, that worked...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need VBA macro to read and sum data from multiple worksheets
    By adfo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2013, 07:39 AM
  2. Need VBA macro to read and sum data from multiple worksheets
    By adfo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2013, 09:58 PM
  3. Update cell Values or Read Values in other sheet (change colour of autoshape with VBA code
    By rcasquinha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2012, 06:57 AM
  4. How to read excel worksheets into VBA structures
    By gerryg in forum Excel General
    Replies: 8
    Last Post: 02-21-2011, 09:25 AM
  5. macro to read descriptions, match in different worksheets and display values
    By aysrun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2009, 04:13 AM
  6. Read data and separate into different worksheets
    By alien3011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2008, 08:50 PM
  7. Read data from cells in different worksheets
    By emma in forum Excel General
    Replies: 5
    Last Post: 12-28-2005, 06:15 PM
  8. [SOLVED] How do I read info from different worksheets into a summary sheet?
    By Waterh2o in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-15-2005, 05:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1