Jump to content

Excel 2010: How show relevant data on right tab


Sinsemilla

Recommended Posts

post-19679-0-24444400-1308506470_thumb.jpost-19679-0-24444400-1308506470_thumb.j Hi,

I am new to Excel 2010 and have a question I suppose is something right out of the basic course.

I am setting up a sheet that so far has five columns and seven tabs. The column headings are: Date, Supplier, Price incl tax, Price excl tax and Comment (plz see linked image).

The tabs are: Overview, Investments 2009, Investments 2010 etc and Maintenance 2009, Maintenance 2010 etc, seven in all.

The raw data are supplier invoices and the items purchased for the property fall in either the investments- or the maintenance categories for each year and should be shown thus when viewing that tab.

So, clicking the Investments 2009 tab should reveal the furnace bought June 6 2009, and the Maintenance 2010 tab should show fuel bought for the furnace that year.

I am thankful for any advice!

excelfile.jpg

post-19679-0-24444400-1308506470_thumb.j

Edited by Sinsemilla
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...