Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-26-2024, 02:03 AM
ArviLaanemets ArviLaanemets is offline Copy one worksheet to another using value and pastespecial Windows 8 Copy one worksheet to another using value and pastespecial 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

From your example file, it remains unclear, what you really want to do. Attached is a file with an example, how I'd set up the data entry, and how a report sheet may be designed.


But I have there no info, how the data really must be read into report. P.e. there are several rows for same article, with some of them completed, and some pending or back ordered. How to handle such records? E.g. must all records not completed, and having ListDate earlier than the row with completed status, left out? Or some other rule must applied?
Attached Files
File Type: xlsx WendingList.xlsx (40.0 KB, 5 views)
Reply With Quote
Reply

Tags
glitchy, pastespecial, summaryordertracking



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy a shape from one worksheet to another BobBridges Excel Programming 0 05-06-2022 05:02 PM
Copy one worksheet to another using value and pastespecial Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet kiwimtnbkr Excel Programming 23 10-08-2020 02:32 AM
Copy one worksheet to another using value and pastespecial How do you copy a row from one worksheet to another? mars1886 Excel Programming 3 02-11-2014 02:12 PM
Copy Worksheet and preserve formulas silverspr Excel 4 02-21-2013 07:51 AM
Copy one worksheet to another using value and pastespecial Is it correct (PasteSpecial function) gsrikanth Excel Programming 7 01-17-2012 11:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:46 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