View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SandMaN SandMaN is offline
external usenet poster
 
Posts: 1
Default Select a file, copy it and change some data


Hi,

I have a question for you. First of all, sorry for my english, its no
native.
I have a workbook to control my expenses. I classify them in different
classes.
The one I make with my credit card in many pays, I want a macro to copy
it in as many months as pays I have.
Do I mean?

Example.

Month 1 - Expense A - Pays 6 (6 to pay)

I want a macro to insert this

Month 2 - Expense A - Pays 6 (5 to pay)
...
Month 6 - Expense A - Pays 6 (0 to pay)

Can you help me with this?

Thanks!!!!


--
SandMaN
------------------------------------------------------------------------
SandMaN's Profile: http://www.excelforum.com/member.php...o&userid=37534
View this thread: http://www.excelforum.com/showthread...hreadid=571755