Results 1 to 4 of 4

VBA - Link in code to get data from one sheet paste in another sheet.

Threaded View

KSveigaard VBA - Link in code to get... 06-24-2017, 07:39 AM
Richard Buttrey Re: There must be a smarter... 06-24-2017, 07:49 AM
KSveigaard Re: There must be a smarter... 06-24-2017, 11:26 AM
Richard Buttrey Re: There must be a smarter... 06-24-2017, 11:44 AM
  1. #1
    Registered User
    Join Date
    10-15-2014
    Location
    Copenhagen
    MS-Off Ver
    201, 2013, 365
    Posts
    42

    VBA - Link in code to get data from one sheet paste in another sheet.

    Hi All.

    There must be a smarter way.

    I have two sheet, in sheet 2 (Ark2), owner can enter data, these should be copied to sheet 1 (Ark1)
    (Normally sheet2 (Ark2) is hidden and user of the sheet can enter deferent data in other cell then the one we "prepopulate"

    So for now, I can make this work, it is just not "nice" coding I think, there must be a smarter way to link cell together like "=Ark2,B2 or something. Hoep this makes sence and that you can help me.


        Sheets("Ark2").Select
        Range("A1").Select
        Selection.Copy
        Sheets("Ark1").Select
        Range("C5").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        Sheets("Ark2").Select
        Range("B5").Select
        Selection.Copy
        Sheets("Ark1").Select
        Range("C15").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
    End Sub
    Last edited by KSveigaard; 06-25-2017 at 05:45 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data From Web - any way to make it 'smarter'?
    By HalPlz in forum Excel General
    Replies: 1
    Last Post: 09-14-2015, 04:05 PM
  2. [SOLVED] how to make MAX formula smarter
    By Jetpilot69 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-25-2014, 09:21 PM
  3. Need smarter Excel rather than too many IFs
    By richard.lim85 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-25-2014, 01:42 AM
  4. hello my New and smarter then me friends
    By mac7988 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-14-2013, 10:43 AM
  5. So....Am I Smarter Than You?
    By superwhoever in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-28-2012, 10:36 PM
  6. Smarter chart
    By pearson in forum Excel General
    Replies: 1
    Last Post: 06-17-2010, 09:18 PM
  7. HELP - someone smarter than I please!
    By Atheria in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2006, 03:29 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