+ Reply to Thread
Results 1 to 4 of 4

data copying

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    Tehran
    MS-Off Ver
    Excel 2003
    Posts
    14

    data copying

    Hey guys, Iíd be really grateful if you please help me with some lines of code for following problem.
    I have 3 sheets. (letís say 1, 2 & 3). Sheet 1 contains 7 cell values (A1 to A7). Sheet 2 contains 350 cell values (A1 to A350). And finally Sheet 3 is blank.
    I want to enter Sheet 1&2 data into sheet 3 with the following order:
    Sheet3! A1 = Sheet2!A1
    Sheet3! A2:A8 = Sheet1!A1:A7 (Sheet1! Cells repeat every time)
    Sheet3! A9 = Sheet2!A2
    Sheet3! A10:A16 = Sheet1!A1:A7
    Sheet3! A17 = Sheet2!A3

    And so on ÖÖ.
    Until it gets all data from Sheet2!

    Thank you very much

  2. #2
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,449

    Re: data copying

    Hi pedram,

    Try the below code, if you don't wish to have the data linked & just need the values, let me know I can amend

    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  3. #3
    Registered User
    Join Date
    07-11-2013
    Location
    Tehran
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: data copying

    Thank you very much. That helped a lot

  4. #4
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,449

    Re: data copying

    You are welcome & thanks for the reps

    If the provided solution takes care of the original question, please mark this tread as 'SOLVED' from the Thread Tools at the top menu bar

+ 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. Macro copying data from HTML document. Not copying 0 from HTML.
    By MartinV10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2019, 03:10 AM
  2. [SOLVED] Copying an array formula down keeps copying data in top row
    By blackrosepetals9169 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-10-2018, 05:15 AM
  3. Replies: 1
    Last Post: 07-22-2014, 10:32 AM
  4. [SOLVED] Code from tigeravatar ,Copying data from one sheet and copying it
    By DanielRay in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-07-2012, 03:07 PM
  5. Replies: 1
    Last Post: 10-10-2012, 10:23 AM
  6. Replies: 1
    Last Post: 11-22-2011, 02:36 PM
  7. copying a range to first empty row is copying over data
    By jseufert in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2009, 03:45 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