Copying columns into next blank column with date using cmd button

**DataVanMan** · 01-04-2013, 11:31 AM

I would like to have a cmd button that copies data from column B into Column H and adds the current date at the top of the column, then continue into each subsequent Column, I J K etc.

Column B is a Total number for an entire job that spans multiple days so i need to be able to break that total down into how much in each given day. So to start, the button needs to only copy the data in the column B and put it into column H. However the next click needs to copy that the data from Column B into Column I but subtract Column Bs number from Column Hs number so it gives an accurate daily total and so on for each subsequent click.

HELP??

Attached is the sheet i am using.

**arlu1201** · 01-04-2013, 11:36 AM

Column B does not have any formula. So its value will remain unchanged. If you copy the value from column B to H today - it will show 100 for example. Then when you copy the value from Column B to I, it will still show 100. How will you get a daily total?

**DataVanMan** · 01-04-2013, 11:54 AM

there is a userform that i have in the full workbook that fills in this number. It gets updated frequently so that number will constantly be going up. I just sent that single sheet so you could visually see what I was trying for

**DataVanMan** · 01-04-2013, 04:09 PM

Ok I simplified my idea. I would rather input data from userfrom into columns and adjust the totals from there. Here is what I have so far but I cannot get it to input data

Please Login or Register  to view this content.

**DataVanMan** · 01-04-2013, 04:29 PM

Please Login or Register  to view this content.

Ok this is what I have now, except it will not find the next empyt column, just copies over the same one.
PLEASE HELP??

**arlu1201** · 01-05-2013, 01:57 AM

DataVanMan,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here