Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-27-2019, 07:53 AM
wendell45 wendell45 is offline importing specific data from another worksheet Windows 10 importing specific data from another worksheet Office 2019
Novice
importing specific data from another worksheet
 
Join Date: Dec 2019
Posts: 2
wendell45 is on a distinguished road
Default importing specific data from another worksheet


I frequently import data from an external worksheet into my worksheet. is there a way to specify which columns I want to import? Currently I import all data and then delete what I don't want. thanks for any help.
Reply With Quote
  #2  
Old 12-28-2019, 11:00 AM
NoSparks NoSparks is offline importing specific data from another worksheet Windows 7 64bit importing specific data from another worksheet Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 779
NoSparks has a spectacular aura aboutNoSparks has a spectacular aura aboutNoSparks has a spectacular aura about
Default

Have you tried using the macro recorder for an idea as to how VBA could be used to accomplish what you're currently doing manually ?
Reply With Quote
  #3  
Old 12-28-2019, 11:26 AM
wendell45 wendell45 is offline importing specific data from another worksheet Windows 10 importing specific data from another worksheet Office 2019
Novice
importing specific data from another worksheet
 
Join Date: Dec 2019
Posts: 2
wendell45 is on a distinguished road
Default

I haven't. I'm not that deep into excel yet...if you think that there may be an answer there I'll check it out.

thanks

Wendell
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I transfer specific data from email to specific excel cells? Mauro Outlook 1 11-11-2019 09:17 PM
importing specific data from another worksheet Appending unique data from one worksheet to existing data on another worksheet EdStockton Excel 1 08-06-2014 11:00 PM
importing specific data from another worksheet Importing/Exporting data using Excel and some specific rules stagg201 Excel 1 03-27-2014 08:58 PM
importing specific data from another worksheet "Auto-populating" data-worksheet to worksheet. meggenm Excel 4 02-04-2012 02:04 AM
Importing same Data into different documents Damonish Word 0 11-22-2009 07:24 PM

Other Forums: Access Forums - Senior Forums

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