Results 1 to 3 of 3

Thread: How to insert the corresponding data into multiple worksheets from a range of data in Excel

  1. #1
    Join Date
    Oct 2011
    Posts
    46

    How to insert the corresponding data into multiple worksheets from a range of data in Excel

    Hi friends as I am new to the Excel I don’t have that much of experience in this Excel work. While working with one project I was just stuck at one query. I just want to select a range of selected data from one worksheet and then I want to insert those selected range of data into another worksheet with same cell. The thing that I want to do is that if I have 10 different sheet then I want to insert the first selected data in cell B3 and of the first sheet and the second selected data into cell B3 of the second sheet and vice versa. So if you guys have any ideas or information or any of the suggestion for me to do this thing in Excel then please let me know. Your reply and suggestion will be thanks and appreciated.

  2. #2
    Join Date
    Jun 2011
    Posts
    635

    Re: How to insert the corresponding data into multiple worksheets from a range of data in Excel

    According to my information, there you need to set up a multi work sheet set so that you can easily share the data values by cell or column. Try to make use of 3d spread sheet might be it works for your condition. The main thing that all you have to do is to share data and to make use of multi able cell or multi able column analysis.

  3. #3
    Join Date
    Jul 2011
    Posts
    623

    Re: How to insert the corresponding data into multiple worksheets from a range of data in Excel

    These are simple to do in excel with help of VBA or macros or the alternate thing you can do with data is to copy/paste from one worksheet to another worksheet.

Similar Threads

  1. How to insert common data from on Excel File to another
    By Rish!On in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 02:10 PM
  2. Replies: 2
    Last Post: 07-02-2012, 06:01 PM
  3. How to insert HyperTerminal data into excel sheet.
    By Shaina Na in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 07:44 PM
  4. Insert data from an Excel file into MySQL.
    By Antonio1 in forum Windows Software
    Replies: 3
    Last Post: 24-11-2009, 01:51 AM
  5. Insert Excel data into Word
    By Rivita in forum Windows Software
    Replies: 2
    Last Post: 24-09-2009, 02:09 PM

Tags for this Thread

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
  •  
Page generated in 1,711,617,756.30460 seconds with 17 queries