+ Reply to Thread
Results 1 to 2 of 2

Copy data from one table to another table

  1. #1
    Registered User
    Join Date
    06-18-2018
    Location
    Denmark
    MS-Off Ver
    Office 365
    Posts
    22

    Copy data from one table to another table

    Hi all,

    How do i copy a column from one table to another?

    Both tables exists. Tabel2 is located on sheet "Budgettal" and Tabel24 is located on sheet "Tidl. Budgettal".

    I need to copy data from column E row 3 to 64 in Tabel2, into a new column in Tabel24. The name in the new column header in Tabel24 should be the date you run the macro (Today's date).

    Everytime you run the macro, it should create a new column in Tabel24 on sheet "Tidl. Budettal", and copy column E row 3 to 64 in Tabel2 "Budgettal".


    The numbers in Tabel2 is formulas (ex =[@Kontraktsum]+[@[Godkendte krav til UE / Leverandør]]). So it needs to paste in numbers in tabel24 and not formulas.

    Thx in advance
    Attached Images Attached Images

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: Copy data from one table to another table

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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: 10-23-2017, 08:37 PM
  2. Replies: 0
    Last Post: 11-06-2014, 07:25 PM
  3. Replies: 1
    Last Post: 11-28-2013, 02:10 AM
  4. Macro to Copy Pivot Table and Paste a Regular Data Table in the Same Position
    By webfeet2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2013, 06:34 AM
  5. VBA Copy column data from one table and paste into another table
    By escobf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2013, 06:59 PM
  6. Automate: 1) wipe out table and 2) copy data from another table to it
    By Ragnaros in forum Access Tables & Databases
    Replies: 2
    Last Post: 05-08-2013, 08:22 PM
  7. Replies: 1
    Last Post: 09-13-2012, 07:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1