Linking many cells
I wish to link many cells in (e.g. A1:40) in sheet 1 to A1:A40 in sheet 2
without doing it one by one so that whaever I type in A1 sheet 1 appears in
A1 sheet 2. Please any idea?
As long as your 'from' and 'to' blocks are structured identically (eg 1
column of forty rows in your example), it's straightforward. Click in the
first 'to' cell, Sheet1!A1. Type the '=' sign, then click in the first
'from' cell, Sheet2!A1, then hit enter. Your formula in Sheet!A1 should read
=Sheet2!A1 (look for it in the formula bar). Grab the fill handle (th...#Deleted being displayed in a linked table
I have linked to a mainframe DB2 table and when I try to open the table or
run a query against it, the only thing that display is "#Deleted" in every
cell. I know there is data in the table as I can query using Excel and get
the correct results. Using the same simple query in Access, I retrieve the
correct number of rows but they all contain the same "#Deleted" message in
I have links to other DB2 tables on this mainframe and the results are fine.
Anybody have any ideas? Thanks.
Have you tried relinking the table? I had the same thing happen to me o...Delete Rows #2
I would like to be able to delete a row with a name in it based on a
cell with that name from another cell in a different worksheet. Any
That worked great, thank you so much.
How do I run the same macro for another name right after this one?
Gary''s Student wrote:
> This macro:
> Sub remover()
> v = Sheets("Sheet1").Range("A1").Value
> For Each r In Sheets("Sheet2").UsedRange
> If r.Value = v Then
> Exit Sub
> End If
> End Sub
&g...Importing five row list from word 2003 to excel
I have a Word five row list I would like to import into Excel in a five
column list. Every hundred items or so their is a new heading. What do I do?
If it is in a word table you can cut and paste it. But you will have to
Once you get it into excel you can sort it and delete the duplicate
Message posted from http://www.ExcelForum.com/
...Unreconciling Multiple Rows In Money
I would like to know if there is a way to unreconcile multiple rows in
Microsoft Money? I can do one at a time, but I need to do a large
number of them and don't want to do them one at a time.
I've tried to contact Microsoft directly about this but got passed to
the company that I bought my machine from, who passed me off to
another support number in their company - which tried to charge me for
asking this question.
Any info on this would be great!
In microsoft.public.money, Doug wrote:
>I would like to know if there is a way to unreconcile multiple rows in
>Microsoft ...Opening/linking .xlsx files
I have had trouble linking new .xlsx files to my existing .xls files. Excel
would shut down. So I started saving all my files in the old .xls format.
I recently created a new file using .xlsx, but when I try to reopen it,
Excel shuts down.
Are you able to open Excel 2007?
Try to create a new file and reopen it. If this does not work then try...
Close Excel first and On the Windows Taskbar
1) Start->Run-> excel.exe /unregserver ->OK.
2) Start->Run-> excel.exe /regserver ->OK.
See the space between exe and /regserver
You might have to design...how do i highlight every odd row
I have a spreadsheet that I am constantly deleting and adding rows to but in
order to make it easier to read I have every other row highlighted. Well,
everytime I cut and paste or insert I lose the formatting on that row and
have to spend more time fixing it. How do I highlight every other row and
have it stay that way?
select your range of rows
then delete the current formatting that you got
Then go to Format--> conditional formatting
Select from the drop down "formula is"
and type this
and select the desired format by selecting format-pattern
"HEA...How to paste a cells row from Excel to a PowerPoint 2003 Table row?
How to paste a row of cells from Excel to a PowerPoint 2003 Table row?
PowerPoint 2003 pastes all the row cells values in every cell in the row in
the PowerPoint table if I select the row in the PP table before the pasting.
PP pastes the row as an overlapping column if I place cursor in the first
cell of the target row before pasting.
...Move worksheet to new book
I have 14 worksheets within a workbook. In the middle are
worksheets named Sheet1, Sheet2....Sheet10 Is it possible
using a macro to see if there is anything written in cell
A1 on Sheet1, and if there is, then move it to a new book,
and then check Sheet2 and so on? And if there is no
information on the worksheet I would like to delete it.
Try this against a copy (since it destroys worksheets):
Dim wks As Worksheet
Dim iCtr As Long
Dim wkbk As Workbook
Set wkbk = ActiveWorkbook
For iCtr = 1 To 10 'sheet1 throu...coloring in rows
Could somebody please help me with the following problem?
How do I set a conditional format that if L5,M5, or N5 = �BAD� the
highlight the row yellow, otherwise leave it the standard non fil
koba's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2863
View this thread: http://www.excelforum.com/showthread.php?threadid=48371
Select Row 5. Format> Conditional Formatting. Formula is:
Set ...Conditional Formating: linking to display another cell
Hello, I am trying to make a traffic light with symbols and I've read to 'use
a separate cell for the dropdown choices, with their resulting value linked
into the formatted cell through an IF function, using the character that you
=IF someone enters '1' in B8, THEN display contents of $C$4 (will it display
font and attributes?)
=IF someone enters '2' in B8, THEN display contents of $C$5
=IF someone enters '3' in B8, THEN display contents of $C$6
But I've been reading everywhere and CF is very new to me and I need ...Worksheet Filtering by UserName
I have an excel workbook with 60 tabs (worksheets) that contain user
production data and I need a way that when someone opens up the workbook they
only see the (worksheet) tab with their information only and not the entire
workbook. Is there a way to do this in excel?
Probably the best way to do this is to create a sheet and name it something
like 'Passwords' and put a command button in that sheet and point it to this
Private Sub CommandButton1_Click()
Dim i_pwd As String
i_pwd = InputBox("Please Enter Password to Unhide Sheet", &qu...Excel CSV leaving out empty columns from row 17 onwards
Excel omitting commas in random ways !!
Anyone come across this ?
When I save this file in csv using excel 2003
A,,C,D,,21-Nov-06,27-Nov-...Solution: Error 2306: There are too many rows to output (Access to Excel using OutputTo)
I've joined the legions who've encountered this problem with the
OutputTo method in Access:
Run-time error 2306
There are too many rows to output, based on the limitation
specified by the output format or by Microsoft Access
A lot of people seem to have encountered it. The reason is because
OutputTo defaults to an old version of Excel which only allows 16K
A lot of people also suggest using TransferSpreadsheet instead, but
that caused me a lot more problems (putting a single quote in front of
my text data)
Intellisense for the command does not list what your options are for
th...Write conflict error with ODBC link table
I have migrate my back end access tables to SQL Server. While editing data
(ODBC link) from form, I receive Wirte conflict error 'The record has been
changed by other user... Copying the change to the clipboard...'. The error
allow me either copy the info to clipboard or drop change. In this case, how
can I save my work to the table here?
� "SF" <firstname.lastname@example.org> ������ ��� ������
> I have migrate my back end access tables to SQL Server. While editing data
> (ODBC link) from form, I...How to CreateTournament Worksheet
I'm not an experienced user of excel but want to create a worksheet
sheet to work in a tournament format with picture, have two picture
next to each other click on one and it moves it to the next round. I
have around 20 pictures of teams and which need to gradually reduce to
a winner in the final. Can anyone help? Is there a template to get hold
of. Thought someone will have already done some thing like this for
Jarvis's Profile: http://www.excelforum.com/member.php?action=getinfo&...Move data from column to rows HELP!!!
Hi thanks for taking the time to look at my problem, currently i have
column that has thousands of rows of information in it, it looks lik
numbers that go on into mabye the 5000-6000 range
what i need to do is have that data moved So it looks like this
A | B | C
40432 | 32432 | 532
432654 | 523 | 523
3432 | 52432 | 111
532543 | 532532 | 222
So on and so on,
so instead of 1 column with 6000 lines it ...How do I link one database inside another?
I am wanting to be able to click on a button in one database and open
another database. Thanks.
Why? As in "why open a separate database?"
Would it be sufficient to have the tables from both databases linked into a
common front-end file?
Microsoft Office/Access MVP
"julrankay" <email@example.com> wrote in message
> I am wanting to be able to click on a button in one database and open
> another database. Thanks.
if you used Access Data Projects then...Excel Question: How to Delete All Blank Rows from a worksheet?
Hi, I'm brand new, and that is my question. I just spent 2 hour
laboriously mousing along deleting row by row, every other row thinkin
there's gotta be a better way. (I could've done it of course if the
were adjacent, but they were interspersed with my good data). I'm
little behind the times: agile with keystrokes but less so with mous
[think I was quicker in Lotus DOS! (actually "TWIN")]. But I do play
Message posted from http://www.ExcelForum.com
"DaveThePianoGuy >...How do I sort a proctected worksheet
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Audrey" <Audrey@discussions.microsoft.com> wrote in message
That is a given, but I have columns that I don't want sorted.
I have locked those columns in hopes they would not sort and the others would.
Thanks for the help.
"Chip Pearson" wrote:
> Unprotect it.
> Chip Pearson
> Microsoft MVP - Excel
> Pearson...Attaching a worksheet to an e-mail
I am working with excel 2003
I would like to attach a worksheet (not the entire workbook) to a
e-mail. I would like to do it as an excel worksheet if possible but
can make it work as a body of text as well. What would the code loo
like for this.
The user is accessing my workbook file (read only) through a websit
and when they fill-out the form they click a button and the macr
e-mails the form worksheet to my e-mail address. This is an attempt a
doing "On-Line" warranty claims.
Any help or suggestions would be greatly appriciated
--------------------------------...Worksheet Help req PLZ
I have a small issue where I have created a worksheet called data and in
Cell A3 I have a linked cell to another worksheet and cell "WK48!A2" In
Cell A4 in the "data" worksheet I need a link to "WK49!A2". I would like
to link all cells in Column A to consecutively "WKxx" worksheet once I add
them to the workbook. I thought I could drag them mouse down but al I get is
links to consecutive cells in "WK48" work sheet.
Reg...paste linked cells show "0"
I have a number of cells in a range (lets say A14:J52).
Some of these cells are "paste linked" from cells on other sheets.
Unfortunately, when the original cell is empty, the value of the
"paste linked" cell shows as "0".
(not just blank like the original)
Is there a way to keep the "paste linked" cell showing "0"?
If not, how would I go about using VBA to systematically go through
the above described range and delete those zeros?
At the point I ran this code, any "0" could be deleted from the range
safely whether it ...Still column space after making row group hidden
In a SSRS 2008 report I have a number of parent level row groups which
the previous group set the hidden value of the child group. I have the
canshrink set to True of the cells however this still leaves a blank
space where the group data was.
Is it possible to remove this blank space from the report when that
row group is hidden in a tablix?
...Linking and Updating Word Text
I created a template in Publisher, including text, titles, pictures, etc. I
have 13 separate Word docs that people are changing and updating. The text
from the 13 documents needs to link into that Publisher template, to creat 13
new Publisher files. I need to accomplish two goals: a) 13 consistant
looking Publisher files, that are, b) easily updated from the Word docs
through link updates (or whatever.) I've only been able to bring over
embedded objects from Word as pictures. Thank you.
In Publisher, create a text box, right-click, click change text, click text
file, browse t...