Results 1 to 7 of 7

Need help for creating a Macro

Threaded View

  1. #1
    Registered User
    Join Date
    11-19-2014
    Location
    USA
    MS-Off Ver
    MS office 2010
    Posts
    3

    Need help for creating a Macro

    Hi Friends,

    I need a help and want to do this with macro could anyone of you please help me

    • From the “Functional Sheet” Go to “Description column and Copy first “SIS Line 2”.
    • Go to tab “Data Element” Search for it in “Description column” and in which so ever row the match is found
    • “Traceability Tracefrom” column of Data element sheet gets populated with functional sheet “ID” column corresponding to “SIS Line 2” which we copied that is “UW-F1”
    • Similarly for rest of the rows that is SIS Line 2,3,4 etc SS line 1,2,3 etc, O line 1,2 etc

    Please find attached template

    Thank You in Advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] creating a macro that inserts the current date in the same cell everytime the macro is run
    By katie1994 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2012, 07:59 PM
  2. help with macro - creating new columns/copying/creating new worksheets from default
    By vsantoro in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2010, 09:29 AM
  3. Creating a macro to auto-update external data and time macro was excecuted
    By UNWATCHABLE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2010, 05:21 AM
  4. Replies: 3
    Last Post: 12-15-2009, 10:22 AM
  5. Creating a macro which presses a button containing a recorded macro
    By petros89 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2005, 10:05 AM

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