Can I convert columns to rows?
I need to convert address information, which is on word and listed
vertically, to an excel spreadsheet, and have the information list out
horizontally. Is this possible to do? I am familiar with the basics of each
program, but using "range,formula,value" options in excel confuses me.
Here's an example:
(My data in word)
Mel's Tire Store, Inc.
300 Culbertson Avenue
Worland, WY 82401
Need to copy and paste so data spreads horizontally in Excel, under these
"Business Name" "Address" "City&qu...Multi CSV file import #2
I have about 200 csv files that I would like to import into excel.
After figuring out that I can only import 1 file at a time, I am tryin
to seek a solution to this time consuming problem. Is there an easy wa
to import them all at one time, (all the same layout). Is there a way t
merge them all and import them, or any other solution?
Message posted from http://www.ExcelForum.com
...Is there any way I can import a report design from excel?
My client has designed his Delivery Notes in excel. Is there any way I
can import this into access as a report design?
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Stapes" <firstname.lastname@example.org> wrote in message
> My client has designed his Delivery Notes in excel. Is there any way I
> can import this into access as a report design?
...Inserting a Word doc does not preserve the imported files' layout.
I have two Word documents.
They both use the same template (.dot).
Document 1 is built by managed code in vb.
Document 2 is a document manually built - one page only, and has the
1. (Topmost) A text box with black fill and white text.
2. (Beneath 1) Two collumns. Left has text only, right has a picture and
some text boxes placed on the picture.
3. (Beneath 2) One collumn. Text only.
4. (Beneath 3) A logo
5. (Beneath 4) A text box with black fill and white text.
When calling insert file either doing it manually in Word 2002 SP3 (I...Power point crossed with data
I'm designing a data base that has a power point look to the presentation of
reports like a slide show updated with forms any help would be nice
...data sort is not including all columns in sort
I have a list with name, company, address, city.....etc. When I click on
data sort (i do check the box to include column headings) and do a sort by
say address, it will sometimes exclude a column such as name from the sort.
It does not always do this. Is this a glitch? Do I need to highlight the
entire list before I sort?
Also, sometimes if I just use the Ascending or Descending icon rather that
going to data, sort it will only sort that column and not the rest of the
data with it.
Those are the reasons that I don't trust excel to guess at the range I want
I'll...can i wrap rows to form multiple rows per row to fit on 1 sheet?
i have a worksheet with very long rows (a to cf). For printing i would like
to wrap the rows to fit on a single page, and then seperate each set with a
space. I would also like to wrap the headers too, of course. is this
Say you're creating 10 columns per new row.
So it kind of looks like this:
$A$1 $B$1 $C$1 $D$1 $E$1 $F$1 $G$1 $H$1 $I$1 $J$1
$K$1 $L$1 $M$1 $N$1 $O$1 $P$1 $Q$1 $R$1 $S$1 $T$1
$U$1 $V$1 $W$1 $X$1 $Y$1 $Z$1 $AA$1 $AB$1 $AC$1 $AD$1
$AE$1 $AF$1 $AG$1 $AH$1 $AI$1 $AJ$1 $AK$1 $AL$1 $AM$1 $AN$1
$AO$1 $AP$1 $AQ$1 $AR$1 $AS$1 $AT$1 $AU$1 $AV$1 $AW$1 $AX$1
$AY$1 $...Word 2007 how to get data from forms to Excel
I have forms that have been filled out by various people and would like to
export the data into an Excel worksheet. This seemed straightforward in Word
2003, but I cannot get it to work in Word 2007.
The actual form is a Word 2003 document. When I save the file as a txt file
(after Word options / Advanced / Preserve fidelity / check "save form data as
delimited text file") it creates the delimited file, but it gets overwritten
when I close the original filled form.
I am having a similar problem, but the "save form data as delimited
text...Change source according to data entered in a template.
I am using third party software to enter data into a template. Things seem
to work fine, except I want to vary the source data for the chart in the
template according to how many rows of data have been entered from the third
party. Is there a way to do this??
try using a defined name for the source data
"ANStech" <ANStech@discussions.microsoft.com> wrote in message
&...Loosing Data-Help needed
Hi All, I have an huge spreadsheet with macros on it, which is
continuously updated. Off recently my spreadsheet is loosing the data
i.e. I will have 2-3 days old information, all the updates that we made
recently is lost. I am saving the spreadsheet every 15-20 mins still it
is doing it. Could anyone please help me :confused: .
neomemphis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33240
View this thread: http://www.excelforum.com/showthread.php?th...Reference architecture for mobile data acquisition?
not sure if this is an appropriate group for this question, but SQL
server is part of that ...
Basically I'm looking for some kind of reference architecture for a
project which is basically about mobile data acquisition. On an embedded
device running WinCE and SQL Compact Edition 3.5, measurement data is
received by external devices (e.g. via CAN bus), locally stored in the
compact edition database and then transmitted via GSM, satellite ... to
a central database server running SQL Server 2005 Standard.
Using Microsoft technologies (WinCE, SQL Compact Edition, S...getting all data about search subject
I have a client that had CRM installed on a server and
migrated their ACT database over to it(i came into this on
the tail end so i didn't set it up)--whenever they do an
account lookup they want to get all the info surrounding
that client--emails, images , past correspondances,
invoices, quotes etc... they want all this in one click so
to speak---in reading these posts two things popped out at
me "searchpac 360" and"only the user can bring up what
they own or produced" since this firm has several
employees on the system all saving and sending info to and
abou...How backup data in Outlook2003w/BCM?
I'm using Outlook 2003w/BCM, and wondered how to backup everything before I
uninstall/reinstall Outlook, so I get back to everything looking exactly the
way it was before the re-install.
(What cause this is...I have an underlying WinXP problem affecting the whole
PC, so I have to format/reinstallWinXP, and of course that causes me to
loose and have to re-install Outlook...but right now Outlook works ok, so
the data's still in tact)
In Outlook, there's a File > Business Database > Backup... but it says I
also need to backup "linked items."
So, what all needs to be...Pull data from multi-row records
I've got about 50 records that were imported. Each record has about 30
rows. A portion of one would look something like:
100 1\$aKelton, Elmer.
245 10$aRanger's trail$h[electronic resource] /$cElmer Kelton.
260 \\$aPrince Frederick, Md. :$bRecorded Books ;$a[Boulder, Colo.
:$bMade available electronically by] NetLibrary,$c2005.
300 \\$a1 sound file (9 hr.) :$bdigital, wma file.
440 \0$aLone Star audio
490 1\$aTexas Rangers series ;$v4
538 \\$aSystem requirements: Windows Media Player compatible, check
NetLibrary we...Macro to add name on a cell based on the data
I am using Excel 2003 and I need help to do a macro. I copy and paste data
into a worksheet call "Table" In the worksheet I want to put a specialist
name in the column called "Specialist" beside a column called "STATE" the
specialist name will be based on what the state is. For example
If the state contains "CA" I want the specialist name to be "Anna"
or the state of "OR" I again want the specialist name to be "Anna"
Now if we get a different state "UT" I want the specialist name to be
"...Select a certain number of cells in a row
I'd like to have the macro to select row 5 to 10 in the active column. May I
know what is the VB code to write?
dim myRng as range
dim myCol as long
mycol = activecell.Column
set myrng = .range(.cells(5,mycol),.cells(10,mycol))
I'm not quite sure why you want to select that range. But for the most part, if
you act directly on the range (and avoid .selects), you're code will work faster
and be easier to modify.
Dolph...how to protect appointed rows or columns to use the mouse and keyboard
You could include some text in your post.
Maybe then we could figure out what you mean by "appointed"??
"To use the mouse and keyboard" makes absolutely no sense whatsoever.
Maybe you're a new poster???
If so, take a look here before reposting:
Most anything that could be asked in the newsgroups has already been
Take a look here and you may just find what you're looking for (whatever
"hzh" <email@example.com> wrote in message
news:7A2382EE-00E6-4679...want to limit worksheet to 1000 rows instead of 65,000
My worksheets only need 1000 rows but the worksheet remains at 65,000+ rows.
I have 1 GB or ram and 6 worksheets causes problems. How can I set a default
to limit the max number of rows and columns.
All (pre-XL07) worksheets have 65536 rows. That can't be changed.
However, unused rows don't take up any memory or disk space, so there's
no need to try to limit them.
What problems are you having?
In article <1C30E096-94AD-4244-A976-FEE04B45912D@microsoft.com>,
GeoObject <GeoObject@discussions.microsoft.com> wrote:
> My worksheets only need 1000 rows b...Why can't I enter any data on any new worksheets?
I cannot enter any information on any new, or existing worksheets. I've even
tried uninstalling and reinstalling the program. Please help!
...Feeding MS Excell with MS Word data
I need to know if it is possible to pass data from MS Word to MS Excell
The data in MS Word is text, and I need to place some information in
specific columns in an Excell Workbook
...Data Import w/ Multiple types of delimiters
I'm working on a database that will import files that contain multiple types
of delimiters (~, * & ^). Each of the different types of delimiters
indicate the start of a different section. How do I specify that there is
more than one type of delimiter? Everything I see only allows one type.
Does this have to be done through VB?
Yes, it would have to be done through VBA (Visual Basic for Applications,
which is what Access uses, not VB)
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"John W" <firstname.lastname@example.org> wro...Data Transfer Issues with remote site
I am hoping one of you may have some suggestions on what may be causing this
issue and provide some suggestions on how to reduce the occurrence of this
We have a .NET 1.1 Windows application that ties in with Great Plains
running SQL Server 2000, using ADO .NET 1.1. The application is run on three
sites – one local (main server) and two remote. I will call them Remote1 and
Remote2 for the sake of this posting.
In overview, the application provides services for filling orders. Orders
are retrieved form the main server and order lines are posted for
ver...Importing a distribution list into another distribution list
I am using Microsoft 2002 and wonder if I can import an
existing distribution list into another existing
distribution list? I am trying to avoid entering
individual emails into an existing distribution list.
I'd like to be able to import the entire list.
Pat Speir <email@example.com> wrote:
> I am using Microsoft 2002 and wonder if I can import an
> existing distribution list into another existing
> distribution list? I am trying to avoid entering
> individual emails into an existing distribution list.
> I'd like to be able to import the ...Lost link to old outlook data after PC crash
Any help would be appreciated. My husband fried our
configuration, and ended up having to re-install every
programme. In the process...I can no longer access my
old Outlook express emails (local folder)...how do I get
Thanks in advance
...Importing MFC resources
I have a very large project that consists of several MFC applications, all
created with VS 7.1. What I'd like to do now is create MFC resources that
can be shared among these different applications. For example, I'd like
to create a dialog resource, along with the code to handle that dialog's
controls, and then bundle it up for use by all the other applications.
I've tried a few things with very little success. I seem to always end up
with resource ID conflicts when I import a resource into another project.
I can manually patch this up in the resource.h file, b...