LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi .....,
I assume you have two columns, with the first column actings as a tag.

Creating a Spreadsheet from Database data (#dbdata)
http://www.mvps.org/dmcritchie/excel...col.htm#dbdata

Simple matter to delete any columns you don't want afterwards
You can rearrange columns with the mouse
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Aqua Flow" wrote in message
I have a text file created and wish to create a MS-Excel spreadsheet
w/columns the 1st column should be static while the row could have
variable data to append. Any ideas/scripts to share will be
appreciated.

Sample File:
Client: PSHBGMCGAPP01
Backup ID: PSHBGMCGAPP01_1101705374
Policy: McGregorServersDailyBackup




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
File asks to update when no links were created Dave Links and Linking in Excel 1 December 16th 04 08:10 PM
Getting a file and Saving a File carl0s66 Excel Discussion (Misc queries) 2 November 29th 04 09:59 PM
convert number into corrseponding text mustafa Excel Discussion (Misc queries) 1 November 29th 04 12:50 PM
VBA Import of text file & Array parsing of that data Dennis Excel Discussion (Misc queries) 4 November 28th 04 10:20 PM
import csv file Patrick Excel Discussion (Misc queries) 2 November 27th 04 10:09 AM


All times are GMT +1. The time now is 08:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"