Adding new rows
I have a spreadsheet with 100 rows in, I need to add a row after each
current row, is there a quick way to do this or have i got to insert
each new row individually?
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24783
View this thread: http://www.excelforum.com/showthread.php?threadid=390760
I assume you want to add an empty new row in between the existing rows.
One way would be with an extra column
Save as "trial" first.......just in case thi...BCP Computed Column
I have a table with a computed column. When I try to import data into table
through BCP it generates error due to computed column. So how to handle a
computed column while importing data into table through bcp from a text file.
You need to use a format file that tells BCP to skip that column. See BOL
for info on bcp format files.
"Muhammad Bilal" <MuhammadBilal@discussions.microsoft.com> wrote in message
> I have a table with a computed column...data labels from second column
Column A is list of names (Bob, Sue, etc); column B is how much they
collected (58, 12, etc); Column C is the date they did it on - so record 1
says Bob collected 58 on 10/07/07, for instance.
I want to create a chart with the date for the x axis, amount collected as
the y axis and data labels at each point within the graph giving the
collector's name. So at X=12/07/07, y=58 I want it to say Bob within the
Any help much appreciated.
On Mon, 3 Sep 2007, in microsoft.public.excel.charting,
Chandler <Chandler@discussions.microsoft.com> said:
&...First row in Selection range (first index of a cell)
I have a problem with selecting first cel in selection Range or return
an index of the first cell in Selection Cell.
I have something like this:
"and here I want to Select the first range in selection Range1"
I there any special function of finding first cell in selection range
or returning an index of the first cell??
Thanks for answet
> I have a problem with selecting first cel in selection...Comparing Values In 2 Columns
Hi, i have 2 list of students names both of which are not up to date
with each other and because of this one list has more students than
the other. I want to search for students names and see if there is a
match, if a match is found i need to copy the email address and paste
it into the cell by the other name in the other list. See Below
My spreadsheet has columns titled, (A)Display Name, (B)Display Email,
(C)Sims Name and (D)Sims Email. I basically want to write a script
that takes each individual display name in column A and searches in
column C for an identical match, if a match is found i...Delete 3 end row
I want to delete three end row of any sheet. any sheet has different row
Thank's for any help.
This will clear the last 3 rows of the active sheet. Note I the on error
line is to cope when there are less than 3 rows on the sheet
Dim LastRow As Long
On Error Resume Next
LastRow = ActiveSheet.Cells.Find(What:="*", _
ActiveSheet.Rows(LastRow - 2 & ":" & LastRow).ClearContents
Whe...Prinding each row of Excel sheet on a seperate page dispallying one record on each pa
From a spread sheet ,I need to print out a row on each page seperately
that is printout each record on the row on one page seperately.
Can any one please advise how it can be done ?
Row 1 Data 11 Data 12 Data 13
Row 2 Data 21 Data 22 Data 23
Row 3 Data 31 Data 32 Data 33
I would want to print out Data 11 and Data 22 on one page
then Data 21 and Data 22 on the second page and data 31 and Data 33
on the third page
Pleae advise if and hwo this is possible.
Message posted from http://www.ExcelForum.com/
Sorry ...lookup row number
can you tell me how to lookup the row number of a name in a list.
EG say I have a list of names as below:
I would normally just add a column with the row numbers and then lookup the
row number in the second column but is it possible to do without adding the
extra column by using the row formula someohow?
Try the below..
Jacob (MVP - Excel)
> can you tell me how to lookup the row number of a name in a list.
> EG say I hav...How can I compare the column names from 2 tables and output them?
I have a requirement to place an alert if the field does not exist in my
table, tblStaging. Can any one guide me to reframe this query with error
I know it is not good practice to use select * but I need to do this as my
columns\field names change each time.
INSERT INTO tblStaging SELECT * FROM tbl_XL,tblDetails;
Message posted via AccessMonster.com
Access is a relational database. If your "table design" has the fields in
your table(s) changing frequently,...Pivot Table and adding a % column, that is not in original data
Hi, Is it possible to add a column for % calculations when the % column is
not in original data? To clarify, my original data is as follows:
Produt Sales Returns Date
A 5 June
B 6 June
A 1 July
A 1 September
B 1 November
When I run the pivot table, one of the columns I'm then looking to get is a
total % of returns over sales , but I cant see how to include in a Pivot
table. I can add it outside of the table, but that has problems ...Customize global adress list column in a new mail
(I have Outlook 2007 and Exchange 2007).
when i create a new mail message, hit the "To" button, my global adress list
window appear when column by default:
Name, Title, business Phone, Location, E-mail address, Company and Alias.
Those column from Active directory of course.
My question is: can I add/remove column in this window? For example adding
"department" from Active directory?
Since this is customized by your Exchange Admin, I would start by asking
him/her if it is possible.
This question can most likely be answered in an Exchange or W...Two lines and pne column
I am trying to modify one of the custom charts to show
two line and one column rather than two columns and one
line. can anyone help.
Forget the custom type. Make a chart with all three series as lines,
select the one series, choose Chart Type from the Chart menu, and select
the Column style you want. Voila, your first custom combination chart.
There's more about Combination Charts on my web site:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech....One column into three
We have a table with about 40 columns and 120 Rows and we
need to split each column into 3 columns only for certain
rows - I'm guessing that we can't spilt a column only for
certain rows as this would mess-up the entire column/row
naming convention - so is there a way to automate the
spliting of a column into 3 rows (i.e column A becomes A,B
& C) and then merging each trio of cells (i.e. A1, B1, &
C1) into one cell in the row and retaining the data that
was in A1 and moving the data that was in B1 into D1 - for
all 120 rows and then repeating the process for each colum...Combine different checkbooks information into one safe pay file
Client has two checkbooks with the same account number. Both checkbooks are
included in one upload. In the upload file, a header record is created for
each checkbook and the client has to manually delete the second header. The
first header is required by the bank; is there a way to suppress the creation
of the second header so the client doesn't have to manually edit each upload
to remove it?
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in...Auto copy and insert a defined number of rows as defined in a cell
I don't know much about VBA but could probably work something out.
I need to produce carton labels from a spreadsheet using Word to mail merge
and the labels need to include 1 of 10, 2 of 10 on them. The number of
labels required is dependant on a number which is included for each row of
data in the spreadsheet. What I am doing at the moment is copying each row
and insert pasting the additional number of rows required. In the new rows I
then add 1 of 10 in the first row, 2 of 10 in the second row etc. etc. This
then enables me to perform the mailmerge.
I have around 300...Information service is not installed on this computer
I had Office 2007 instealled, and later installed Office 2010
Technical Preview alongside it, and this caused Outlook 2010 to
overwrite Outlook 2007.
I used it for a whilst, but experienced a lot of problems with it,
all of which required me to reinstall it, or result back to Outlook
2007. So I have now reinstalled it 4 or 5 times and keep receiving
the same problem.
Now, I am trying to use 2007 again, and when adding a data file
using the 'Mail' control panel, I receive a message saying "the
informaton sevice is not installed on this computer". I have n...Can I wrap rows of print?
I have twelve columns I must print out in a report and don't want to print on
two pages. Can I "wrap" the columns from the second page when printing so
they print beneath the corresponding information from the first page? For
Name Address City State Zip Code Cost Project Date
Name Address City State Zip Code
Cost Project Date
Not directly. Excel prints sheets pretty much as-is, with the acoutrements
available in File - Page Setup. What you could do is make a mirror sheet in
the layout you want, using links to the original. Then print that...Hide Rows
Can anyone help me with the following problem?
I have a drop down list, e.g. with 4 options.
each option is represented by a row of data, and each cell in each row
is to be entered by the user. (That means I have 4 rows of data.)
How do I unhide a certain row that is selected via the drop down list
whilst hiding the rest of the 3 rows?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to creating financial ...FRx
Is there any way to import values to a column of FRx 6.7 report from
Thanks in Advance,
You can't "import" data but you can include data from a spreadsheet in an FRx
See Chapter 4 of the FRx Report Designer User's Guide.
Charles Allen, MVP
> Is there any way to import values to a column of FRx 6.7 report from
> excel/doc file?
> Thanks in Advance,
...code to delete rows
this is probably very simple but i am new to writing code (excel 2000).
i want to scan cells M9:M999, and for every cell where the value is 0 i want
that row deleted. so for instance M9's value is 453 and row 9 will stay, but
M10's value is 0 so row 10 is deleted. so on and so forth.
thanks so much!
Do a filter (Data>Filter>Autofilter) and select a value of 0. Delete the
(remove nothere from the email address if mailing direct)
"ianalexh" <firstname.lastname@example.org> wrote in message
news:312D8E40-EBD6-426C-A98...Various ways to switch among open apps?
I've been relying on Alt-Tab to switch among open
applications since Windows 3.1. Now that I sometimes
have 10 or 12 apps open at any given time, I'm finding
that the muscles of my hand often get strained.
I really don't like the standard way that people switch
among apps: moving the mouse down to the taskbar and
clicking the icon of the app you want. Are there other
possibilities out there? Maybe there are utilities that
do this, or perhaps new hardware? Thanks for any
http://4sysops.com/archives/switcher-20-a-great-alt-tab-replacement-for-vista/...macro to search column
We're pretty good at writing macros but not that good.
We a have columns containing duplicate information - for example:
F and so on
We're trying to write macro that will "simply" say; if a value in the
column exists then copy it to the next column, but only copy it once (we
only need to know if it appears once not x number of times in a column. OR
goto the first cell; its value is "A" ; search the rest of the column for
"A" , delete all OTHER instances of "A" (but keep the first instance); then
go to cell below that and do the ...Weird rounding in Sums of columns
I have a simple worksheet in which one cell should be the
sum of a few others. It looks something like this:
A2=A1*.133, A3=A1*.12, A4=(SUM A1:A3). My problem is that
sometimes the sum in cell A4 is .01 less than it should
be. I assume it has something to do with rounding to two
decimal points. Is there a way to get A4 to equal the sum
of the actual numbers shown in the cells and not a sum
based on hidden strings of decimals? Sorry if this is
more confusing than it should be. Thanks for any help.
Go to Tools-Options-Calculation tab and turn on Precision as displayed.
-...Row, Column measurement?
What are the units? Why aren't they the same? If the row is 20 tall & the
column 20 wide, why don't I have a square cell? How do I get one?
Thanks in advance... Bob
Format,raw height 11.25
Format,column width 1.43
"Bob Newman" wrote:
> Excel 2000.
> What are the units? Why aren't they the same? If the row is 20 tall & the
> column 20 wide, why don't I have a square cell? How do I get one?
> Thanks in advance... Bob
"Sakai" <Sakai@discussions.microsoft.com...Workbook automatically unhiding rows upon opening
We have a shared workbook that our admin staff updates, and our sales staff
accesses when on the road.
Recently, some of the admin's computers, and all of the sales staff's
laptops have begun unhiding all of the rows in this workbook when they open
it. For others, the hidden rows stay hidden.
I've been tasked with making sure the rows stay hidden upon opening, but I
cannot figure out why this is happening.
It could be the two groups are actually accessing two different similarly
named files.....could be same name in two different directories....problem is