+ Reply to Thread
Results 1 to 4 of 4

To copy data from sheet-1 to sheet-2

  1. 02-16-2019, 11:06 AM #1
    madhavaraja
    madhavaraja is offline
    Registered User
    Join Date
    03-17-2016
    Location
    chennai,india
    MS-Off Ver
    2013
    Posts
    11

    To copy data from sheet-1 to sheet-2

    I have data like below in sheet -1

    a.jpg


    And I need the above data to be copied in sheet-2 like

    b.jpg

    I am very new to the macro,Could anyone help me in this...
    Last edited by madhavaraja; 02-16-2019 at 11:08 AM.
    Reply With QuoteRegister To Reply
  2. 02-16-2019, 12:14 PM #2
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: To copy data from sheet-1 to sheet-2

    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
  3. 02-16-2019, 01:33 PM #3
    madhavaraja
    madhavaraja is offline
    Registered User
    Join Date
    03-17-2016
    Location
    chennai,india
    MS-Off Ver
    2013
    Posts
    11

    Re: To copy data from sheet-1 to sheet-2

    Thanks a lot it worked...also is there any basics or tutorials available to learn vba macros.Please help
    Reply With QuoteRegister To Reply
  4. 02-16-2019, 01:46 PM #4
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: To copy data from sheet-1 to sheet-2

    You're welcome. Glad I can offer some help
    There is a sticky thread at the forum that has a lot of links to useful tutorials and also use Google to search
    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. Copy data from column to sheet database (Autosense system date and copy to Calender sheet
    By ricklou in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2017, 05:30 AM
  2. How to Copy data from Sheet 1 to sheet 3 by using sheet 2 (Contains Regex of each column)
    By Amar321 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-27-2016, 01:02 AM
  3. Copy data from one sheet to another sheet multiple times based on criteria from one sheet
    By manojuasc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2016, 01:16 PM
  4. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  5. Copy Sheet / Create & Name New Sheet / Insert Before a Sheet / Paste Data
    By thinkspac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2012, 02:27 PM
  6. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 PM
  7. Copy data from one sheet (Fixed Cells and sheet) to another sheet
    By RCatman23 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-21-2009, 12:56 PM

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