Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-24-2024, 02:24 AM
p45cal's Avatar
p45cal p45cal is offline Macro to summarize data Windows 10 Macro to summarize data Office 2021
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

In the attached, no macro, just a Power Query query at cell A17 of the sheet Data After Running Macro which, if the data in the table on sheet Original Batch 1783 should be changed, needs refreshing (like a pivot table) by right-clicking somewhere in the result table and choosing Refresh.
Attached Files
File Type: xlsx msOfficeForums52451MSSL Import Sample.xlsx (32.3 KB, 3 views)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to summarize data Summary task does not summarize % complete advillanuevag Project 2 06-12-2021 06:22 PM
Macro to summarize data Summarize keyword into word document simba24d Word 3 06-10-2016 02:28 PM
a macro that can copy data from copy.xls to our current excel macro.xls based on criteria: udhaya Excel Programming 1 11-12-2015 10:12 AM
Macro to summarize data Summarize durations by top level task tcdoha Project 1 01-10-2013 11:24 AM
Macro to summarize data Consolidating data using Macro mrjamez Excel Programming 2 05-22-2012 06:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 AM.


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