+ Reply to Thread
Results 1 to 4 of 4

VBA Copy And Paste From Column A Sheet 1 To Sheet 2 Row 1

  1. #1
    Forum Contributor
    Join Date
    09-14-2016
    Location
    Fareham UK
    MS-Off Ver
    2010
    Posts
    110

    VBA Copy And Paste From Column A Sheet 1 To Sheet 2 Row 1

    Hi Guys,

    I was just wondering if you could help me as I am really new to this.

    I was wondering if it is possible to have a Macro run through Column A Sheet 1 Copying and pasting each value on to Sheet 2 Row 1 and then naming each of these ranges based on the value that it has copied.

    but the range size would need to be A1:C10, D1:F10, G1:I10 and so on......

    Any help would be greatly appreciated

    Many thanks
    Jamie

  2. #2
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: VBA Copy And Paste From Column A Sheet 1 To Sheet 2 Row 1

    Hi,

    Can you please insert a workbook just to see how it looks like.
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  3. #3
    Forum Contributor
    Join Date
    09-14-2016
    Location
    Fareham UK
    MS-Off Ver
    2010
    Posts
    110

    Re: VBA Copy And Paste From Column A Sheet 1 To Sheet 2 Row 1

    How do you add a workbook?

  4. #4
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: VBA Copy And Paste From Column A Sheet 1 To Sheet 2 Row 1

    Go Advanced==>Manage attachements==>Select and Upload them.

+ 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. Replies: 3
    Last Post: 11-06-2014, 01:23 AM
  2. [SOLVED] Copy row from one sheet and paste to another if a key word is found in 1 column of sheet 1
    By killdozer in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-17-2014, 02:27 PM
  3. Replies: 2
    Last Post: 01-22-2014, 05:36 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 Range from one sheet, and paste it to the next available column on another sheet
    By gherzberg in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-26-2012, 04:01 PM
  6. Copy Column in Sheet 1 and Paste into First Available Column on Sheet 2
    By johndoh453 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2011, 07:42 AM
  7. Replies: 0
    Last Post: 05-24-2010, 05:17 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1