Results 1 to 5 of 5

VBA Codes who insert the automatic worksheet when click a cell and all datas of its

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2019
    Posts
    339

    VBA Codes who insert the automatic worksheet when click a cell and all datas of its

    I have an excel file having more than 150000 rows.It is to be downloaded from the available system.

    Now,I want a VBA codes or macro working who help me at that time when I click a particular cell then process the automatic steps of the following:-

    1-Insert sheet with the code name when click on that cell from a sheet.
    2-Insert the all columns and rows of that click cell code on this sheet.

    For more clarification,please refer my attach file.

    In this file,when I click on the cell H6,H126 and H145 and so on ( from details worksheet ),then the automatic insert the worksheet of FNDADRKCC,FNDADRKSC and GLRADRSCC with their respective all columns and rows datas e.g.Range B6:G20 in the case of FNDADRKCC and so on depends upon the code exist in the "Details" worksheet.


    Is it possible from VBA Codes working?
    Attached Files Attached Files
    Last edited by PRADEEPB270; 10-14-2013 at 01:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Right Click Worksheet Tab >> Insert >> ??
    By Cookstein2 in forum Excel General
    Replies: 2
    Last Post: 09-08-2011, 04:57 AM
  2. Automatic update Datas
    By Sascha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2010, 09:49 AM
  3. Insert datas from another program
    By Tercjusz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2009, 02:24 PM
  4. Automatic copy and insert row to other sheet after input and click button
    By antoni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2009, 11:50 PM
  5. Automatic insert cells to other worksheet
    By venice_guzman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-19-2009, 12:04 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