Hi there, right I'm a bit of a novice when it comes to something like
this
so I'll try and describe as best I can as to what I'm trying to do.

I have a worksheet that I use day in, day out to calculate winnings on
specific bets made through the day. Now i have to input details in
variuos
cells, then click a button macro to calculate returns and other data.
Now
what I would like to do is be able to run another macro via a button,
to
export certain cells in that worksheet (once filled in and calculated)
to
another workbook under specific columns when I have made my bet, so I
can
log all my transactions and see how I'm doing over a set period of
time.

Athe moment the cells that I want the data from are not in rows, they
are in
random cells in the worksheet, but I would like them to export to the
next
available empty row in the new workbook under the correct column.

e.g. I need C3 C4 E7 G3 G4 G5 from the original to go into A2 B2 C2 D2
E2 F2
of the new worksheet, then the next one I do needs to come from the
same
cells but go into A3 B3 C3 D3 E3 F3 and so on. Then I can manually do a
sum
of particular columns in the new workbook to look at profit e.t.c.

Any pointers as to the best way to do this?

Thanks, Arron. :)


--
Smokes
------------------------------------------------------------------------
Smokes's Profile: http://www.excelforum.com/member.php...o&userid=21116
View this thread: http://www.excelforum.com/showthread...hreadid=524978