Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 07-01-2010, 07:37 PM
Colonel Biggs Colonel Biggs is offline Displaying cell data in another spreadsheet Windows Vista Displaying cell data in another spreadsheet Office 2000
Advanced Beginner
Displaying cell data in another spreadsheet
Join Date: Jul 2010
Posts: 50
Colonel Biggs is on a distinguished road
Default Displaying cell data in another spreadsheet

I have two spreadsheet formats that I use for recording securities transactions (I'm using Office 2000 - still). The Transactions spreadsheet records data such as purchase date, cost, proceeds, gain or loss, etc. The Schedule D spreadsheet is simply that - it records the information from the Transactions spreadsheet for IRS reporting purposes. I perform this routine for about 20 accounts.

What I would like to be able to do is to enter data into the Transactions spreadsheet for a specific account, and to then have that data automatically entered into the Schedule D spreadsheet for that account without my having to copy each item individually.

Since all transactions (buy and sell) are not necessarily completed in the same year, it would also be ideal to copy this info to the Schedule D worksheet only when a sale occurs, but that may be asking too much.

Thanks in advance for any thoughts.

Colonel Biggs
Houston, Texas
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying cell data in another spreadsheet Copying data from one cell to another automatically mrphilk Excel 4 06-10-2010 11:52 PM
Cell Comments in a Protected spreadsheet dmgerber Excel 1 06-06-2010 05:10 AM
Displaying data from spreadsheet in Userform darklide Excel 0 03-12-2010 05:42 AM
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. Excel 0 11-24-2009 11:54 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:58 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd. is not affiliated with Microsoft