Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 26th 06, 01:23 AM posted to microsoft.public.excel.worksheet.functions
Bri
 
Posts: n/a
Default Populating a table based on values in another table

Greetings
I am reposting this because the lines were somewhat garbled the first
posting.

I have a table on a sheet with columns as shown: (These are in order of
PartNum, ascending)
A B C D E
.... O
PartNum PartName JanSales FebSales MarSales.... TotSales


I need to be able to print out individual monthly reports with columns as
shown
below: (1 report for each month and 1 report for the annual Total)
A B C
PartNum PartName JanSales

Also, these reports must be printed in order of col C, ascending.

Now, I can do this 'manually' (copying, pasting, sorting...), but I was
really hoping to automate the process. Since the monthly reports all
have the same structure, I was hoping to have just one table that has a
cmdButton for each month and for the total. On clicking, say, the JanSales
button, I could print that report.

VERY GRATEFUL for any assistance. (have a tight deadline!)

Cheers, Bri




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
assigning value to a column based on a table of values Jacob Excel Discussion (Misc queries) 3 January 13th 06 08:46 PM
Merging Workbook Table data Based upon Value comparisons jayceejay New Users to Excel 5 January 8th 06 11:28 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
How do I graph a pivot table of sparse values? JDToellner Charts and Charting in Excel 0 December 17th 05 06:07 PM
Why won't pasted values from a formula appear in a pivot table B_4j Excel Discussion (Misc queries) 1 June 24th 05 06:53 PM


All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017