How to copy only to cells where there is data
I have created a simple macro that, among other things, places a formula in
I2 that subtracts H2 from G2. The macro, then, copies this formula down the
entire column of I and formats column I to be "values" instead of "formulas".
That's all well and good. But I only want the macro to conduct this sort of
copying and formatting of column I only where there is data in column H. I
mean, if the data in the spreadsheet does not go past row 131, then I do not
want any data in column I that is beyond I131.
Could someone please review my macro below...SmartList Export
whenver I am exporting data from Smart List to excel or word it export junk
characters (Arabic) I am using GP 8.0 and MS Office XP
anybody face same problem please give the solutions
Make sure you're using proper collation in SQL Server.
> whenver I am exporting data from Smart List to excel or word it export junk
> characters (Arabic) I am using GP 8.0 and MS Office XP
> anybody face same problem please give the solutions
...Change Color of Header Text
Using Excel XP. Is it possible to change the color of
the text in a the header area. No option to do seems to
be available. Thank you in advance.
That's not possible
For everyone's benefit keep the discussion in the newsgroup.
"Mark Watlock" <email@example.com> wrote in message
> Using Excel XP. Is it possible to change the color of
> the text in a the header area. No option to do seems to
> be available. Thank you in advance.
...Error message when adding text to bar
Microsoft Project 2000, I am trying to add text to the right of a bar
in a Gantt Chart. Don't I select "Right", then scroll down and choose
"Text1" change the text to what I want to say, and hit OK? When I do, I
get a pop up that says "This value is not valid in this situation, Chick
the field to see if it requires text, a date, or a number, and that you
typed the information correctly.
How do I do that? I thought I did...
Thanks for your help.
Fabric8r&...Drop down text box
I can't seem to figure this out. Is there a way to make a multi-line text
box in excel, that the user can enter any text into, and have a down arrow
to click to view the entered text. I made a multi-line text box but all I
can do is set it to show a vertical scroll bar. Is there anyway to have it
show in drop down box style? I tried a combo box, but I only know how to set
it up for validation and not to get it to let me enter my own text on
multiple lines and with a drop down arrow to view the text. Can anyone help
me out? Thanks.
I'm not sure if this fits your problem, but you can ...Filling a List Box in Excel from an Array
Hope someone can help. I have a listbox in excel which I am trying to
populate from an array. The array is picking up certain values from a sheet
depending on a previous value selected in another list box. I currently have
the array code in a module.
As an example
For i = LBound(ary) To UBound(ary)
(remove nothere from the email address if mailing direct)
"Martin" <Martin@discussions.microsoft.com> wrote in message
> Hope someone ...Excel comments boxes resize after closing the file, even after co.
I set a hidden comment's size, close the Excel file, and when I reopen the
file, the comments get re-sized. I tried resetting again, but to no avail.
Is there a fix for this? I am running Excel 2002.
i have a problem with copied objects that will change automatically to match
when i don't want them to. is there any way to "unlink" them to prevent this?
Change to match what?
MVP Microsoft [Publisher]
"GCC" <GCC@discussions.microsoft.com> wrote in message
>i have a problem with copied objects that will change automatically to
> when i don't want them to. is there any way to "unlink" them to prevent
Are you using a template?
Ma...Hide Formula & Allow Copy
I would like to know how to hide the formula & allow to users to copy the
cell & get only the result (just like what past special does).
I have tried “Protect Sheet”, when I protect the sheet a user can see the
result (of the formula) but can't copy it because it is protected
I didn’t find anything (or I missed) in the promotion’s list that allows
users to copy or copy the result.
When I remove the protection the user will have access on the formula (which
I don’t want to).
In short, I want the user to see the result of the formula & have the
promotio...Copy / Paste Function & the Office Clipboard
When I copy in Excel, I am able to paste via CTRL-V or the paste tool only
so long as the copied item maintains a "moving border" (i.e., the cell is
bounded by a running dotted border). Other than recopying the cell, is
utilizing the Office Clipboard the only way to continue to paste after the
moving border is "turned off"?
Sorry about the double post. My first submission said it wasn't successful!
> Excel 2003
> When I copy in Excel, I am able to paste via CTRL-V or the paste tool only
> so long a...Copy down vlookup Formula
I want to copy down this vlookup table:
But the lookup range changes for each row i copy down
How do i copy down the formula & keep the same lookup range
Message posted from http://www.ExcelForum.com
Use =VLOOKUP(A2,$Q$2:$R$14,2,FALSE) for the range to stay the same
Message posted from http://www.ExcelForum.com
Sound, new i was doin somethin stupid!
Message posted from http://www.ExcelForum.com
=VLOOKUP(A2,$Q$2:$R$14,2,FAL...Problem exporting workbook to HTML
I work in a call centre, and we are looking at moving towards stats and all
manner of other things to a web based system.
We currently export our agent statistics from servers as csv files, run some
macros and end up with workbook with 32 tabs (one for each day of the month
and one for the monthly totals).
As we have a number of departments and managers, each sheet within the
workbook has the DATA FILTER on, enabling users to select whatever criteria
they want - works fine!
My problem - when I export the file as a web page, I save the whole
workbook, select the interactivity o...Numbers as text in excel
I have a file that is created via an online shopping cart, it saves the file as
an excel (.xls) file and does so just nicely. The problem is in the numbers.
Rather than converting a text file to excel and formatting everything as text,
I have to have the part numbers formatted as they are in a text file. All
leading zeros must stay intact.
0012345789 This is the part desc. 10.99 1(qty) 10.99
1758961233 This is another desc 1.00 3 3.00
0983201214 This is yet another 100.89 1 100.89
in the xls file it auto-formats as this:
1...How to disable paste operation on a CRichEditCtrl
VC++ 6.0 , MFC
In my application I don't want to allow the user to copy/paste text on to a
CRichEditCtrl. Basically the user copies data from a word document or
notepad and does Ctrl+V then the data gets pasted in the control.
Is there any option to disable this?
Any pointers would be of great help.
Thanks and Regards
...Hide my combo boxes!
I have a form with some combo boxes and a group box at the bottom,
the combo boxes and group box are within the section that I want to
hide, but when I select the rows to hide, the cells disappear but the
group box and combo boxes don't .
hays4's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28069
View this thread: http://www.excelforum.com/showthread.php?threadid=482783
On the Toolbar click on the Design Mode icon, Right click combobox you
want to disappe...Printing the Selection of a Message in Plain Text Format
I need to print out message daily. Very often, I only print out part of the
message. (As you know, the message included the past to-and-fro email.) I
have no problem with the message in html format -- just high light desired
area and choose the option "Selection" when print. But for message in plain
text. There is no such option. It results in printing the whole message.
This is a waste of paper. Is there any way to print selection as like as
html format message?
You can open the message first and choose Edit-> Edit Message. You can now
change the messag...unpleasant sounds when using Cut & Paste
I'm running Excel 2000 under XP Home, all Office patches &
updates applied (9.0.6926 SP-3). When I cut, copy and/or
paste (using edit or right click menu), I hear a very
unpleasant sound for each operation, something like "boin..
ggg" for cut/copy and a high pitched "swoosh" for paste.
*Occasionally*, I get a normal copy sound, never a normal
This does not happen in Word, nor in any other application
where the same editing operations are performed. - I've had
to mute all sounds in self-defense, but this isn't a
M...Exporting Contacts and info out of CRM
Can I export all of the contacts out of CRM so a user can
use them in their Outlook without CRM. We will be turning
off the CRM server and reinstalling it at a later date.
Or will the user lose all of their contact info?
Also can the data be dumped out of the database to
something like Microsoft Excel to be used to reimport
back into CRM after the new installation.
If the users have the SFO client installed, their Contacts should Synch up with
their outlook Contacts when they go Offline. As for the data, you have a few
1) Keep the old databases around for awhile....Why can't I paste an Array command from one file into another file
I readily admit to having only limited knowledge of Excel and would welcome
any advice on the following.
I have created a workbook which contains data covering a period of three
months. This file is named "Sept Oct and Nov"
One sheet called "breakdown" consists of a grid which relies on how the data
on the DATA sheet is interpreted. What I mean is that in the cells on the
grid I have an array command which consists of the following formula
...Problem with Combo box on form
I have built a database that contains a number of tables (a list is below)
TABLE: Acorn Data
TABLE: Contract Entered Data
TABLE: Payment Types
I have built an auto form using TABLE: Contract Entered Data as my record
source the form is called FORM: Input Contracts. This form has a number of
combo boxes which are linked to the table and field that contain the data.
So in table (TABLE: Sales Agent Data) there is a field (CL Code & Agent
Name) is have a combo box on my form and I have used the following Row Source
SELECT DISTINCTROW[CL Code & Agent Name]FROM[TA...Custom PO Export
I am trying to customize a PO in Store Operations Manager. I can Customize
the XML file used to print the PO and get the fields I need. My problem is
with the XSL file used to export a PO. If I customize this for the same
information the fields are empty. Is it possible to customize the data in
the export? And are there any resources on how to accomplish this? Thank you
for your Assistance in advance
...Insert text automatically into a message (Part One)
Read "Insert text automatically into a message (Part One)" on the Entourage
Help Blog for tips that will improve your productivity. It's also a great
way to save your hands if you have trouble typing.
Diane Ross, Microsoft Mac MVP
Entourage Help Page <http://www.entourage.mvps.org/>
Entourage Help Blog <http://blog.entourage.mvps.org/>
Great article, Diane!
A related point about auto-correcting that some people might find handy:
Many of the terms I insert through AutoCorr...Copy one cell to another
How can i get a cell to input the same information i type in one including
text, for example:
F3: John Doe 23023
and i want the same information that i display to show up on another cell
f20: John doe 23023
Help please thank you
In F20 write this simple formula:
> How can i get a cell to input the same information i type in one including
> text, for example:
> cell 1
> F3: John Doe 23023
> and i want the same information that i display to show up on another cell
> f20: John doe 23023
> Help please tha...Excel MAcro to insert text from one column to other
I have a worksheet in which my data is arranged as per temp. I have
Temp in one column and the corresponding value in the other. I need to
temp 25C in two adjacent columns
i have to make it Temp: 25C
and remove the 25C from that column.
Can I get some help with the Excel Macro for the same.
Using a third, helper column such as column C, you could put this formula to
CONCATENATE the two adjacent cells into one.........
Then you could highlight column C and Do Copy > Pastespecial > Values to get
rid of...list box help
I am using a list box from the forms toolbar. This is new for me. I
loaded 10 numbers of 4 digits. The output is numbers 1 to 10. I would
rather it output the 4 digit numbers instead. It looks like this is
not an option. Are there any good links on the list box? I have found
many of the bad ones.
Don't use a CellLink (assuming that is what you are currently doing);
rather, assign the ListBox to use this macro instead...
With Worksheets("Sheet1").Shapes("List Box 1").OLEFormat.Object
Range("A1").Value = .List(.ListI...