Hi,
I'm trying to create a macro that when clicked, will add a new row to the bottom of my chart and fill in the next DES#, the date of the transaction, and show the total balance. I'm not very familiar with VB code so I have been recording my macros so far simply by recording my actions but I haven't had the result I wanted this time. I've uploaded my progress so far if that helps anyone. Thanks in advance for anyone who can help me out!
Forget the macro, just use Excel's Table LIST feature. I've activated the LIST on your data set. If you simply type in the next number you want in column C, the entire row will expand and bring down the formulas from the row above, very nice.
Check it out.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I appreciate your help but I have to do it using macros. This is a school assignment that I'm stuck on and it requires I use macros.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks