Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Auto updating???
0 views
Skip to first unread message
syne...@officeformac.com
Dec 25, 2009, 9:27:12 PM12/25/09
to
Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel
I have a 2 spreadsheets:
#1) Checkbook
Fields: Date, Category(list), amount etc.
Example: 12/25/09 Rent, 1,225
#2) A LEDGER spreadsheet for each category item listed above.
Example: A RENT table that would have columns for DATE, Amount etc taken from the Checkbook.
I would like Excel to take an entry in the Checkbook spreadsheet, grab the 'category', look the category up in the appropriate ledger spreadsheet and enter the checkbook data.
I used to be able to do this in the PC version of Excel with VBA but now, since I don't know Applescript, I am stumped. Got any ideas? thanks
#1) Checkbook
Fields: Date, Category(list), amount etc.
Example: 12/25/09 Rent, 1,225
#2) A LEDGER spreadsheet for each category item listed above.
Example: A RENT table that would have columns for DATE, Amount etc taken from the Checkbook.
I would like Excel to take an entry in the Checkbook spreadsheet, grab the 'category', look the category up in the appropriate ledger spreadsheet and enter the checkbook data.
I used to be able to do this in the PC version of Excel with VBA but now, since I don't know Applescript, I am stumped. Got any ideas? thanks
John McGhie
Dec 30, 2009, 4:59:31 PM12/30/09
to
I suggest that you should first copy the two sheets into the same WorkBook.
Many tasks in Excel are simpler if all the data is in the same file.
Many tasks in Excel are simpler if all the data is in the same file.
Now: First, convince yourself that you cannot do what you want using
AutoFilter (because it's easy!).
If you can't, then use a Pivot Table.
See "Analyze your data with PivotTable reports" in the Excel Help for more.
Hope this helps
On 26/12/09 1:27 PM, in article 59baf...@webcrossing.JaKIaxP2ac0,
"syne...@officeformac.com" <syne...@officeformac.com> wrote:
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:jo...@mcghie.name
JRsoc...@officeformac.com
Jan 11, 2010, 9:13:14 PM1/11/10
to
>Hi, I am looking to do this same thing, so if you have figured out anyway, or if pivottables work, please let me know. thank you.
0 new messages