+ Reply to Thread
Results 1 to 4 of 4

Volume table to Raw Data Using VBA

  1. 08-15-2022, 10:56 AM #1
    elevenkun
    elevenkun is offline
    Registered User
    Join Date
    05-12-2012
    Location
    Bandung
    MS-Off Ver
    Excel 2019
    Posts
    8

    Volume table to Raw Data Using VBA

    Hai every one

    is there any ways to convert my volume table to raw data with VBA

    i use formula but its to slow when working with a lot of data

    please check my attachment for detail


    Frequency to Raw Data.xlsx

    thanks before
    Reply With QuoteRegister To Reply
  2. 08-15-2022, 11:50 AM #2
    WideBoyDixon
    WideBoyDixon is offline
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Volume table to Raw Data Using VBA

    This should do what you're looking for in that format:

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for ✶ rep!
    Reply With QuoteRegister To Reply
  3. 08-15-2022, 12:07 PM #3
    elevenkun
    elevenkun is offline
    Registered User
    Join Date
    05-12-2012
    Location
    Bandung
    MS-Off Ver
    Excel 2019
    Posts
    8

    Re: Volume table to Raw Data Using VBA

    Wow..

    thanks for the very fast response but...
    its work like what i hope for..

    but the border is gone and appear only in one cell that i select
    its no problem though

    Thankyou master WideBoyDixon
    God Bless You
    Last edited by elevenkun; 08-15-2022 at 12:17 PM.
    Reply With QuoteRegister To Reply
  4. 08-15-2022, 12:27 PM #4
    maras_mak
    maras_mak is offline
    Valued Forum Contributor
    Join Date
    07-14-2017
    Location
    Poland
    MS-Off Ver
    Office 2010
    Posts
    528

    Re: Volume table to Raw Data Using VBA

    See if this is how you wanted.
    The results are on sheet 2. 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Best Regards,
    Maras.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Groeperen van data in tabel
    By mvd2387 in forum Non English Excel
    Replies: 2
    Last Post: 08-30-2020, 11:35 AM
  2. Groeperen van data in tabel
    By mvd2387 in forum Excel General
    Replies: 0
    Last Post: 08-28-2020, 02:33 PM
  3. [SOLVED] Combine 2 lots of data into 1 tabel
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-20-2018, 12:03 PM
  4. formula to get the best value by changing several data in tabel
    By andipermana in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-07-2017, 04:28 AM
  5. Interpolating data in excel tabel with missing data
    By Onno Kramer in forum Excel General
    Replies: 11
    Last Post: 06-03-2014, 01:17 PM
  6. [SOLVED] Index/Match Multiple Criteria: Item # & Volume Level Pricing Relative to Specific Volume
    By dilbert1865 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-15-2014, 09:28 AM
  7. [SOLVED] Goal Line in chart but not on data tabel
    By BMSpell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-01-2005, 03:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1