Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-24-2016, 01:18 PM
windseaker windseaker is offline data migration Windows XP data migration Office 2007
Novice
data migration
 
Join Date: Feb 2010
Posts: 19
windseaker is on a distinguished road
Lightbulb data migration

What is best practices for data migration from one worksheet to another?


and how would I do this. It has been years since I have done this but I can remember, with a push!!

See attchment

Thank you
Attached Files
File Type: pdf Excel help-1.pdf (98.5 KB, 11 views)
Reply With Quote
  #2  
Old 06-27-2016, 07:42 AM
windseaker windseaker is offline data migration Windows XP data migration Office 2007
Novice
data migration
 
Join Date: Feb 2010
Posts: 19
windseaker is on a distinguished road
Default

Ok, forgot worksheet
Reply With Quote
  #3  
Old 06-27-2016, 07:46 AM
windseaker windseaker is offline data migration Windows XP data migration Office 2007
Novice
data migration
 
Join Date: Feb 2010
Posts: 19
windseaker is on a distinguished road
Default need example

here is example
Attached Files
File Type: xlsx Vlook-1.xlsx (119.5 KB, 9 views)
Reply With Quote
  #4  
Old 06-27-2016, 08:30 AM
NoSparks NoSparks is offline data migration Windows 7 64bit data migration Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Hello windseaker

You have this posted under Excel Programming on this site
Under Formulas at ExcelGuru
Under General at ExcelForums

What kind of solution are you expecting?

Is the data for the other 29 meters go to the same sheet?

The data sheet of your Excel file does not match the columns of your pdf ?????
Reply With Quote
  #5  
Old 06-27-2016, 01:48 PM
windseaker windseaker is offline data migration Windows XP data migration Office 2007
Novice
data migration
 
Join Date: Feb 2010
Posts: 19
windseaker is on a distinguished road
Default

NoSparks
I have read your rules at the other forum and understand the breech that I did. And they have stated my reasons very well on why I did do this. I do appreciate everyone help and If I was a big CEO and my paypal had money in it, well lets just say real gratitude is not "Trickle down" has the work trick in it.

A solution was not expected, just a start to understand.
VR/
Windseaker
Reply With Quote
  #6  
Old 06-29-2016, 07:36 AM
NoSparks NoSparks is offline data migration Windows 7 64bit data migration Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

You already have a formula type suggestion.

A macro approach could go something along the lines of this.
Drawback is the time taken to do the looping.
Filtering might speed things up.

... just an idea.
Attached Files
File Type: xlsm WindSeaker-Vlook-1.xlsm (168.3 KB, 8 views)
Reply With Quote
  #7  
Old 06-30-2016, 04:47 PM
windseaker windseaker is offline data migration Windows XP data migration Office 2007
Novice
data migration
 
Join Date: Feb 2010
Posts: 19
windseaker is on a distinguished road
Default

NoSpark & all,

I really appreciate the help and idea.
Can you tell me how to mark this as solved?
Thank you
Windseaker
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
data migration Comments were lost after Word 2010 => 2013 migration. Yury Word 4 07-07-2015 07:42 PM
data migration Data migration between two templates wordlearner16 Word VBA 20 04-26-2013 01:47 AM
data migration Address Book migration problem... DeMarcos Outlook 1 06-16-2010 06:22 AM
Migration of Office 2003 License (re-activation) dbabic Office 0 11-19-2009 09:54 AM
Problems with Migration and Rules Wizard RealtyConnect Outlook 0 04-23-2008 11:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 AM.


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