+ Reply to Thread
Results 1 to 2 of 2

Copying and pasting data from one sheet to another by identifying the same tag

  1. #1
    Registered User
    Join Date
    07-15-2020
    Location
    Reading, England
    MS-Off Ver
    2013
    Posts
    1

    Copying and pasting data from one sheet to another by identifying the same tag

    Hello,
    I am new to vba and macros and would like to ask your help to understand if what I'm trying to achieve is feasible using these tools.
    The task is quite simple, I'm trying to automatically fill a pre-formatted datasheet in Excel (DS1) for an asset, with the data contained in a second Excel sheet (DS2) that collects data for several assets in a list form.

    I need the program to do the following:
    1. Find the Asset name in DS2 as specified by the user
    2. Select the cell below the title which will contain a tag such as "Temperature"
    3. This becomes my first variable X1
    4. The program then has to select and copy the content in the cell to the right (i.e. 30 degrees) and this becomes my new variable X2
    5. The program now has to search for X1 in the sheets of DS1
    6. Once located it has to paste X2 in the cell to the right of the found X1.
    7. Once this is done the program should go back to DS2 and the found asset name and select 2 cells down and repeat the steps 3-6 and so on (Loop)

    Could you please let me know if this is doable and if you foresee any issues with the logic presented above? I would also like to ask if you could point me in the right direction in terms of code libraries/training material/existing threads to solve my task.

    I hope this is not too much of a silly question,

    Thank you in advance

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,779

    Re: Copying and pasting data from one sheet to another by identifying the same tag

    Can you provide an example walk through as per the yellow banner above so we can follow your logic?

+ 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. Help with basic copying and pasting data to a summary sheet
    By chrismoid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2017, 01:54 PM
  2. copying some data(value+formulas) and pasting to the same sheet is very slow
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2017, 06:33 AM
  3. Replies: 8
    Last Post: 02-01-2016, 09:30 AM
  4. Scanning data, and copying/pasting hits on new sheet
    By Hesler14 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2013, 02:59 PM
  5. [SOLVED] Copying a range of data in a column and pasting to another sheet
    By JP777 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2012, 07:44 PM
  6. copying and pasting data in separate sheet
    By ashwin_bist in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2008, 09:36 AM
  7. Pivot table - copying & pasting the data into another sheet
    By chedges in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2007, 10:30 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