+ Reply to Thread
Results 1 to 11 of 11

Formatting the Data with VBA code

  1. #1
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Formatting the Data with VBA code

    i have a excel workbook and it contains 2sheets i.e. sheet1 and sheet2 which is also attached herewith for ready reference


    i want a vba code to add 10 blank rows before the First #N/A of Col-H of Sheet1 (first #N/A exist in H16, add 10 blanks rows before H16)

    after that i want to add the data which is exist in Sheet2 "Col-A2 to G2" and put it after H15 in Sheet1..........after that make a total of Col-F in the very next row
    Attached Files Attached Files

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

    Re: Formatting the Data with VBA code

    Suggest you use the macro recorder and then post your code and advise what needs to be changed to meet your specific needs. Using the macro recorder will help you to learn and understand VBA. Learning how to do this is a key to this forum. We are here to help you but not to do your work for you.
    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

  3. #3
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Formatting the Data with VBA code

    I think admin block me

  4. #4
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Formatting the Data with VBA code

    Thanks for reply.........sir i got the code from Recording Macro but when i paste it in here it gives me error

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

    Re: Formatting the Data with VBA code

    Upload the workbook with the code included. Tell us what needs to be changed in the code to satisfy you.

  6. #6
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Formatting the Data with VBA code

    Thankyou sir for helping me...........I want rearrange the data of Sheet1 like Final_Result Sheet.......for this, i am uploading a new excel file in which Sheet1 contains all data........

    Sir please follow the instruction which are mentioned in Sheet1 to Sheet10 (purpose of creating these sheet i.e. Sheet2 to Sheet10 for easily understand, actually all these steps/instruction should be apply in Sheet1)Sheet1 to Sheet10 include 12 steps/instructions).
    after this final result should be like my Final_Result Sheet.........please see Final_Result sheet for better understand (Arrow is only for attention)
    Attached Files Attached Files

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

    Re: Formatting the Data with VBA code

    As I indicated earlier, we are here to help you learn, but not do your work for you. If you are unwilling to attempt a solution and learn from it, why should I. You need to show some effort here. This is a major project and I do not have the time nor energy to do your work for you.

    If you are unwilling to put forth the effort to make this work, then I seriously suggest you hire a consultant to do this for you. This site is a help site and not a we will do your work for free.

  8. #8
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Formatting the Data with VBA code

    Thanks sir for reply........sir this is not a major project, i create 9 sheets which indicate step by step what to do..........sir you are right......This site is very helpful and this website have best team which help like my kind of person (i dont know VBA very well, but normal excel i can handel).........thanks for reply........if there is will there is a way

  9. #9
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Formatting the Data with VBA code

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

    No further help to be offered, please, until the OP has complied with this request.

  10. #10
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Formatting the Data with VBA code

    Thank you for this. How do I edit a Post to include a link to a Cross Post?

  11. #11
    Forum Contributor
    Join Date
    02-17-2014
    Location
    INDIA
    MS-Off Ver
    Excel 2010
    Posts
    320

    Re: Formatting the Data with VBA code

    hello sir ....................
    Last edited by AVG123; 10-07-2018 at 10:35 AM.

+ 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: 1
    Last Post: 08-04-2016, 10:59 AM
  2. VBA code to convert all data + formatting of entire sheet to VBA code
    By jocanon in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-14-2016, 06:56 PM
  3. Tool or code to copy VBA code to OneNote or Word while preserving VBA formatting
    By gregersdk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2015, 04:07 PM
  4. VBA Code to Generate Stacked Data (inc. Formatting)
    By jeversf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2015, 02:55 AM
  5. [SOLVED] Userform TextBox Problem... formatting code clears data instead of formatting
    By michaeljoeyeager in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2012, 11:00 AM
  6. time code data formatting
    By exceldoofus in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-18-2006, 03:44 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