|
How to copy from one worksheet to another
I have a worksheet that contains several worksheets. I would like to
get the information on tab Sheet 1 and copy cells (A2:O2) in a tab
name Sheet 2.
Can someone share the code to do that ? Or inform me where can I go to
read about it in order to accomplish this.
Your collaboration will be appreciated.
Luis
...
|
2 |
6/29/2007 1:08:01 PM |
|
|
show time difference
Hi
i would like to create a spread sheet that would show a time difference
between two cells ie
time due actual time if late
04:00 04:05 ?
this sheet would run for say a week so i would also like to incorporate a
graph,
i have so far managed to get the times ok, but think it needs a bit of
tweaking, as for the graph bit i am totally lo...
|
6 |
6/29/2007 10:31:09 AM |
|
|
Custom format macro?
Can I write a macro to format a number?
I have a bunch of cells containing time intervals stored as floating
point numbers in units of days. These are not dates, but are stored in
the same format. Some examples:
1 1 day
2.5 2.5 days or 2 days, 12 hours
0.125 3 hours
0.020833 30 minutes
and so on.
These values are calculated. I would like to displ...
|
9 |
6/29/2007 6:10:55 AM |
|
|
sorting sheets
I have a list of numbers that coincide with the sheet numbers... i want to be
able to click on the number on my first sheet and have it open up the sheet#
that i click on... is this possible and if so what function do i use to
direct it to do this??...
|
3 |
6/28/2007 10:06:13 PM |
|
|
How to reduce Excel worksheet view and find horizontal scroll bar
I can't see the bottom of my Excel workbook including the tabs and the scroll
bar. What can I do to fix it....
|
4 |
6/28/2007 10:00:03 PM |
|
|
Totaling a column or row of "x" s
I have several cells with an "x" in them. I am trying to get a total of the
"x"s by row and column. I am new at this and need a step by step
instruction. Thanks....
|
13 |
6/28/2007 6:34:01 PM |
|
|
Help - My tables have extra boxes around the text.
I've pasted tables from an old document into another document. The tables
now have extra boxes around the text. It looks like a table in a table, but
I can't get rid of the extra boxes. Does anyone have any ideas?...
|
2 |
6/28/2007 6:18:02 PM |
|
|
password problem
i have an old dell latitude laptop computer with xp home edition. i
hardly use this computer
and in doing so i forgot my password. i can't log in, is there anyway
to bypass the password and get into the computer so that i can delete
the password and operate with out it.
thank you
RD
...
|
3 |
6/28/2007 4:33:16 PM |
|
|
Appendig all xls files in xls 2007
Does someone have a macro or script to append a bunch of xls files in
a directory into 1 xls file? I am using Excell 2007. Thanks!
...
|
3 |
6/28/2007 3:16:51 AM |
|
|
How do I copy a formula from one worksheet to another?
I have a formula in one worksheet and want to copy that result to a cell in
another worksheet. When I try to do that, I get "#REF#" in the destination
cell. How can I make this work?...
|
3 |
6/28/2007 1:28:02 AM |
|
|
Making a list of discrete numbers (names?) and occurences of each
Here's what I have:
A spreadsheet sent to me with a list of filter part numbers, with each
vehicle having it's own row and each type of filter (air, oil, etc) having
it's own column. I would like to create from this data a sorted list of each
different filter part number, along with a count of how many times that part
number is on the sheet. Part numbers contain both numeric and alpha
...
|
10 |
6/27/2007 11:12:09 PM |
|
|
Retrieve Deleted Data
I accidentally deleted all data from an excel sheet and closed it. Is there
anyway I can retrieve this document? Please help ASAP. Thanks. G...
|
4 |
6/27/2007 10:38:36 PM |
|
|
How do I exchange data between worksheets?
Hi, I tried to do a data exchange between worksheets, should I use "Macro" or
"VB"?
To explain it in a a little detail, I got some experimental data ouput and
saved on one worksheet (named as "Cent1" under "workbook1"). I want to export
these data to another worksheet (named as "sheet1" under "workbook2") to do
some calculation. After the calculation and I want the result from "sheet1"
...
|
3 |
6/27/2007 10:06:02 PM |
|
|
Copying formatting of entire sheet
I made an Excel 2007 workbook which includes my monthly business income,
parts bought, a logbook for car mileage dividing into personal and work and
finally a financial end of year total constantly updated by the income or
parts bought over the financial year.
What I would like to know, please, is how to copy the entire logbook (12
sheets, 1 per month then 1 for end of financial year to...
|
6 |
6/27/2007 9:50:22 PM |
|
|
Delete two columns with formula
I need to delete 2 columns (with formula) and only display the last two
columns.
When I delete the first 2 columns, the last two columns display #REF!.
I know I can copy the info I need to a new sheet and paste special the
value. Is there a way to fix this on the current sheet I am working on.
Thanks....
|
3 |
6/27/2007 8:54:01 PM |
|
|
Font Color
Using Excel 2003. Made copy of a matrix I built years ago. Now want to
update it and show which cells have changed by making the font blue rather
than black. Too many changes to make by just changing the color after each
adjustment. Can't find anything that will permit me to change the font color
and make it the default while I finish the update. Can someone point me in
the right directi...
|
7 |
6/27/2007 8:36:04 PM |
|
|
NUMBER SEQUENCE GENERATOR
Hi,
I am trying to create a works requisition in Excel for our staff to use on
the pc and email to me so to make the progress a bit faster than snail mail.
what I need to do is have a 6 digit number starting at 400000 on the top
left hand corner of the page, that will go up by 1 digit each time the page
is opened untill it reaches 500000. so each job reported at the hospital will
hav...
|
2 |
6/27/2007 4:10:01 PM |
|
|
Sort rows by color
Is there a way in office 2000 to sort rows by color? I'm not good with code
and cutting and pasting over 1000 rows is becoming tiresome.
Thanks...
|
3 |
6/27/2007 2:07:06 PM |
|
|
new user needs help
Hi,
I have a stocklist (sheet 2) with 4 columns: A= LOT # B=DESCRIPTION C=BIDDER
# D=PRICE, and an invoice (sheet 1) with column A=LOT # containing this
formula: IF(A16="","",VLOOKUP(A16,STOCKLIST!$A$2:$B$501,2.0)) so the
description comes up automatically in the invoice. Now what i want to do is
have an invoice generated automatically when I enter the bidder number and
price paid in...
|
9 |
6/27/2007 12:04:02 PM |
|
|
Extracting Data
I am trying to use Excel 2000 to create a map of our boat storage areas.
There are a number of Locations such as Boat Compound and Mast Shed. There
are currently 8 such locations.
I have an MSAccess database that stores each area, combined (spaceno and
owner's name) and x & y co-ordinates.
Each worksheet has an xy scatter graph with a plan of the location
concerned, the xy plot and thank...
|
5 |
6/27/2007 7:55:06 AM |
|
|
how can I get microsoft excel to my computer windows XP?
...
|
2 |
6/27/2007 3:00:09 AM |
|
|
Erracting Mouse
Excel 2003 with 6 worksheets and HP bluetooth mouse and keyboard. The mouse
works fine on all but 2 worksheets and hangs or moves very slowly on these
2. I can email the workbook to another coworker with bluetooth keyboard and
mouse and all is fine.
Any suggestions? I did try the repair feature with no luck.
Thanks,
Lee
...
|
1 |
6/26/2007 8:56:31 PM |
|
|
Excel working in with Outlook
I have Office 2007 so obviously Outlook 2007 and Excel 2007.
I have made up a newbie's Excel spreadsheet for my business. One thing to
open that has my entire financial year's data in it and my car logbook. One
thing I am going to add to it is parts. I want to know when parts need to be
re-ordered so will set a level where I want Excel to show up basically
something like a "reorder now"...
|
5 |
6/26/2007 8:54:33 PM |
|
|
Excel Lists Dependencies
Hi All,
i have a problem to solve:
I want users to be able to pick a project from a list (no problem) and
then i want excel to pick the project number according to the project
name automatically from a list. To make my problem clear let's say a
user picks Project A from a drop down list in cell A1, then I want
excel to display the correct project number in cell B1 automatically.
Not all...
|
2 |
6/26/2007 8:20:48 PM |
|
|
Help needed for sorting the data and plotting graph
Hi All,
I am a newbie to the excel world. I have requirement of analysing some
data that I will obtain from symbian profiler. I will be having a .txt
file with values seperated with tabs so that it can be directly open
in excel. In that I have around 25 colums, first being sample interval
and rest are having data. My requirement is to plot a graph against
the sample interval with data from 2...
|
2 |
6/26/2007 8:01:00 PM |