Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2015, 09:20 AM
mbesspiata mbesspiata is offline Copy matching data from one report cell to another cell report Windows 7 64bit Copy matching data from one report cell to another cell report Office 2010 64bit
Advanced Beginner
Copy matching data from one report cell to another cell report
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Unhappy Copy matching data from one report cell to another cell report


I run two reports showing package counts at various warehouses. I need to be able to take the total number of packages from one report and copy it to the other report but the locations may not always be the same from one report to the other. How can I create a vba to look for data in a warehouse from one report and find that warehouse in the second report and then place that quantity in the second report?
Reply With Quote
  #2  
Old 01-15-2015, 09:45 AM
gebobs gebobs is offline Copy matching data from one report cell to another cell report Windows 7 64bit Copy matching data from one report cell to another cell report Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Please attach a sample sheet.
Reply With Quote
  #3  
Old 01-15-2015, 09:59 AM
mbesspiata mbesspiata is offline Copy matching data from one report cell to another cell report Windows 7 64bit Copy matching data from one report cell to another cell report Office 2010 64bit
Advanced Beginner
Copy matching data from one report cell to another cell report
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default Information attached.

See attached to let me know how to create vba to move package count data from the second report to the pkg inventory column of the first report.
The issue is that sometimes the warehouse location may not be listed on the first report so I won't need the package count from the second report entered for that warehouse.
Attached Files
File Type: xls Book1.xls (28.0 KB, 2 views)
Reply With Quote
  #4  
Old 01-15-2015, 11:10 AM
gebobs gebobs is offline Copy matching data from one report cell to another cell report Windows 7 64bit Copy matching data from one report cell to another cell report Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Are the warehouse names not going to be identical like here? If they were, you could do a simple sumif, no vba required.
Reply With Quote
  #5  
Old 01-15-2015, 11:15 AM
mbesspiata mbesspiata is offline Copy matching data from one report cell to another cell report Windows 7 64bit Copy matching data from one report cell to another cell report Office 2010 64bit
Advanced Beginner
Copy matching data from one report cell to another cell report
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default

No. The names will always be like they are on the example. Coming from two different reports, they are not formatted the same.
Reply With Quote
  #6  
Old 01-15-2015, 11:27 AM
gebobs gebobs is offline Copy matching data from one report cell to another cell report Windows 7 64bit Copy matching data from one report cell to another cell report Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Is there something else that can be used as a key identifier, like WarehouseID, that would be common to both reports? Can you redesign one report or the other so they have compatible data? If not, then I really can't see how it could be done.
Reply With Quote
  #7  
Old 01-15-2015, 12:22 PM
mbesspiata mbesspiata is offline Copy matching data from one report cell to another cell report Windows 7 64bit Copy matching data from one report cell to another cell report Office 2010 64bit
Advanced Beginner
Copy matching data from one report cell to another cell report
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default

OK. I have created some additional text to change the names on the first report to match the warehouse names on the second report. What's next? Remember that some of the warehouse names may not show up each time on the first report at the top.
Reply With Quote
  #8  
Old 01-15-2015, 01:37 PM
gebobs gebobs is offline Copy matching data from one report cell to another cell report Windows 7 64bit Copy matching data from one report cell to another cell report Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

=sumif(b14:b18,a3,c14:c18)
Reply With Quote
  #9  
Old 01-15-2015, 01:47 PM
mbesspiata mbesspiata is offline Copy matching data from one report cell to another cell report Windows 7 64bit Copy matching data from one report cell to another cell report Office 2010 64bit
Advanced Beginner
Copy matching data from one report cell to another cell report
 
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default

Great.
Thanks much.
Reply With Quote
  #10  
Old 01-15-2015, 01:49 PM
gebobs gebobs is offline Copy matching data from one report cell to another cell report Windows 7 64bit Copy matching data from one report cell to another cell report Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 832
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Think nothing of it. :-)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation Process of Schedule Report Output and Report Check Score Card ! ozman86 Word VBA 1 11-19-2014 11:52 PM
Copy matching data from one report cell to another cell report matching data from one work sheet to another, then auto filling missing cell information timomaha Excel 1 09-12-2014 07:51 AM
Copy matching data from one report cell to another cell report When I sort my data, the sumif report changes amaka Excel 6 03-19-2014 04:55 AM
Copy matching data from one report cell to another cell report Button Filtering Data in a 2010 Report runswick Word 1 10-20-2012 11:03 AM
Copy all comments & cell contents (i.e. data) to word? IanM Excel 0 07-03-2010 11:14 PM


All times are GMT -7. The time now is 06:03 AM.


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