#1
|
|||
|
|||
VBA Code to generate annual and quarterly reports
Hi experts I have set of data i want get data from data sheet to new sheet as per year and quater if i select year 2018 and Q3 i want set of data move to new sheet please find the attachment of sheet Q32018_Report name is target result run sheet is which i run report data sheet is containing data regards kingley |
#2
|
||||
|
||||
Would a pivot do?
Choose your year(s) and quarter(s) in cells C12 & C13 |
#3
|
||||
|
||||
Or a query table? Report headings could be inserted and formatted independent of the query results.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Merge Code to list question responses in multiple reports | dlconnolly@mac.com | Mail Merge | 7 | 04-29-2021 02:59 PM |
Generate QR Code in Word 2010 | pacojones | Word | 4 | 11-03-2020 12:28 PM |
Recommended solution to generate reports? | shohreh | Excel | 7 | 03-20-2014 06:49 AM |
Generate sequential code tags | ssarank | Word VBA | 3 | 12-25-2013 02:44 AM |
Cannot generate 2003 Excel reports in IIS7 | sword.fish | Excel | 0 | 02-22-2010 01:43 PM |