+ Reply to Thread
Results 1 to 13 of 13

dividing data equally between cells VBA

Hybrid View

  1. #1
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: dividing data equally between cells VBA

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  2. #2
    Registered User
    Join Date
    01-25-2011
    Location
    Milan, Italy
    MS-Off Ver
    Excel 2007
    Posts
    62

    Re: dividing data equally between cells VBA

    Hello xladept,

    attached please find a sample file. On sheet1 you can see some data the way it is presented. Sheet 2 is where all happens. Right now I use the "round" formula. I would like to have VBA to do that. Please keep in mind that the number of cells, on sheet2) that need to have the data may vary from 90 to 150. This variation is not sequential (like 90, 91, 92 and so on)
    Attached Files Attached Files

+ 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. Macro which sums up equally colored cells
    By Marina86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2013, 08:40 PM
  2. Excel 2007 : Spreading data equally
    By darkdan21 in forum Excel General
    Replies: 0
    Last Post: 04-06-2012, 07:21 AM
  3. Replies: 5
    Last Post: 02-24-2012, 11:48 AM
  4. Divide cell amounts between cells equally
    By hotwoz in forum Excel General
    Replies: 6
    Last Post: 07-08-2011, 05:54 AM
  5. Replies: 2
    Last Post: 06-14-2007, 05:18 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