|
Copy and Pasting in Excel using VB
Thanks to everyone who helped last time. I am going to try this again.
I am trying to use a button to take a range of cells on a sheet, copy
and paste over the selected rows (in the next available column) to a
"MasterSheet" and link the cells to the original sheet, incase the
original page is updated.
If I can't do that, would there be a way to copy and paste those cells
onto a "Maste...
|
1 |
18.08.2006 13:22:28 |
|
|
Slow responce to functions
I'm using Office pro 2003. I just noticed that when I try to perform any
simple functions in excel like cut and paste, copy and paste, even when I
close a spreadsheet that I changed and when the option pops up to save, if I
say no it takes way too long to perform these simple functions. Just a copy
and paste of one cell I'll sit here and watch the hourglass for the better
part 10 to 20 s...
|
2 |
18.08.2006 12:51:02 |
|
|
Workbook Validation
I trying to change a validation list for all worksheets in a Workbook in one
entry. Can this be done?
Thanks for any help.
Gordo
...
|
3 |
18.08.2006 12:28:19 |
|
|
if - then statement or advanced fine-replace?
I'm looking to make excel automatically do a find-replace.
I could go through one sheet, do a find on each item in column A, and
replace on each number in column A by hand, but I figured there would
be an easier more fail-safe
way to have excel automatically do what I'm doing by hand.
The end result is to find out what numbers are left over after
replacing all duplicate numbers.
...
|
4 |
18.08.2006 12:20:01 |
|
|
Validation & Circular Reference Problems
Do you know of a way to create a group of Data Validation Lists that
derive their content from the same source such that each entry which is
selected causes other entries to become unselectable? For example, if I
select the 3rd item in the list, can the 4th item be striken-out,
crossed-out, shaded-out, or otherwise set apart from the others to
indicate that it should not be selected? And is the...
|
2 |
18.08.2006 09:25:40 |
|
|
lookup 2 values in different sheets
I used this formula in an Excel worksheet to find the data that
correspond to those 2 values.
I used this code for the time being :
Code:
=INDEX(C1:C10,MATCH(1,(A1:A10=Lookup_1)*(B1:B10=Lookup_2),0))
But, what if I want to look in other worksheet?
What I meant here is that I have 2 worksheets, one for table of input
and one for the output. I put the table of data in input_sheet ...
|
2 |
18.08.2006 09:23:11 |
|
|
Changing active cell within a selection with mouse-click
Hi,
I am wondering how this can be done... I know that one can move forward
and backward with the TAB key, however there has to be a way to do that
by just clicking on the cell to activate. I tried Ctrl+Click,
Alt+Click, Shift+Click, Alt+Ctrl+Click,... nothing seems to work...
Thx for your help.
Robin
...
|
6 |
18.08.2006 09:01:35 |
|
|
Linking Worksheets
How do you link Sheet1 to Sheet 2. When I update Sheet 1, I want it to
update in Sheet 2 automatically as both sheets have similar information
--
snash
------------------------------------------------------------------------
snash's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37664
View this thread: http://www.excelforum.com/showthread.php?threadid=572748
...
|
3 |
18.08.2006 08:57:44 |
|
|
link worksheet A & B
worksheet A
cell F name is called product code
cell F2 is Q921
cell F3 is Q5201
cell G name is called yarn count
but
worksheet B
cell A name is called product code same as cell F of worksheetA
Cell B name is called yarn count same as cell G of worksheetA
if user plugin cell B62 with value 1234 and cell A62 at worksheet B is
equal to worksheetA cell F2.
How it link up and automat...
|
1 |
18.08.2006 05:07:29 |
|
|
My collection of links
Hi 2 all, where is FAQ here? I wish to share with you the collection of
links concerning Internet trading, the finances, loans and work in the
forex market. Here it is:
'index' (http://fin-fin.biz/forum/index.html) 'tax lien'
(http://fin-fin.biz/forum/tax-lien-1.html) 'stock'
(http://fin-fin.biz/forum/stock-2.html) 'online trading'
(http://fin-fin.biz/forum/online-trading-3.html) 'online banking...
|
1 |
18.08.2006 04:18:57 |
|
|
More great answers
What is the difference between a Harley and a Hoover?
The position of the dirt bag.
Why is divorce so expensive?
Because it's worth it.
What do you see when the Pillsbury Dough Boy bends over?
Doughnuts.
Why is air a lot like sex?
Because it's no big deal unless you're not getting any.
'tramadol overnight'
(http://tramadols.oduuy.info/tramadol-overnight.html)
'ac adapter...
|
1 |
18.08.2006 03:18:51 |
|
|
What can I do about stress?
'120 mg xenical' (http://www.arcmd.info/pills-blog/index.html)
'120mg xenical'
(http://www.arcmd.info/pills-blog/120mg-xenical-1.php)
'buy online.broadphase.com site xanax'
(http://www.arcmd.info/pills-blog/buy-online.broadphase.com-site-xanax-30.php)
'buy online.orgfree.com site xanax'
(http://www.arcmd.info/pills-blog/buy-online.orgfree.com-site-xanax-31.php)
There is a lot of t...
|
1 |
18.08.2006 02:54:07 |
|
|
Save copy of active sheet - values and formats only
I use the code below to save a copy of my Workbook in a specific file
path (testing to see if the folders already exist along the way) with a
specific, data dependent file name. It works, but I'd like to tweak it
a bit and I'm not sure how to write the code.
I'd like to save only the active sheet instead of the whole workbook.
I'd also like to save only the values and formats to the new fi...
|
2 |
18.08.2006 02:03:08 |
|
|
Dynamic sum in Chart
Hello:
So I've got this pivot chart that I've created, and it's great, EXCEPT
when I select different categories to show up, I want to show a SUM of
the categories, not the values of each category. I would appreciate any
help/advice you may have.
Thank you!
Michelle
...
|
2 |
18.08.2006 01:53:14 |
|
|
Help me with this please... Urgent..
I have this record
----------------------------------------------
Code | File |
----------------------------------------------
0001 LEX
0002 LEX
0003 QUE
what i want to do is... when there is a duplicate file it will only
show
a FILE and its count... including the Code......
|
2 |
18.08.2006 01:48:50 |
|
|
Can you write-protect one cell at a time?
Is it possible to write-protect ONE cell at a time?
Thank you
Ann
--
aletoconstco
------------------------------------------------------------------------
aletoconstco's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35336
View this thread: http://www.excelforum.com/showthread.php?threadid=572892
...
|
3 |
17.08.2006 23:51:43 |
|
|
Autofilter
The autofilter is excluding cells that contain data with 5 characters or
less. It doesn't matter if the data is a number or text.
I checked Tools, Options and there does not appear to be anything there
that limits the filter tool. Anyone have a suggestion to correct this?
--
Gracie
------------------------------------------------------------------------
Gracie's Profile: http://www.excelfor...
|
4 |
17.08.2006 22:12:40 |
|
|
Multiple variable issue
I need to correlate data of temperature and concentration of solutions
of acetic acid in order to find its density. Density is a function of
both these variables.
I have a table that presents the density of acetic acid solutions
versus concentration and temperature. The problem is that the density
is given for variations of 1% in concentration and of 5ºC to 10ºC (9ºF
to 18ºF) in temperature, s...
|
1 |
17.08.2006 21:51:37 |
|
|
Cascading drop down filter
Hi:
When applying several filters I haven't found a way to make the dropdowns
show only the options left available after I have chosen a filter on another
dropdown. I mean like the autofilter functions works. When you filter one
dropdown the others still show all options, even those that are not available
anymore. Can anybody help me with this?
Thanks a lot in advance for your help,
...
|
3 |
17.08.2006 21:21:43 |
|
|
Currency Trading...
I'm using now new web-banking system(vollksbank), and i've recive a
warning about new iTAN transaction method applied in my account...
Any suggestions how can i use it? thanks...
_____________________
btw, try 'online forex trading' (http://forex-trading.netfirms.com)
trust me, it worth it
--
Drugmachine
------------------------------------------------------------------------
Drugmachine...
|
1 |
17.08.2006 21:08:48 |
|
|
Pasting into Word?????
This is a multi-part message in MIME format.
------=_NextPart_000_002F_01C6C12B.3A6B8FC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Does anyone have a suggestion or recommendation as to how I can cut a =
piece of some data in EXCEL (without gridlines), and paste it into =
MSWORD and not have the gridlines appear?
Thanks, in advance
...
|
5 |
17.08.2006 20:10:24 |
|
|
Rows are hiden in normal view but not printing view
:confused: I have some how "hidden" my rows in "normal" and "page break
preview". But they will show in "print preview" and print the rows.
Can you please help me get them back. :eek:
Ann
--
aletoconstco
------------------------------------------------------------------------
aletoconstco's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35336
View this thread: htt...
|
2 |
17.08.2006 20:05:36 |
|
|
Multiple Hyperlinks in 1 cell?
I have some spreadsheets that have a column with some text (4 numbers)
that link to a webpage, where the URL ends with the four numbers
(eg.1234).
Sometimes I place an additional 4-number reference to another Webpage
in the same cell, so it looks like (eg.1234/5678).
I have to get rid of the link since I only know how to set it for one
Webpage or the other.
Is there a way for users to cli...
|
4 |
17.08.2006 19:45:06 |
|
|
Email Formula
I was wondering if it is possible to put a formula in a cell that will send a
reminder email on a specified date?
...
|
2 |
17.08.2006 18:11:25 |
|
|
Online career. Find work online
Visit this site and finding links 'all about build our online career'
(http://career-online.the-search.org).
Find our career online here http://career-online.the-search.org.
--
oncars12
------------------------------------------------------------------------
oncars12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37670
View this thread: http://www.excelforum.com/showthr...
|
1 |
17.08.2006 18:02:37 |