Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-16-2022, 02:15 AM
ddos ddos is offline VBA Code to generate annual and quarterly reports Windows 10 VBA Code to generate annual and quarterly reports Office 2019
Novice
VBA Code to generate annual and quarterly reports
 
Join Date: May 2022
Posts: 1
ddos is on a distinguished road
Default 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
Attached Files
File Type: xls import.xls (82.0 KB, 9 views)
Reply With Quote
  #2  
Old 05-16-2022, 02:36 PM
p45cal's Avatar
p45cal p45cal is offline VBA Code to generate annual and quarterly reports Windows 10 VBA Code to generate annual and quarterly reports Office 2019
Expert
 
Join Date: Apr 2014
Posts: 640
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

Would a pivot do?
Choose your year(s) and quarter(s) in cells C12 & C13
Attached Files
File Type: xls msofficeforums49026import.xls (118.5 KB, 8 views)
Reply With Quote
  #3  
Old 05-20-2022, 07:06 PM
Marcia's Avatar
Marcia Marcia is online now VBA Code to generate annual and quarterly reports Windows 10 VBA Code to generate annual and quarterly reports Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 481
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by p45cal View Post
Would a pivot do?
Choose your year(s) and quarter(s) in cells C12 & C13
Or a query table? Report headings could be inserted and formatted independent of the query results.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Code to generate annual and quarterly reports 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
VBA Code to generate annual and quarterly reports Recommended solution to generate reports? shohreh Excel 7 03-20-2014 06:49 AM
VBA Code to generate annual and quarterly reports 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:18 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.
MSOfficeForums.com is not affiliated with Microsoft