Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Complex calculation and manipulation in Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dedren - 13 Jan 2006 21:43 GMT
I have my budget calculator on an Excel spreadsheet.  In one table(TableA) I
enter my paycheck date and the 4 columns to the right of it get a currency
value from another part of the worksheet.  Right below that I have expense
descriptions I enter and their amounts which subtract from those column
totals.  At the bottom of that table I have a remaining balance row.  What I
want to do is make a button that I can click which takes the paycheck date
and puts it in another table(TableB), then adds all the remaining balances,
stores their total value beside that paycheck date in TableB, skips to the
next line in TableB, and clears TableA.  Is this even possible with Excel or
am I biting off more than it can chew?
paul - 13 Jan 2006 22:05 GMT
it will be quite easy with vba.If you have all your tables set up a good way
to start  to use and learn vba is to record a macro.Go to tools/ macro/
record macro.Then do all your above steps manually and when finished "stop
recording".When you go to tools/macro/macros again choose edit and look at he
resulting code,then post back here  !
Signature

paul
remove nospam for email addy!

> I have my budget calculator on an Excel spreadsheet.  In one table(TableA) I
> enter my paycheck date and the 4 columns to the right of it get a currency
[quoted text clipped - 6 lines]
> next line in TableB, and clears TableA.  Is this even possible with Excel or
> am I biting off more than it can chew?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.