Headers based on Cell Values
I would like to have my header variable based upon the value of certai
If there is a way to do this without VBA, that would be the best way
However, if it is only in VBA, then that is what I will have to do
kraljb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=995
View this thread: http://www.excelforum.com/showthread.php?threadid=27791
not possible without VBA. You have to use the BeforePrint event of your
workbook. So try putting the following type of code in your wo...Trying to get just part of an XML file?
This is posted to both the Word and Excel VBA NG because so far that's
the only way I can figure out to do this. But wait - I throw in FSO
to make it even messier! Using Word and Excel 2007.
We have a proprietary program that saves its working files as XML.
When a user needs to add a list of data, he's presented with either a
grid format that's a pain to work with, or a single-form-per-item page
that's easier to use but wearying after 35+ items. What I want to do
is get the part of the XML to be revised into an Excel worksheet so
the user can work easier. Because ...How can I retrieve the format of a cell?
A cell A1 is conditionally formatted so that it is either red (FF0000),
green (00FF00) or blue (0000FF). May I know if I can write a function for
another cell B1 such that it shows a word "RED" if A1 is red, a word "BLUE"
if A1 is blue and a word "GREEN" if A1 is green?
Thanks in advance.
You can use programming to determine the colour. Chip Pearson has
instructions on his web site:
> Dear all,
> A cell A1 is conditionally formatted so that it ...How do you get the sum of 2 different text values?
For instance, I need to add the amount of times "S" and "HS" appear in a row.
I figured out that the COUNTIF function will add the amount of times "S"
appears in a row, but I can't figure out how to make it add both and give me
a number value as the answer. Is this even possible?
"sunshine.girl" <email@example.com> wrote in message
> For instance, I need to add the amount o...Merge Cell Problem
I have created a new worksheet which is very basic with no formulas. I
want to merge some cells however the Merge' button on the tool bar is grey'd
out. It does not function. I have never come across this before and do
not know how to fix. Does anyone have any suggestions please. Any reply
Sounds like your worksheet is protected. Check tools>Protection, if there is
an option to "Unprotect" you have a protected worksheet. You need to have an
unprotected sheet to make this kind of change. Another option rather than
merging ...copy and pasting in 5000 records referencing cells
I have a file that is 5000 records long.
Column A Column B
Transit number associated with (a,b,c)
What I want is to have transit number appear in Column a beside each of the
The issue is the transit number is different for all 5000 records some may
have 5 per transit number and others just 3 and some have 7 depending on
size of the branch.
Is there a formula to populate this without copy and pasting in each cell?
"Fawn Lagi...Delete an image from the cell
Delete an image from the cell
I am transforming html report content (which is generated using XML and
XSLT) into Excel wroksheet. I opened the excel file and delete the image from
the cell but the excel does not allow to delete an image. I could not able to
find the properties of the cell.
How could i delete the image from the cell?
Cells can contain constants, formulae, or errors. They cannot contain
Images exist in the drawing layer above the sheet, and can be accessed
via the shapes or pictures collection.
In article <B6561E41-1068-477B-99E3-A...hello everybody.. question about .csv file...
i have a excel .CSV file that Gmail generated for me with my contacts in..
what i want to do is function that go over all the contacts emails one by
one and deletes all missformated addresses that cannot be use to send email
for them.. somthing like :
if (the cell's text is not an valid email address)
delete the cell ;
to be honest i dont know much about excel so i need somthing from
thank you all very much..
A quick and dirty check would be to look for the @ character in the cell.
You could insert a new column adjacent to the column with the data...How to get underlying Xslt content from XslTransform object
How do you get the underlying Xslt stylesheet content from an XslTransform object that has been created and loaded with a stylesheet file or some text?
Assume a method will create an XslTransform object, load it with a stylesheet file or some text, and return this object.
public XslTransform Create()
XslTransform xslt = new XslTransform();
xslt.Load("style.xsl"); //or load with some built-in stylesheet text
In the calling method, how do you see the content of the underlying transform (the content of the file style.xsl or whatever text that was loaded to the object...Custom Cell Formatting #2
Okay, I know you can enter in @*- in the custom formatting
for continued dashes across the cell,
but what if I want dashes on both side of the text? For
Can this be done in the custom format or do I have to
manually enter in all the dashes?
Any help is much appreciated.
I don't know of a format that will do this.
If you have a great whack of these to do you could enter a few dashes in a
cell by itself, say A1 has -------
Assuming Column B contains Invoice or any other non-custom formatted text.
In C1 enter =$...Transfer cell data from one worksheet to another === URGENT
I do I transfer a cell data from one worksheet in Workbook A to
another cell in another worksheet in Workbook B.
Please stay in your thread
You have an answer there already
"rajesh" <firstname.lastname@example.org> wrote in message
> bello ALL,
> I do I transfer a cell data from one worksheet in Workbook A to
> another cell in another worksheet in Workbook B.
> Thanks, Raj
...getting XL to recognize lower from upper case in IF formula
Excel 2002 SP3
Win XP Pro SP2
*Follow-up to: microsoft.public.excel*
I have an IF formula where =IF(LEFT(D3,3)="ABc",(B3*C3)/50,B3*C3)
When LEFT(D3,3)="ABC", unfortunately, it seems XL does not see the
difference between the lower case "c" in former example and upper case
"C" in latter example.
Is it me?
Can I get around this?
Use the EXACT() function
Microsoft MVP - Excel
"stef" <email@example.com> wrote in message news:%23TzKv$EOIHA.5160@TK2MSFTNGP05.phx.gbl...
| Excel 2002 SP3
| Win XP Pro SP2...losing date format when referencing date cell on another sheet and
I need to reference a date cell in another sheet in my workbook. I select
the cell that needs to display the referenced content. Then in the formula
bar I type = . Then I move to the sheet containing the cell I want to
reference. I select this cell and then click the green checkmark next to the
formula bar. The desired date value now shows up in my display cell in the
correct format. But I need to add text to this cell. Now my display date
loses its format and becomes a plane number.
Here is my reference =Sheet1!B15
Here is what I want to do = "(" & She...Search within a single cell for a character
Using VBA I want an If/Then statement to search within a single cell (D59) to
find if the ":" (colon character) exists after the fourth character. If not
"Then: Wrong = True"
In an adjacent worksheet cell I could just enter =iserr(find(":",D59,4)) and
if the result is True then I know it doesn't exist.
How do I write this in VBA?
If Instr(5, Range("D59"), ":") > 0 then Wrong = True
> Using VBA I want an If/Then statement to search within a single cell (D59) to
> find if the ":&...Will illegal immigrants get deported?.........Of course not.....................
Our politicians just wanted to blow us some
sunshine. Get the details from The Expert:
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com ***
...Meetings in Outlook are tracked in CRM and then get deleted
I have a user who is stating that he is receiving a meeting request, then
accepting, then clicking track in CRM. It seems like the next time CRM syncs
the meeting is deleted from his calendar. The meeting request is then in his
deleted items. This has happened for meetings he has been invitied to and
meetings for which he is the organizer. This will cancel the meeting and
remove it from his calendar and those of attendees. So when he drags it out
of deleted items it resends the requests. I thought because of another thread
it was due to him not actually being an attendee, but thi...VBA to Open MS Excel and get Tab names
Hoping someone can help...
I am trying to create some code in MS Access that will
1. Open up a specific MS Access workbook (portfolio.xlsx)
2. Loop through each Tab (currently there are 30 Tabs each with different
3. Set the name of the Tab to a variable in which I can access later
Does anyone know how to do this? The endgame is to eventually copy the names
of the tabs into a MS Access Table along with some of the data on each tab.
Thanks for any help...
The following procedure will open the specified Excel Workbook and return the
names of all the worksheets. Yo...Losing leading 0 when saving as .csv
I've got Excel 2002. I've got an address file that I need to save as a .csv
file. In the file are ZIP codes that begin with 0. These leading 0's are
being dropped when I save as a .csv file. Here's what I've tried so far to
keep the leading 0's in .csv:
1) In the .xls file, selected the ZIP column (column G) and formated the
cells as Text. Then saved as .xls and then saved as .csv. When I then open
the .csv file, the leading 0's are missing. If I open the .xls file, the
leading 0's are intact.
2) After opening the .csv file created in step 1, I a...Getting "Export to Excel" to display in a context menu.
We have a software package that uses a web control that customer orders are
inserted into in the form of a table. Some of our office PC's display an
Export to Excel menu item in the context menu of the web control, while
others do not. We use versions of Office from 97 to 2003 and this is
consistant across the different versions. We are trying to place
instructions in our software's help file on how to get the Export to Excel
context menu item to display so our customers can set it up themselves.
I have spent close to two days going over the Excel help file and the Office
web site and...I don't want mail recipients to get my categories and flags
This goes back to Outlook2000 and I still see it in Outlook 2003
Production. When I receive a mail item, let's say my rules assign a
category to it. Then I reply to it. If the recipient has Outlook,
they see the categories that I've assigned to that mail. If I set a
flag to remind myself to follow-up on that mail, the recipient also
gets my reminder and a flag.
I understand these can be considered features and there is a post here
just today from someone saying they use flags extensively, but I don't
want people to see the categories I assign to mail, especially if my
rules mi...Highlight rows with certain condition in some cells
I want to highlight every row that has a certain word in one column and a
different word in another column of the same row. How do I do this?
Here's a great site to learn about conditional formatting
davesexcel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31708
View this thread: http://www.excelforum.com/showthread.php?threadid=520844
> I want to highlight every row that h...Getting same message over and over and over and over each day
I'm going nuts. I belong to a website for getting financial information. I
formerly used Outlook Express but switched to Microsoft Outlook because of
the additional features. Now, I continue to receive two different e-mails
from the website over and over and over again every day. Approximately every
10 seconds and they go back two weeks. So far today I've received hundreds.
I have no idea how to stop this. Any ideas or solutions???
"goinbatty" <firstname.lastname@example.org> wrote in message
news:422BFA40-1D55-4558-9AE9-EE4182B09066@microsoft.com......Setting a cell to not go below an X value, or above a Y value
This may be very easy to do, but I just don't have a clue, I've look a
most excel variables and they just seem to choose MIN and MAX fro
columns or tables.
What I want to do is I've got the sum adding up say cells A2 and A3 i
I want cell A4 to never go below 80, or above 200. (Formula in cell A
would be =SUM(A2:A3))
Anyone think they can help
Snakey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2785
View this thread: http://www.excelforum.com/showthre...How to make the cursor stay in the cell when entering data.
I do not want the cursor to go to the cell immediately below the cell I have
entered data in. I want the cursor to stay in the cell.
Tools > Options > Edit > Uncheck Move selection after entry > OK
"Comet" <Comet@discussions.microsoft.com> wrote in message
>I do not want the cursor to go to the cell immediately below the cell I
> entered data in. I want the cursor to stay in the cell.
Tools - Options - Edit tab - uncheck the box "Move selecti...Excel 2002 : How to eliminate _ before a cell address in a formula
I am working on a report generated by a business system In Excel Format.
The table in the Excel file is a Sub Total Table that is expandable.
I need to manipulate on the data of the expanded table, however noted that
the formula below could not work as I copy downwards. The second and third
argument of the formula is fixed by "_" before the cell address E17 and D17.
Also I find that when I move the cursor to the cell for the 2nd and 3rd
argument, the resulting cell address that appears in the formula is not the...