+ Reply to Thread
Results 1 to 5 of 5

edition for heading in the macro code

  1. #1
    Forum Contributor
    Join Date
    12-23-2012
    Location
    Pakistan
    MS-Off Ver
    Microsoft office LTSC professional plus 2021 version 2403 (Build 17425.20176)
    Posts
    365

    edition for heading in the macro code

    I need to edit this macro little a bit
    SCENARIO
    when i run this macro it copies or imports all the sheets excluding IMPORT sheet into the IMPORT sheet, but before run the macro I have to copy the heading in IMPORT sheet, I want editing in the code in the area when i run it copies the heading as well. In other words, I dont want to copy paste the heading but to automate. I'm using excel 2013
    Attached Files Attached Files

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: edition for heading in the macro code

    Hello geniusufo007,

    Here is your Code:

    Please Login or Register  to view this content.
    Please try the attached sample Workbook, and enjoy!

    Regards.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Contributor
    Join Date
    12-23-2012
    Location
    Pakistan
    MS-Off Ver
    Microsoft office LTSC professional plus 2021 version 2403 (Build 17425.20176)
    Posts
    365

    Re: edition for heading in the macro code

    Thanks Mr Winon for your help but I'm enjoying with only one column of data not the four, so could you please look into it.
    OR
    Just tell me where should I put the line of code into already coded sheet

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: edition for heading in the macro code

    Hi Hello geniusufo007,

    Can you please show on a Separate Sheet, Say "Import Sample" how you want the Data arranged?

    Thank you.

  5. #5
    Forum Contributor
    Join Date
    12-23-2012
    Location
    Pakistan
    MS-Off Ver
    Microsoft office LTSC professional plus 2021 version 2403 (Build 17425.20176)
    Posts
    365

    Re: edition for heading in the macro code

    Sir,
    If you see my question I just want the heading by automate instead manual, nothing else
    I think there is a condition in the code when there is heading in the IMPORT sheet then it import the data otherwise not

+ 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: 5
    Last Post: 07-26-2016, 09:16 AM
  2. [SOLVED] Code for finding the first 4 instances of a column heading
    By danielstone121 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-12-2015, 02:14 PM
  3. Heading Code or ?
    By justme1052 in forum Excel General
    Replies: 5
    Last Post: 08-16-2014, 03:16 PM
  4. Macro/Code to return value based on heading?
    By tmarcello935 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2013, 06:37 PM
  5. [SOLVED] Need code for macro to pull all data from column heading matching drop-down
    By cpfenninger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2013, 04:00 PM
  6. [SOLVED] VBA developer handbook 2nd edition Examples Code
    By Snoopy2003 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2013, 03:14 PM
  7. Code Problem Macro to copy specific cell based on the heading it is next to.
    By Mush1138 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2011, 12:07 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