+ Reply to Thread
Results 1 to 5 of 5

Draw table in VBA

  1. #1
    Registered User
    Join Date
    03-28-2022
    Location
    Bucharest
    MS-Off Ver
    2020
    Posts
    9

    Draw table in VBA

    Hello,

    I have a code which extracts data from a database and i would like to draw a table for exactly the data that has been extracted. To be noted that in the same sheet there are more datas that are extracted from different codes, therefore i would like to draw the table around only the data that is extracted by the code itself.

    I couldn't find anything related, just the draw table around every cell that contains data.

    Thank you!

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,323

    Re: Draw table in VBA

    There is no way on earth anyone will be able to supply a code to do this without a detailed description or at least sample file showing expected result...
    Please Note?
    Quoted From Rick Rothstein

    One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result... you must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data). To sum up... we only know what you tell us, nothing more. Also, uploading an actual file (see yellow banner near the top of this forum's window) showing your data as it exists and on another sheet showing how you want it to look after being processed would help immensely.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    03-28-2022
    Location
    Bucharest
    MS-Off Ver
    2020
    Posts
    9

    Re: Draw table in VBA

    Quote Originally Posted by sintek View Post
    There is no way on earth anyone will be able to supply a code to do this without a detailed description or at least sample file showing expected result...
    Hello, apologize. I forgot to add the code, indeed. Here it is:

    Please Login or Register  to view this content.
    The above code is copying whatever data i have in another sheet and paste it in selected sheet, aplying those formulas. I would like to draw the table around the data that is copied, whatever lines has.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,323

    Re: Draw table in VBA

    All good...Now just a sample file showing expected outcome...

  5. #5
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

    Re: Draw table in VBA

    Hi.
    Little by little it is coming, sintek: little by little (Jejeje).

+ 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. [SOLVED] How To Draw A Table Like That?
    By zanshin777 in forum Word Formatting & General
    Replies: 4
    Last Post: 01-05-2020, 10:00 AM
  2. [SOLVED] VBA code to draw values from one cell and deposit into a table below
    By anthony777 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2017, 10:50 AM
  3. How could i draw this website table in (cant get the web query to see the data in it)
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2013, 12:07 PM
  4. The draw in a footy ladder table
    By Fozz in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-09-2013, 06:31 PM
  5. Macro to draw a table and fill its cells
    By LLang in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 11:38 AM
  6. Draw out listings in table #1 based on specific criteria
    By Melvinrobb in forum Excel General
    Replies: 2
    Last Post: 07-24-2012, 02:45 PM
  7. Squash (or any sport) Win, Lose, Draw Table help.
    By ZoomerADS in forum Excel General
    Replies: 7
    Last Post: 06-25-2012, 01:55 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