Referencing merged cells
I'm having trouble referencing a merged cell in another workbook.
Say I merge cells A1 to C1 in workbook 1. When I make this the active cell,
the Name Box says "A1". When I go to another workbook (say, workbook 2), go
to cell B1, type "=" and then go to the merged cell and select it, I get
'workbook1'!$A$1:$C$1 as the formula and, of course, the "#VALUE" error.
I've successfully tried typing "=sum(" without the quotes hen clicking on
the contents of the cell and then adding the ")" and it works O.K. but there
should be an easi...Axis label that corresponds to cell
I have an interactive graph which graphs data from a set column. This
column changes depending on what is selected on a list selector. I was
wondering if there is a way to label the y axis whatever was in, say
I was hoping that that this would be something easy that I could write
into the excel chart wizard, like =$AD$11, but it is not. Any help
would be appreciated.
pete3589's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28402
View this thread: http://www.exce...Finding the currently selected cell in another worksheet
In Excel 2002 I want to display the current row of worksheet A in worksheet
B (in another format).
Does anyone know how to do this? Ideal would be if this updates
automatically, but performance wise I guess a macro activated by a button in
worksheet A would be the best solution.
I don't know of a way in a formula to determine the active cell of the
worksheet. Worksheets other than the active one don't have an active cell.
I think macros are the only way. Put this in a regular module:
Public Roww As Long
Put this in the sheet A module:
Private Sub W...Auto fill cells with dates, exclude weekends?
What I'm doing is filling in multiple cells with dates
(by dragging and filling) automatically. I was wondering
if there was anyway for it to skip the weekends within
Thanks in advance.
rather than dragging with the left mouse button down, drag with the right
.... when you let go you'll see an option for fill weekdays.
"Sam Weber" <email@example.com> wrote in message
> What I'm doing is filling in multiple cells with dates
> (by dragging and filling) automatically. I was wo...Easy formula question -sum of 1 cell to end
Thanks for looking .
How do you format a formula to display the sum of, let's say A1 to "however
far down the spreadsheet goes" without having to name an ending cell?
This sheet has no end and I need to display the total in a column that keeps
I hope I phrased this correctly.
You could do it this way =SUM(A:A), that will cover the full column.
"Edward" <firstname.lastname@example.org> wrote in message
> Thanks for looking .
> How do you format a formula to display the sum of, let's say ...matching full name to 'two column' name using sumproduct
Assume your names in Sheet1 are in column A, the dates are in column
D, and the values you want to add are in column F. Further assume that
the target_name in this_sheet is in A2. Try this formula in a cell in
This formulae works very well (thanks to Pete for his help), however I need
to use the same formulae to match the name in A2 to a spreadsheet that has
the name to be matched to in two columns (first name (col A), last name (Col
I currently use the following to match names i...working with named lists
Im currently working with named lists and through vba i need to go and
find on what row the list starts can Someone help me out ?
msgbox worksheets("sheet1").range("Mynamehere").address 'or .row
If you work with names, do yourself a favor and get a copy of Jan Karel
Pieterse's (with Charles Williams and Matthew Henson) Name Manager:
You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp
"Alexandre (www.pointnetsolutions.com)" wrote:
> Hey guys,
> Im currently wor...How do I ignore blank cells while averaging the solutions of equat
I'm trying to average (items produced/manhours/workers) over the course of a
week. The problem is each job isnt worked every day, so I have blank cells
in my equation. Here is what I'm typing:
I know there is a way to ignore #DIV/0 results, but I'm fairly new to Excel.
I'm also trying to keep this all in one row to save space. Any help will be
take a look at the subtotal function and see if it meets your needs.
I wonder if somebody could help me with the following problem:
I have two columns with cells containing some values B1..B22, C1..C22
everyday I add a new cell e.g. B23 and C23, B24 and C24,...
I wonder if I use these cells in a forumla like REGR how to write
in order to avoid updating the formula every day? REGR(B1:B22;C1:C22)
You could create a dynamic named range for each of your
ranges. In your example, if you have no data below your
list you could:
Input the name then in 'Refers To' type =offset
...Query to show empty cells
I am doing a database for addresses and would like to run a query showing the
addresses that are empty. What should I put in the criteria to show an empty
Try out the query with IsNull as criterion.
If the message was helpful to you, click Yes next to Was this post helpful
If the post answers your question, click Yes next to Did this post answer
> I am doing a database for addresses and would like to run a query showing the
> addresses that are empty. What should I put in the criteria to sh...How do I add the same text to numerous existing cells
How do I add the same text to numerous existing cells without having to
repeatedly type the text? Ex. adding .gif to XXE1149J, XXE1130J...
"Wanda_pb" <Wanda_pb@discussions.microsoft.com> wrote in message
> How do I add the same text to numerous existing cells without having to
> repeatedly type the text? Ex. adding .gif to XXE1149J, XXE1130J...
Thank you, that was very helpful, but I guess I should have mentioned there
were "/" also in the text. When I did your sugge...Combining date and time into one cell
I have the date (m/dd/yy) in one cell and time (hh:mm) in another cell. How
can I merge these two in one cell with the format m/dd/yy hh:mm ?
Date in A1, time in B1, combined in C1: formula is =A1+B1 and format as you
On Sat, 22 Jan 2005 14:03:02 -0800, "Kelly C"
>I have the date (m/dd/yy) in one cell and time (hh:mm) in another cell. How
>can I merge these two in one cell with the format m/dd/yy hh:mm ?
is one way
HT...When you click a hyperlink in a cell i get a Warning message
This message is about harmfull files and gives you an OK and CANCEL. Is it at
all possable to disable this particualr message because i have a document
full of hyperlinks and its getting anoying!!!! Thanks.
...excel's active cell
how to highlight the active cell with a color each time it moves
angelaexceluser, have a look at Chip's addin here for one way to do it,
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"angelaexceluser" <email@example.com> wrote in
> how to highlight the active cell with a color ...Excel VBA
Is it possible to use VBA in one workbook to copy a worksheet fro
another workbook into another different workbook?
Message posted from http://www.ExcelForum.com
try recoding a macro while doing this manually. And yes it is possible
"cjh1984 >" <<firstname.lastname@example.org> schrieb im
> Is it possible to use VBA in one workbook to copy a worksheet from
> another workbook into another different workbook?
...Changing formula in multiple cells or range simultaneously
I am trying to change the value in multiple cells in a
large worksheet simultaneuously. I want to identify the
range and then adjust the formula in the entire range. Is
there a way that I can highlight the range and then change
to formula in each, simultaneously? For example, if I
wanted to double the value in the entire range, how would
I do this?
You could put 2 in an empty cell.
Edit|Paste special|click on Multiply under the operation section.
Then clear out that 2.
But it really depends on what kind of change you're making. If you wanted to
ad...Outlook 2000 display name
Trying to change the display name of an account in
Outlook 2000 SP-3
Windows XP machine
But I can't find the option to do it, all I keep on
getting is e-mail services and nothing that says accounts
even when I go through options.
Any help would be appreciated
Corp/Workgroup mode does not use the term account. Your Internet Mail
Service is your email account. Set the name there in Properties
"Miranda" <email@example.com> wrote in message
> Trying to change the display n...Copying one cell to muliple cells #2
Cell a1 is a date cell. Cells b1-b30 are date cells. What I am trying to do
is every time that I enter a new date in Ai, I want it to go to a blank cell
in b column and not over write the dates that are already there.
right click sheet tab>view code>copy\paste this>format col B as desired date
Now when you put a date in a1 such as 8/1, the last cell+1 in col b will get
Private Sub Worksheet_...The sheet path file name ?
Hi all ,
How can i edit in a cell a formula to retrieve the whole path of th
sheet and not only the file !
Thank you veru much
gaftalik's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=645
View this thread: http://www.excelforum.com/showthread.php?threadid=48453
If you can use a UDF in your workbook then you could use one like so
Function FullPath() As String
FullPath = ThisWorkbook.FullName
Microsoft MVP - Excel
Sout...changing report headings names
I would like to give the user the option of changing the report heading
names, I can do this with the Docmd.openreport, stdocname,
acviewdesign,,,achidden and then grab the current heading and display that
heading and allow the user to change it. I then do a docmd.close acreport,
stdocname, acSaveYes, this works just fine when I test but when I compile the
program into a mde it doesn't like the it. Is there another way of doing
this? Thanks for any help.
you can write the current heading names to a table, making sure the table
holds only one record. add the table to the quer...Long Description? Manufacturer name? Images?
We ahve GP 8.0 and want to add an additional long description to items
(short paragraph). Is there a field the either is created for this or could
be used for this purpose?
Same thing with Manufacturer. We want to be able to store this information
in it's own field attached to the item.
And anywhere for images?
This is Angela; I'd be happy to help you with your question today. Thank
you for using newsgroups.
It looks like you want to add a long description (...Outlook email attachments displaying in name order?
When opening an email with multiple Word document attachments is there a way
to display the attachments in name order?
Your help would be greatly appreciated.
Annabel Hurdman <A.Hurdman@btinternet.com> wrote:
> When opening an email with multiple Word document attachments is
> there a way to display the attachments in name order?
> Your help would be greatly appreciated.
They should display in the order the sender attached them.
No they don't. I attach them in name order from Word. The client then
opens the email and they are not in the same...Display names in Global address book do not update
I made a change to one of my users so that their display name shows as last
name, first name. This change has not been applied to the global address
book, but you can see the change has been made in active directory users and
computers. Any idea how I update this change for the global address book?
YOu need to wait for the global catalogs to refresh.....depends on your AD
"Mike Fefferman" <firstname.lastname@example.org> wrote in message
>I made a change to one of my users so that their display name show...Cell Formatting to disp. ### numbers
I am trying to format the cells so that it only allows three numbers t
To be more descriptive:
We work with zip codes quite often, but, we only use the first thre
Someone sent us a xls file with 12000 zip codes, in one column, and
need to know how to make the column show only the first three digits o
all the zip codes..
there is another problem, when I convert them to a numeric value, i
removes the zero in front...ex. 08245, becomes 8245, but i need to kee
that zero in front.
Message posted from http://www.ExcelForum.com
Assuming your zip codes a...How do I insert a row of blank cells?
I need to know how to insert a row of blank cells every other row in the
columns from F to I ONLY!!! I currently have just a straight set of data in
those columns like data-data-data-data-data-data. I need to have it
alternate data-blankrow-data-blankrow-data-blankrow- as I go down from row to
row. I need to do this for about 1000 rows so I need a quick way to do it if
there is one. HELP!!!
Looks like this:
I want this:
-open the VB editor
-double click the sheet of interest
-View from the menu--> Code
-Paste the belo...