weekly cash flow template setup - Help!

[kishan]

hi, basically i am designing a weekly cash flow manager
and am in need of some help. i want to make one sheet
where you input all the data ( eg weeks' takings,
expenditure, wages, WEEKNUMBER, PREVIOUS BALANCE) and
then when you click a button it will copy that sheet and
rename it to the week number and then it will clear the
template sheet. however the week number starts from june.
would i have to type these in manually or can i somehow
get it to calculate the week number based on the last
sheet added. also in the template i need a cell where it
displays the previous week's balance.

i am in dire need of help - can anyone explain a solution
to me.

 

[Debra Dalgleish]

You can turn on the macro recorder as you manually perform the steps
that you want to automate. That should give you a good starting point
for your code.

If you have specific questions or problems as your create your cash flow
manager, someone will probably be able to help. Post the code that
you're using, a description of how the worksheet is set up, and what the
problem is.

 

[Mark E. Philpot]

Hi,
Briefly, without the proper syntaxes.

sub TransferData()

sheet1
set a=a1
set b=b1
set c=c1

sheet2
set x=a1
set y=b1
set z=c1

x.value=a.value
a=""
y.value=b.value
b=""
z.value=c.value
c=""
end sub

If you would like me to write it, send a dummy workbook,
not the real text if you do not want me to see the good
stuff, to
(e-mail address removed)

regards
Mark