Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 02-28-2022, 08:30 AM
ArviLaanemets ArviLaanemets is offline Extract data from multiple table Windows 8 Extract data from multiple table Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by a4avinash View Post
Sir, are you trying to convey that each month data be in different sheet?
On the contrary! Data for any month are entered into same table on same sheet! Only acceptable reason to have more entry sheets is part of entry data having different structure.

An example for need of several entry sheets may be e.g. Invoices handling workbook, where one entry sheet contains general invoice info (invoice number, invoice date, client name/id, etc.), and another entry sheet contains invoice details/row info (invoice number, invoice row number, article code, article unit price, quantity, etc.). And such workbook can have quite a number of various reports, like monthly/yearly totals, monthly/yearly totals for certain client, monthly/yearly totals for certain article, etc. Your imagination and skills, and the number of parameters your tables contain, are only limitations.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract data from multiple table Extract and insert text data from excel table(s) in a (embed) Word document vladimiratanasiu Word 4 12-17-2020 05:25 AM
Extract data from multiple table Automatically extract data from a table into another word document OfficeAssociate99 Word VBA 1 05-28-2017 11:19 PM
Extract data from multiple table Pivot Table: Show Data For Multiple Items jhato160 Excel 14 08-01-2016 11:24 AM
extract specific pivot table data to a new sheet theexpat Excel Programming 0 02-18-2016 10:08 AM
Extract data from multiple table How to Extract Data from table based on pattern. PRA007 Word Tables 4 03-17-2015 11:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:22 PM.


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