Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-19-2014, 12:24 PM
baybeelov baybeelov is offline Pulling data from one sheet and displaying on another worksheet Windows Vista Pulling data from one sheet and displaying on another worksheet Office 2010 32bit
Novice
Pulling data from one sheet and displaying on another worksheet
 
Join Date: Dec 2014
Location: Southwestern Indiana
Posts: 1
baybeelov is on a distinguished road
Default Pulling data from one sheet and displaying on another worksheet

I am trying to find out the best way to display a series of numbers that are on different rows on one line? For example: One worksheet has 5 lines each line has a number. These numbers need to be taken this worksheet and displayed in another worksheet from each line and displayed on one line with dashes to seperate them. No calculations needed I just want a combined display in one cell. if the numbers are:
452


251
632
123
322

then it would pull each line from this column and display in one cell on another worksheet and view as: 452-251-632-123-322

This is the first step of several things I am trying to do. I hope I can get some answers here! Thank you in advance!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling data from one sheet and displaying on another worksheet Pulling Data From Excel ptmuldoon Word VBA 7 03-19-2016 03:28 PM
Pulling data from one sheet and displaying on another worksheet Appending unique data from one worksheet to existing data on another worksheet EdStockton Excel 1 08-06-2014 11:00 PM
Pulling data from one sheet and displaying on another worksheet Help Coloring a cell in Sheet one if data is missing from another sheet Aeducan Excel 1 06-22-2014 04:49 PM
Pulling data from one sheet and displaying on another worksheet Excel worksheet as OBJECT in WORD not displaying mohsin Word 1 03-27-2012 10:43 PM
Mail merging and pulling varying data from Excel shannag1881 Mail Merge 0 10-05-2009 08:51 AM

Other Forums: Access Forums - Senior Forums

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