S
Smokes
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.
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.