Replace cell letter
Not sure how to explain this, but im looking to save a lot of manual entry.
ie. sheet1 is fetching its data from sheet2 A1:A1000 and displays the data
all over sheet1 to many different cell positions in different columns/rows.
How do I point to new data from sheet2 B1:B1000 by replacing all the cells
"=+Sheet2!A####" to "=+Sheet2!B####" in sheet1 while keeping the same cell
positions??? Hope it makes sense...please HELP!
Try Ctrl+H to launch Find and Replace dialog..Make sure you select 'Formulas'
&qu...deleting blank rows for up to 60000 rows of data
I have worksheets with up to 60000 rows in one column I have tried using the
following macro from this site and it does not do anything. Any ideas?:
Dim i As Long
.Calculation = xlCalculationManual
.ScreenUpdating = False
Lastrow = ActiveSheet.UsedRange.Rows.Count
For i = Lastrow To 1 Step -1
If WorksheetFunction.CountA(Rows(i)) = 0 Then
.Calculation = xlCalculationAutomatic
.ScreenUpdating = True
The code works f...Hiding "0" values in pivot table
In a worksheet I have a listing of stock records with ItemNumber, Date,
StockLocation and NumberOnStock. When I make simple Pivot Table with
ItemNumber and StockLocation as rows and select a Sum of "NumberOnStock"
I would like to hide rows where the sum is "0". But this does not seem
to be possible.
Tried to follow the guidelines in the Microsoft article:
But no luck :-(
You could use conditional formatting on these cells - highlight the
cells,...Hiding formuals in cells question
Hi. I was wondering if there was a way to hide the formulas in cells without
protecting the sheet. I am making something for other teachers at my school
and I want to hide the formulas so they won't mess anything up on the
spreadsheet. Any help would be greatly appreciated. Thanks!
not without protecting the sheet but why is this a problem for you?
"JP" <JP@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi. I was wondering if there was a way to hide the fo...U.S. Payroll Extensions
I am getting the message...
"Before you can use U.S. Payroll Extensions, PTO Manager, Advanced Human
Resources, or Advanced Payroll, a system administrator must first log into
Microsoft Dynamics GP to initiallize or upgrade database objects."
I have done this multiple times now and it goes through the update and the
message goes away. But it seems to pop back up on user PCs a few days later.
GP10 sp4, SQL 2005
...Automatically Highlight Every Second Row in Excel
I would like to know if there is any way to have excel automatically
highlight every second row in a sheet to make it easier to read accross the
Can you use conditional formatting?
If yes, see Chip Pearson's site:
> I would like to know if there is any way to have excel automatically
> highlight every second row in a sheet to make it easier to read accross the
...how can i transfer data from one sheet to another without blank li
I have extracted data from a system to a sheet including blank lines between
Any idea of how i can transfer the data from one sheet to another without
any blank lines, in order to do my job using excel functions?
Thanks in advance
If you mean blank rows why dont you just sort the data?
In case you need to retain the order (you can use a temporary column);
insert an additional column say A. Number 1,2,....till the end in cells a1,a2
...... Sort col B. Delete the blank rows..and then sort by ColA...Remove ColA
Jacob (MVP - Excel)
"Manos&q...How do I stop cells from expanding?
Hey all. Just got Excel 2003, and have a real basic question.
I'm working in large files with very long cells, and everytime i click into
one to edit it, it expands to take up almost the entire screen. Problem is, i
need to look at cells in other columns, and this is a huge pain. How do i get
it to stop?
Thanks in advance!
If it is the formula bar that bothers you can turn it off temporarily under
"frodomojo" <email@example.com> wrote in message
news:FD91C628-9456-454D-9E2A-EF42F6F7F494@microsoft.co...hide my name
When replying to an email or creating one from scratch how do i hide my name
in the "from" field...thx
fred <firstname.lastname@example.org> wrote:
> When replying to an email or creating one from scratch how do i hide
> my name in the "from" field...thx
Are you saying you want the reply to be anonymous?
Brian Tillman [MVP-Outlook]
no, I don't mind if my email is revealed.. just my name. I have tried by
removing it from the "User Name:" field in the email account but it
continues to show up. I have also removed from the header informati...Wrap Text from one cell to another cell
I want type all my text into C111 (1-3 pages worth). I want this text to
automatically wrap to D111 to E111 to F111 to G111, etc.
The cell appears to have a maximum limit of characters.
> I want type all my text into C111 (1-3 pages worth). I want this text to
> automatically wrap to D111 to E111 to F111 to G111, etc.
> The cell appears to have a maximum limit of characters.
Copied from the help file:-
Length of cell contents (text) 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar.
Have y...CR's page setup
We just recently upgraded from GP 7.5 to GP9.0 and imgrated all our Crystal
Report (CR) forms ei. Purchase orders, sales order, and etc. from CR 9 to CR
11. We are using terminal services and Thin Print for printing.
My two problem:
(1) When printing a PO, a CR's page setup box appear and the paper source
would be set to something else instead of "Automatically Select",which I set
on the CR form. The users would have to select this options.
(2)Their default printer is not selected. It would show my printer as the
This two problem doesn't happen to every u...Fixing a row number for an item
Good evening all.
I have trawled through google, but to no avail - maybe I was not precise enough.
Any assistence here would be most appreciated.
I have a simple table as below:
1 Reference Cost (�) - Headers
2 115 89
3 102 25
4 026 56
5 012 99
6 155 22
7 102 12
Now I sort the table - descending (B) - (I stipulate a header row).
However I wish to be able to re-sort, to...need to display maximum value of corresponding values in excel
I have a requirement to display the maximum scored students based on the marks. i can able to display only one student if more than one scored the same marks i want to display there name also.
sl.no studentname mark
1 john 90
2 paul 95
3 sam 80
4 michel 95
using this formula =INDEX(B:B,MATCH(MAX(C:C),C:C,0)); i can able to display the value only "paul". i want to display both paul and michel.
Please help us on this.
Thanks in Advance.
=MAX((G1:G21="paul")*...How to get rows from 4 diff permitations??
Wondered if you could help.
I have 2 tables of data like so:
TID PID YEAR TERMID MATHSLEVEL READLEVEL
1 1 2006 0 W1 W2
2 2 2006 0 1B W4
3 3 2006 0 W1 W2
4 4 2006 0 2C 5A
5 1 2007 1 W1 W2
6 2 2007 ...Hiding and Un-Hiding Data fields
I am using a form for people to select data via dropdown menus and then
having it run through a query to filter results. Is there a way that I can
have certain feilds hidden until a toggle button or something of the like is
Basically I want have three choices of buttons: Year, Quarter, and Month.
What I ideally want to happen is when someone selects the button for year, a
hidden drop down menu appears where they can then choose from the available
years to filter through the query.
I would say I am above average with using access, but I have no idea how to
hide fields and then...Using Exchange 2003 features in a mixed mode w/ Exchange 2000 with
I'm researching to find out is it possible to keep my user's email accounts
using IM on Exchange 2000 and add Exchange 2003 to use the new features?
Since IM was removed from Exchange 2003, when I create a new user I must
choose between E2K or E2K3 servers, so whatever server I choose i will use
those features. Any help would be appreciated!
You can have the user's mailbox on a 2003 server and have htier IM virtual
server be on a 2k server...
Windows Server MVP
"dpcrensh...No quotes Friday for Vanguard ETF's ??
Is anyone else finding no quotes for Vanguard ETF's for Friday?
Not from within Money or on the the MSN Money website...
Vanguard Mutual funds are reported OK.
Yes and EQR as well
No Quotes on Monday 9/22/2008 also.
> Is anyone else finding no quotes for Vanguard ETF's for Friday?
> Not from within Money or on the the MSN Money website...
> Vanguard Mutual funds are reported OK.
Also noticed that realtime quotes were not available...Put Active Worksheet's Name in a Cell #3
Is there a way to put the active worksheet's name in the cell? Not the
file name of the whole workbook, just the name of the currently
Thanks for your help.
There are a few ways this can be done using either macros or functions,
here's one of each:
(sourced from Chip Pearson's site, http://www.cpearson.com/excel/excelF.htm)
I recommend checking this page out as it also shows ot...How to enable auto height with merged cells?
I previously asked a question regarding auto height with merged cells and was
given a code to enter into visual basic. I entered the code and copied &
pasted a narrative into the row. It originally seemed to work. But after
closing the workbook and re-opening it another day the 'referenced' row is
back to the original height.
Is there a way to for the row height to expand and remain sized so anyone
accessing the workbook can read the narrative? Additionall, I need the row to
remain at the full height when printing the worksheeet.
...How do I hide gaps in an Excel 2007 chart?
I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.
In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
> I have a bar chart that is showing gaps and i don't want them. The s...GAL issue
Our existing Exchange 5.5 organization consists of two different sites,
each in its own NT 4.0 domain, so call that siteA and siteB in domainA
and domainB for simplicity. They share a common GAL between them as
you would expect and all is well.
I've just installed the first Exchange 2003 server in a Windows Server
2003 AD domain (call this domainC) and placed the Exchange server into
Trusts are in place between domainA and domainB (previously), between
domainA and domainC (for the migration), but not yet between domainB
The problem that I see now is that GAL for use...Hiding a worksheet #3
I want to hide a worksheet. So, I went to the format menu and the "worksheet" option is grayed out. Why? And, how do I "ungray" it.
is your worksheet protected ?
> I want to hide a worksheet. So, I went to the format menu and the
> "worksheet" option is grayed out. Why? And, how do I "ungray" it.
I think Frank meant to ask about the Workbook--not the worksheet.
(Check under Tools|protection|Protect workbook or Unprotect workbook)
My question is: Is there another sheet in the w...Over Shipment PO's
Customer orders 2000 widgets from their vendor, vendor ships 2001, the boys
in shipping receive 2000 but the girls in accounts payable are only going to
pay for the 2000 that were ordered. What is the simplies way of handling the
overshipment quantity? This scenario messes up accrued purchases plus the 1
overshipment actually gets received at zero cost because oft times the vendor
only sends an invoice for the original quantity ordered because the goods
were packed by weight not actually counting.
I've a confusion understanding your query. 2000widgets are ordered, 2001 are
r...Hide images when Hiding Rows
I have inserted images into cells, but when I hide the column the images
are not hidden with that column, they just get squished between the two
cells next to the hidden cell. Is there a setting or way to tie the
image to that cell so that it hides/unhides appropriately with the row?
kurt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35686
View this thread: http://www.excelforum.com/showthread.php?threadid=554712
You cannot insert an image into a cell.
You can overlay ...how to hide an ActiveX control?
i have an ActiveX control, written in C++, which has the
OLEMISC_INVISIBLEATRUNTIME flag set, yet when i display the web page
it is attached to, i get the familiar "red cross" graphic in the
middle of the screen - how can i hide the control so nothing is
displayed at all?
can u set the size of ur control as 1x1 pixels
"bhu Boue vidya" <email@example.com> wrote in message
> hi there
> i have an ActiveX control, written in C++, which has the