Text to column and paste special transpose
I have 1 table like this
item_number qty ref
00010-001 3 U34,U36,U43
00013-001 2 U16,U21
12505-001 3 U32,U33,U42
12512-001 3 U5,U6,U27
and 1 want it to become like this
item_number qty ref
00010-001 3 U34
00010-001 3 U36
00010-001 3 U43
00013-001 2 U16
00013-001 2 U21
12505-001 3 U32
12505-001 3 U33
12505-001 3 U42
12512-001 3 U5
12512-001 3 U6
12512-001 3 U27
Anybody can help me to program it in macro.. usually i do it manually and have to redo again do to careless.
After using Text to Columns on Column C.......comma
delimited.........Run the Reorganize macro.
Sub ReOrganize...Email trouble with New User in Active Directory
Below is a trail of posts that have been made. My
problem has yet to resolved and I need some help
quickly. The only other thing I can think of is to
reinstall Exchange Server 2003. Hopefully someone will
know the answer.
Subject: Re: Email not Setup when new user created in
From: "Bryan Hill" <firstname.lastname@example.org> Sent:
8/15/2004 12:30:21 PM
We have other clients that are working fine. Just when
we try to set up new ones - it will create the SMTP
address but not the X400 address. I tried manually
forcing the X400 but it will...Outlook 2000 SP3
How can I copy my mail and calendar to CD so that I can
take my received and sent mail history to a new computer
with Outlook installed? Thanks.
>How can I copy my mail and calendar to CD so that I can
>take my received and sent mail history to a new computer
>with Outlook installed? Thanks.
All your data saves in
C:\Documents and Settings\Username\Local
C:\Documents and Settings\Evgeni\Local
You can either install instan...Copy picture ossice wizard
I have project 2007 standard edition, but the button is not working at all?
The wizard is IMHO useless.
Go to Roport, Copy Picture and do without the Wizard what millions have done
before the Wizard existed.
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
"Enrique" <Enrique@discussions.microsoft.com> wrote in message
>I have project 2007 standard edition, but the bu...Secondary Copy
My customer using Great Plains modified report(Primary Copy).
Now he wants new report something similar to the modified GP report with
very few changes.
I tried to copy the modified report and planned to use us a secondary copy.
But the report has temp tables, so I am unable to make secondary copy.
Can some one help me in how to make a new report something similar to the
modified report, where to launch it.
Whether it is possible throught VBA & Modifier?
A report with a temporary table can only be a primary copy.
This is because only a primary copy can b...local copy of mail
How do you store a copy of all your mail on you local computer when using
You setup an OST/Offline Folders file. Check with your mail admin if they
support that configuration.
"Brandon Baker" <email@example.com> wrote in message
> How do you store a copy of all your mail on you local computer when using
...Copy info from one workbook to another?
I have a problem
I have a workbook with the function i want like a discribe here. The
problem is i want to split the workbook but i don`t know how.
Is it possible to have a main workbook with information from other
workbooks at each worksheet? I have 20
workbooks with information. I would like to have a main workbook with on
sheet1 every row from the
20workbooks with category1, on sheet2 every row from the 20workbooks with
category2, etc, etc. The information
in the 20workbooks in always only on sheet. The Colum in which the data is
has no fix end. I go to fill in the
rows trough a...set paste option automatically
I'm trying to do a simple copy (ctrl-c) from Word and paste it into an Excel
cell with ctrl-v. Now the 'paste option' button comes up each time and I
have to select 'match destination format' each time. If I turn off paste
options, then the cell contents remains blank. Help!
...Trouble with the template.
I want to reset the 'normal' template to default to "Times
New Roman" 10point font, and the pages numbered centre top.
This seems to work when I set and reopen Word2003 from the
Administrator Template vis:
C:\Documents and Settings\Administrator\Application
But it will not work when I open Word2003 normally from the
I have deleted the "Normal.dot" from the following and
copied in the "Normal.dot" from the Administrator above:
C:\Documents and Settings\All Users\Application
Data\Microsoft\Templates...subtotal copy and paste
I have used the subtotal option in Excel and this is fine. I have also
collasped the list so only the subtotal for each category is visible. However
I want to copy and paste this list (just the subtotal) into another sheet
When I do this it expands and shows all the results. Is it possible to just
copy the visible bit. I have looked in paste special but no luck
On Jan 21, 6:38=A0am, Hager <Ha...@discussions.microsoft.com> wrote:
> I have used the subtotal option in Excel and this is fine. I have also
> collasped the list so only the...Copy and paste versus copy and insert copied cells
What is the difference between these commands?
Try them, it is pretty easy to see the difference
"Alana" <Alana@discussions.microsoft.com> wrote in message
> What is the difference between these commands?
...Copy and Paste problem #2
A question from a newbie. I am working with a template from Microsoft's website.
I started to customize it yesterday and everything was going well. I get back to it today and I have the following annoying problem.
When I select a bunch of cells, copy them and then choose Insert Copied Cells, the cells are copied by the width of the original cells are not respected and shift to the new area's width. It looks like that the formulas are also not carrying over properly.
Any help would be appreciated.
I tried closing/reopening Excel, rebooting my program, repairing it with ...trouble with CrmIsapi.dll
I was experiencing the same problem with the SDK as many have posted
to this group ...
"the WhoAmI() call results in a http error 405 when running sample
I followed some of the advice; checked my .srf mapping to CrmIsapi.dll
and re-registered the CrmIsapi.dll.
when I re-register CrmIsapi.dll I get an error 80004005 - unspecified.
I copied it to various places and retried it ... same result.
I got the original from the disk and retried ... same result.
unmapped it from .srf, restarted and retried to register it ... same
Anyone experienced this.
What's up with m...Trouble with Outlook 2003 and PST File
We have a user who is using Outlook 2003 and moves most emails to a PST file
which is considered archived email data.
They have reached the Max limited on this PST file of 1.99GBs and its not
letting them open the PST file.
It is trying to repair it when they try to open the PST file.
Here is the message they receive:
"Can't move the items. The file <path>\<filename>.pst has reached its
maximum size. To reduce the amount of data in this file, select some items
that you no longer need, and then permanently delete them."
I can't even get it open to delete...unexpected conversion trouble
I wanted to open an Excel file I hadn't been working on for a while, an
Excel couldn't do it.
After some investigations, I found that even if the file still had th
.xls extension, it seemed to be conveted in .doc format (in fact, whe
I open it in notepad, I can see at the end some words that look like
MSWord signature). I don't know how this happened, but I'm reall
embarassed beacause i really need the data in this file.
I tried to change the extension to .doc, open the file in Word and the
import in Excel, but I can hardly see part of the file. What's more, i
is a 3-she...Copy a 2007 Word table into Excel
What is the most efficient way of copying a 2007 Word Table into excel?
Excel 2007 seems to handle this differently than it did before.
Thanks for the help
More detail would help. What's happening when you try?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"tinks" <firstname.lastname@example.org> wrote in message
> What is the most efficient way of copying a 2007 Word Table into excel?
> Excel 2007 seems to handle this d...How do I print 2 copies of a Publisher document on an A4 sheet
Can anyone help please? Using Publisher Xp forming part of Office Xp.
Setup your printer for A4, in page layout select custom, landscape, type 14.8cm
width, 20.997cm height. The dialogue should say "Prints two copies per sheet."
Mary Sauer MSFT MVP
"Wombat" <Wombat@discussions.microsoft.com> wrote in message
> Can anyone help please? Using Publisher Xp forming part of Office Xp.
...copy database to new store
We are opening another store and I would like to copy the existing database
(items, cashiers, ect.) to the new stores computer but need to delete all the
sales history and transactions. Can this be done? Any help would be greatly
Yes this can be done.
You can take the back-up and restore / install the database in the new store
You can also delete all sales transactions from the Admin.
"Larry Jenuwine" <LarryJenuwine@discussions.microsoft.com> wrote in message
news:52087...Copy formulas from one workbook to another
I'm using Excel 2007. I wanted to copy some formulas from one workbook to
another, but it becomes pictures right away (same as choices when pictures).
The paste functions work fine within the same worksheet or the same workbook.
It never happened before.
Can someone help? Thanks.
Need additional information. Example of formula you are trying to copy will
> I'm using Excel 2007. I wanted to copy some formulas from one workbook to
> another, but it becomes pictures right away (same as choices when pictur...I am in trouble
I am a student in Cambodia.I don't have any girlfriend. I tried everything.
I looked at them wrote poem to them it doesnt work. I got an account from
facebook, hi5 friendster myspace. I have 0 girl friend. What should I do? I
am so desperate. I am good looking and 250 kg only. Please help me or at
least send me some foood I am hungry
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4944 (20100314) __________
The message was checked by ESET NOD32 Antivirus.
You're tr...Trouble with Pivot Tables & Named Ranges
Can I use a dynamic named range setup in one file as a range in pivot tables
in another file?
When I have the data source file (with the named range) and the pivot report
files open, the pivot reports update just fine. But the moment I close the
source data, the pivot reports no longer can update and I get a message that
the source can't be found. If I reopen the source, the pivot tables work
fine again - but as soon as I close it up, the reports no longer work.
The source file is very large and I don't want to open it every time I have
to update all the reports tha...copying formulas #3
This is probably a simple question for most of you, but I have an exce
file that contains approx. 400 sheets, with a summary sheet. How do
copy a simple formula to read Cell B1, but the next sheet needs to rea
Cell B2 and so on. Example: Sheet #1 is the summary, then sheets 2-40
have a title taken from the summary, so if I do a typical copy formula
it keeps reading Cell B1. Hope my question is clear!!! Thanks
Ladkins's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3252
View t...Trouble with "time" in formulas
I have a time sheet that looks something like this:
A1 and A2 are set up as dropdown lists and the times in the list are i
increments of 15 minutes. WHat I'm trying to accomplish is (in cell A4
if A3 is between 15 minutes and 4 hours, then return 4 hours. if A3 i
0 or greater than 4 hours, return A3.
If I enter enter times in A1 around 00:00 and A2 a little after 00:0
it works fine... example:
I have been using my MS Publisher 2000 for over 3 years.
Just recently I attempted to access the Publisher program
and got the following message: "This application must be
installed to run. Please run setup fom the location where
you originally installed the application." I have done
everything I know to fix this including uninstalling and
reinstalling the program. I don't understand what
happened overnight nor do I understand the
instruction "run from the location you originally
installed the program". I can not access the numerous
publicaions that I have cr...Trouble sorting a table???
Using Excel 2002)
I am relatively new to Excel and can only really perform simple functions in
a basic spreadsheet.
The spreadsheet I'm having trouble with is pretty basic, but I'm having
trouble sorting some of the results from a table.
(I'll try and explain as best as I can)
I have 10 people that I'm tracking 5 different things for (dates, debts,
credits, items, number of transactions, and their balance as calculated in
this table by simple SUM functions)
I then have another table with these same 10 people with their total
balance. This is the table I'm having t...