Splitting contents from multiple repeating cells in 1st column into 4 columns
In my first column I have 4 cells (1-4) (5-8) etc. with general
The content from each of these 4 cells needs to be placed in a
column to make a list that I can sort etc.
Example: COLUMN A
2 Heatherridge Road #301
3 Harry Smith
4 H25 Condo Fairfax Place
6 McGrath Street # 56
7 Mary Jones
8 B45 Condo Lemon Circle . . . . . . and so on and so on
every 4 cells.
I have hundreds of 4 cell descriptions. I just can't do this one by
Can anyone help, PLEASE, PLEASE. I am really a novice at Excel though
use it for everything ...How to lock table on the left?
I saw a excel file, one of its table (one row) could keep in
the left sied of screen when I scrolling the scrolling bar. How to do
Thanks a lot!
Tinker with this ..
Click Window > Freeze pane
Now you can scroll right, and col A will always be in view (frozen)
or scroll down, and row1 will always be in view (frozen)
To undo, just click Window > UnFreeze Panes
GMT+8, 1� 22' N 103� 45' E
"boki" <email@example.com> wrote in message
new...Sorting Grouped Data?
I have a sales spreadsheet that is grouped by vendor with customer sales
info under each vendor. Is there a way to sort the vendor groups
keeping the customer data in each groups as is?
This may work Dan.
To sort in Excel all the lines need to have same columns to sort on. So
a heading line and a space between Vendor Groups would be be a problem
You could add 2 columns (In the Example below columns A and B) with sort
data criteria so that the Heading and Space positions could be preserved.
Column A defines the Vendor Group
Column B defines the sort priority
Then Sort b...Earn money easily! PayPal!, Don'T miss this! #2
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
...Pivot Table in a Shared Workbook
Hi! Can I use pivottables in a shared workbook? The reason I ask is that its
greyed out in a shared WB but not in a non-shared. I can't find anything on
this, perhaps somebody can help?
You can't change or create a pivot table in a shared workbook.
For more information on shared workbooks, look in Excel's Help, under
the topic 'Features that are unavailable in shared workbooks'
> Hi! Can I use pivottables in a shared workbook? The reason I ask is that its
> greyed out in a shared WB but not in a non-shared. I can't find any...backup same set of servers from 2 DPM 2007 servers
I am changing the DPM server 2007. However, I would like to take this
opportunity to revise all protection groups so that I can restore bare-metal
any server from a single lTO-4 tape if possible.
During this "transitional period," I would like to leave the existing backup
settings on the older DPM server to continue to run while adding jobs to the
new DPM server.
Looks like to me that I have to re-install the agent on all servers so that
they can be recognized by the new DPM server. IS there a better way to do
this if my plan is possible at all?
...Registration of Office products
I have installed a new server and 1 new computer in my office for a non
profit organisation. With my new computer came an OEM copy of MS OFFICE
PROFESSIONAL EDITION 2003 and I would like to install it on 3 other office
computers that are currently running OFFICE 2000 and a personal computer. Is
No. An OEM copy is licensed only for your use on the machine with which it
was purchased. You will need to buy copies for the other machines.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
I have PPT 2007. I have always wondered how to make good use of the
Powerpoint Properties dialog box.
How can Keywords and Category, for example, be put to good use? What
searching system can look inside the properties? Are any properties
useful for SEO if a presentation is posted on a website?
In article <51fec317-0258-4865-8da6-
firstname.lastname@example.org>, Alessandra wrote:
> I have PPT 2007. I have always wondered how to make good use of the
> Powerpoint Properties dialog box.
> How can Keywords and Category, for example, be...Import External Data
I'm trying to use the "Import External Data" function in Excel 2003 to
import data from one spreadsheet to another. It works for some fields
(specifically ,date and text fields), but for others no data is imported
(specifically, whole numbers, percentage fields and dollar fields). Is
there some way to import the missing data?
importing external data is usually used to import data form a REAL data
store-- like an Access database or a SQL Server database.
Basically; Microsoft is too flaky to make these simple things work
correctly. because t...rearrangimg data in excel2007 for merging into word 2007
I quite regularly have to create a list of numbered labels which are printed
on a 10 label sheet in word 2007.the list of numbers is created in excell and
then merged into the mailmerge area of word Is there a formula that I can use
in excel where I create the list that will re order the list from 1,2,3,4… to
1,11,21,31….dependant on the total number of labels needed
From the first “set of labels” to the “second set” assuming I wanted 30
labels printed the formulae would have to take into account the total number
of labels needed. The lising I create is like this ...First Pivot Table
Using Excel 2003. I created my first pivot table being guided over the
phone and didn't quite remember how I got it grouped by years and quarters
when I tried to do it on my own. I do have a screenshot of the pivot Table
Wizard -layout and in my
Page box I have Therapy Description
Row section I have Quarters and Therapy End Date
Data section I have Count of Admit Number and Average of Vent LOS
I can reproduce everything but the Quarters because I don't have that label
in my new wizard to drag over to my Row section. I have right clicked and
double cli...RE: Installation of CRM Outlook client v1.2
Hello happy hunters,
Having serious issues installing the Outlook CRM client
v1.2 on a Windows 2000 / Office 2003 (Certified Partner
copy). Have the Server v1.2 installed on a Windows 2000
Server with SQL Server 2000 SP3 and also have SQL server
existing on the client machine but have 'had' the Outlook
client v1.0 working in this config (but this was with
Office 2000 SP3 + hotfix).
I guess I made the mistake of uninstalling the CRM client
(including MSDE) before uninstalling Office 2000, and then
installing Office 2003 followed by attempting to install
the ...Outlook running very slow #2
Runnng Outlook 2000 and I have about 2,000 contacts.
Outlook moves slow in my opinion and contacts do not open
up immediately as they should.
Are there any suggestions? Can I reindex data in any way
or does anyone have an opinion on number of contacts.
...Pivot Table Help #3
I have a pivot table set up and all is ok
i have set up a macro to copy the data in the pivot table and to paste it
sumwhere else and to sort it
all is good, but when i save the spreadsheet and close it down and reopen it
and run the macro the pivot table shrinks down to 2 rows and 2 colums
how do i get my data back on show
Can anyone help
Thanks in Advance
...Pivot Table Change to US Date Format
I have a set of pivot tables which are being updated by cell the date in
cell B1 using the following code:
Month").CurrentPage = ActiveSheet.Range("B1").Value
At last this is working :) However... the dates are being inserted into the
pivot tables as new selections in US date format instead of selecting an
existing UK date format from the data choices. I do not understand this as
all source data is in UK date format, cell B1 is in UK date format, the pivot
field is also in UK da...Graphs not present
I cannot seem to be able to view graphs in Excel 2002.
Which graphs would those be? Graphs you created? Graphs in a workbook that
was sent to you?
More detail please.
Gord Dibben Excel MVP
On Mon, 12 Jan 2004 11:24:32 -0400, "DMJ" <kmd@hotmail> wrote:
>I cannot seem to be able to view graphs in Excel 2002.
...Importing a PST File #2
Further to my previous Posts.
1. I have backed up the outlook.pst file to CD using NERO
2. I have restored the outlook.pst file to a seperate
3. I have checked the file attribute and made sure the
archive bit is off
4. I have run the scanpst program over the outlook.pst
SCANPST came up with a large number of errors (I have the
file). An example is:
!!PMap page @6112768: PTYPE mismatch (read 00, expected
!!PMap page @6112768: BID mismatch (read 0, expected
When I open or import the outlook.pst file, there are 2
empty folders... recovered and deleted.
Any s...Pivot Chart #9
I want to maintain my selected color for the pivot chart. But, when i filter
the chart, the selected color will refresh back to default color.
Any idea to keep my selected color for the pivot chart even i refresh the
Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as
you apply the formatting:
Changing a PivotChart Removes Series Formatting in Excel
> I want to maintain my selected color for the pivot chart. But, when i...calendar views #2
i'm running outlook 2003 on xp and have a question about the calendar
function. from the navigation pane, selecting CALENDAR opens up the calendar
view. on the left pane it displays three months of the year stacked atop
each other. the problem is this: the view is really stretched out and
far-spaced. on my normal monitor running at 102x768 the view is fine but on
my widescreen notebook running at 1440x900, the view is stretched. grabbing
the edges to narrow the left pane does nothing but hide the calendar; it
doesn't shrink the spacing and constrain it. has anyone...newbie: How can I get the querystring from the presenter?
I wonder how I can get the querystring from within the presenter?
> asp.net 4.0
> I wonder how I can get the querystring from within the presenter?
Sorry, I thought there was only one type of presenter in the .net framework
"Mr. Arnold" <Arnold@Arnold.com> wrote in message
> Jeff wrote:
>> asp.net 4.0
>> I wonder how I can get the ...Export Exchange 5.5 data
I'm somewhat familiar with the format of the Comma Seperated Value (csv)
file for the Exchange 5.5 directory import/export procedures.
Is there a setting to allow me to capture the last login information for a
You can use the header.exe file to determine the names of the available
attributes to export and create an export file for you.
For your specific task, you can always use the Exchange Administrator
application to display the last logon time and then choose File / Save
Window Contents to create a suitable file.
For Exchange news, links, ...Arrays and names #2
Using XL2002 but needs to be XL97 compatible.
With ActiveCell Transactions!F6
I have defined a local named range Transactions!Test
Assets!Category_Range is a name that refers to an absolutely defined single
column of data
The relative reference to row 6 in the above is intentional but probably not
relevant for what follows.
Evaluating the array Transactions!Test produces something like this:
This is correct and predicted behaviour.
I want to create another local named range...Pivot Table Percentage of Grand Total Column
Here is my problem. I am using Pivot Table to summarize financial data
to preform a margin analysis on it. Currently I receive a dump of data
from the system which turn is put into the pivot table. The way the
pivot table is currently displayed is as follows:
Sum of Amount Account
Customer 40000 43000 50000 Grand Total
ABC $4,000.00 $(50.00) $(3,000.00) $950.00
PDQ $6,000.00 $(350.00) $(4,000.00) $1,650.00
XYZ $5,000.00 $(500.00) $(3,500.00)
Grand Total $15,000.00 $(900.00) $(1...Report on a refreshed table coming up blank
I build a summary table based on many other tables using VBA. Here are the
- Clear the table
- Insert records from source tables with calculated fields defaulted to 0
- Fill in calcuated field in the table
- Print Preview the report based on the table.
Problem: The report prints with the calculated fields still at 0. I look at
the table and fields are not 0. If I close the report and open it again
prints the correct data. It almost seems like a timing issue.
Help Please it is dirving me insane!!
You must have a complex or unusual application to need to create a table
from which to...RMS 2.0 & Quickbooks pro 2010 Mapping
I am tring to update quick books with sales infromation from RMS to get a
more accurat P&L from quickbooks with all exspences not just gross profit how
can I map daily sales to go to Quick books from RMS I
Pleas drop an email to discuss.
> I am tring to update quick books with sales infromation from RMS to get a
> more accurat P&L from quickbooks with all exspences not just gross profit how
> can I map daily sales to go to Quick books from RMS I
my email is