automatic copy cells into other worksheet??
i am trying to find out how i can type text in an excel cell and have it
automatically inserted in another worksheet.
is this possible?? if so how??
hope u are ok
go the sheet2 cell A1 and type =Sheet1!A1
and Drag it
and now go to sheet1 and type something in Cell A1 and A2 and A3 and then
check them in sheet2 Colum u will find what u have written
hope it may work for uuuuu
"Matt Hall" wrote:
> i am trying to find out how i can type text in an excel cell and have it
> automatically inserted in another worksheet.
> is this possible?...Job Listing- VC++ MFC with Isofttech
Position: Technical Lead
Experience: VC++/C++ with MFC
Good to have: Wireless 802.11 Skills & Windows development experience.
5-6 years of experience.
Work Location: Chennai
Education: BE/B Tech, ME/M Tech ( CS,IT,ECE,EEE)
Do send in your CV to
...how to make all email address in my address book "safe sender"?
How to make all email address in my address book "safe sender"?
That means I wish all the contact email address in my address book are "safe
sender" and I wish to receive their incoming email without block as spam.
ay <firstname.lastname@example.org> wrote:
> How to make all email address in my address book "safe sender"?
> That means I wish all the contact email address in my address book
> are "safe sender" and I wish to receive their incoming email without
> block as spam.
Version of Outlook? For OL 2003...Copy and Paste.
Hello Folks, Hope you are all well.
What I have tried to do is select every object on a page and paste it into a
new publication. Sounds simple?
However, when I try to do this on a page which has a table in it and then
try to paste that, the size of the table goes haywire. It then becomes a
manual task again to have to resize it / put text back to where it belongs
Please can someone tell me why this is happening and if there is a way to
fix to make it a simple copy and paste. Am using Win Xp and Publisher 03.
Your help is and always has been very much appreciated.
Thanking you in ...Save a Copy/Overwrite changes dialog box
All of a sudden, this dialog box pops up every time I want to save something
in Excel 2002. The box says,
"The file '<file name>' may have been changed by another user since you last
saved it. In that case, what do you want to do?
__ Save a Copy
__ Overwrite changes
even though I'm the only user that's changed anything in the past 3 years.
The shared workbook command has not been changed at all, so that can't be the
problem. The settings are the same as the ones I have at home for personal
spreadsheets that don't have this dialog box.
Than...trouble Copying as a webpage #2
daniels012's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=868
View this thread: http://www.excelforum.com/showthread.php?threadid=27161
I Need To Get The Path Of The Image Saved In An Image List
Any One Know How
Browse to the field
Select view all field types
Cut the path from the box
Be aware the you will have extra "" around the path (just in case you are
using the path in a code)
> Hello All
> I Need To Get The Path Of The Image Saved In An Image List
> Any One Know How
I'm not sure whether this info is retained but even if it ...Listing Activesynce users
Is there a way to list the users who are actually using Activesync? I
can get a list of all the devices but have not run across a method of
seeing if they are actually sending and reciveing mail.
Jeff Senter <email@example.com> typed:
> Is there a way to list the users who are actually using Activesync? I
> can get a list of all the devices but have not run across a method of
> seeing if they are actually sending and reciveing mail.
http://www.microsoft.com/downloads...enter value based on drop down list of another field?
I have an excel 2003 spreadsheet with 3 worksheets. In sheet 1, I created a
drop down list in column A based on values in sheet 3, column A (item
number). Thisd data comes from sheet 3, where I have column A (Item #'s),
column B (Item desc)an Column C (price)
In column B of sheet 1, I have Item Descriptions and in column C I have
price. I want this to automatically fill in based on what I enter in the
column A sheet 1 and it should get the corresponding values from sheet 3
column B and C. I can make the drop down list in sheet 1 column B and C, but
some of the descriptions need ...Mailing List Duplicates
Is there a software program that works with excel to
delete duplicate names? Our mailing list is in the
thousands. Thanks for any and all help.
data>advanced filter, copy to another location and unique records only
"Gordon" <firstname.lastname@example.org> wrote in message
> Is there a software program that works with excel to
> delete duplicate names? Our mailing list is in the
> thousands. Thanks for any and all help.
...combo box list updating
Hi - I would like my combo box list to change base on the value of A1.
That is, I have its input range being B1:F1 - "Year 1", " Year 2" etc.
-If cell A1 is the value "10" then the combo box default list item would be
"Year 1" (which is cell "B1")
-If cell A1 is the value "20" then the combo box default list item would be
"Year 2" (which is cell "C1") ETC...
Thanks for your help - Jim A
...C#, .net 3.5sp1 and Visual Studio 2008 sp1 errors list
What kind of errors will the errors list show when using C# 3.5sp1 with
Visual Studio 2008sp1?
"Andy B." <email@example.com> wrote in message
> What kind of errors will the errors list show when using C# 3.5sp1 with
> Visual Studio 2008sp1?
Why would you expect any?
On the face of it vs 2008 sp1 will target .Net framework 3.5 sp1 by
Andy B. wrote:
> What kind of errors will the errors list show when using C# 3.5sp1 with
> Visual Studio 2008sp1?
That all depends on what ki...CObarray and list
Can any one give me some pointeres?
I have a CObArray, say, with 4 items.
I have a list box, of which the content is generated from the string
variables of the 4 items.
The list box is sorted alphabetically.
When a users clicks on an item in the list box, what's the best way to
reference back to the original array, i.e which array has been selected?
I can't use GetCurSel() as the list box is sorted alphabetically. I can't do
a direct comparison either as the list items are generated from a bunch of
variables within each array object. In some cases, it may be possible for
dupli...How do I get a copy of Publisher 2002?
I'd like to get a copy of Publisher 2002. I still have Windows 98 on my
computer and don't want to upgrade to XP right at this time. Other than
ordering off of e-bay or other sites I'm not familiar with, is it possible to
get a copy of Publisher 2002 that would be compatible with Windows 98?
"Crystal1365" <Crystal1365@discussions.microsoft.com> wrote in message
> I'd like to get a copy of Publisher 2002. I still have Windows 98 on my
> computer and don...need help with list box?
I have a huge table of about 20000 records. how can I restrict entry for a
I am new to excel programming.
For example. I have a list of colors (red, green, blue) that I want to go
under the Color column. how can I allow the user to click on a pulldown or
list box similar to ms access for each cell.
thanks in advance.
you could use
'Data - Validation'. See:
>I have a huge table of about 20000 records. how can I
restrict entry for a
>I am new to exc...List all row source for all forms, reports etc.
I'm doing some work cleaning out old unused forms, reports and
queries. I have been going through each report in a database (There
are A LOT), determining its row source query, then marking it for
deletion. I will eventually end up going through and deleting all the
unused queries. As you can imagine this is time consuming, and I was
thinkg 'there must be a FASTER way"
Does anyone have a suggestion, or link to a pre-built function or
model that could assist me?
On Thu, 17 Jan 2008 22:14:18 -0800 (PST), Darragh <firstname.lastname@example.org>
>Hi...MSN account list
How come I can't get a CASH account to show up in MSN. I want to enter
transaction on MSN site from work and on the road, and sync them when I get
...getting consolidate list of "follow up" items
I would like to get a consolidated list of items (sent and received
mails)that have matured - i.e. whose follow up time is up.
I have the habit of tagging a sent mail (after actually sending) for
Similarly, mails received are also tagged for my further action (for
Would appreciate a consolidated follow up report generation way -
rather that opening each folder and looking for mature items (i.e.
Thanks in advance.
...list view problems
basically I have a few questions CListViews that I'm trying to use:
1. are the rows uniform in height, and rowheight cant be adjusted?
2. How can I set column width as per my wish. i tried SetColumnWidth and
3. is there a setting so users cannot resize the column or in other words
make column width fixed?
Thanks a lot.
1. There are several ways by which you can set the row height of a list
Create an owner-draw list control and handle the WM_MEASUREITEM message,
and set the itemHeight attribute of LPMEASUREITEM struct.
Create a C...Help Creating A Formula To Copy and Paste Text
Hi everyone. Thanks in advance for any help you may have.
I need to create a formula that searches for a specific word in a
column then cut the word and paste it to another column. Of course
this would be simple if it was the only word in the column, but there
is other text that I would like to remain in the orginal column..
You have a reply at your other thread.
> Hi everyone. Thanks in advance for any help you may have.
> I need to create a formula that searches for a specific word in a
> column then cut the word and paste it to ...copy quote
We have a common situation where we will generate a quote and then need to
produce slight variations as seperate quotes. I would expect that it would
be possible to write script or some other means that would basically perform
a "quote copy". As I begin to look into the possibilities, I thought I would
see what the others may suggest to accomplish this.
Ben Vollmer's blog has a great tutorial on cloning records that can be easily
adapted to your need. Check it out at
http://blogs.msdn.com/midatlanticcrm/archive/2006/04/10/Fun_with_JScript__Cloning_a_Case_aka_How_do_...query to make a list of products based on delivery history
I have a table which lists all deliveries made of our product. From this
table, I'd like to make a list of all products. My problem is the products
will have many duplicates as they can be ordered multiple times and I just
want a list showing all the individual products that we offer.
Try something like:
SELECT DISTINCT [our product]
FROM [which list all deliveries made];
If you can't figure this out, come back with table and field names.
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Def...Programmatically adding function to copy all incoming mail to public folder (based on sender domain)
I would like to be able to (from any client) execute a script (vbs,
exe, whatever) that creates a public folder. That's should be pretty
The tricky part is that I want the same script to create a rule (?) on
the Exchange server that copies all incoming mail from a specific
sender domain to that new public folder.
Hmm... Let us assume that I have the sufficient credentials for this
action hardcoded in the script.. does anyone have a good idea how to do
I am creating an interface in our ERP software that should be able to
see mail correspondance horizontically accross ...Junk E-Mail Filter Rules
(I posted this on an old thread but not sure anyone looks back through
If I block all e-mails from a domain using "@theirdomain.com" that
works fine, EXCEPT when the e-mail address looks like "Fred Bloggs
[email@example.com]" and then it seems to get passed over and
left in the Inbox.
Should I be blocking something else?
Use a rule with specific words in the email address and make that word
Bill R MVP
"John F Kappler" <firstname.lastname@example.org> wrote in message
news:nrtta3l3nlpdc0ngvov1jcifjva0cc9igf@4ax....Copy a formula formatted as Text In Excel
I have a UDF that returns the formula of a given cell in a text
format. Is there anyway to have excel recognize that the result of
the function is a formula and not text.
Once I click on the cell, hit F2 to edit it and then enter, Excel
realizes it's a formula and then calculates the value,
The formula in the cell is going to be the UDF--not the what formula string
You could add some more steps.
Select the range (if more than one cell)
Convert to values (edit|copy, edit|paste special|values)
what: = (equal sign)