|
How to copy page setup
I need to open a new worksheet for a new year. (The year starts July
1st)
I have copied the previous year worksheet to a blank worksheet in
order to keep the formatting and formulae.
How do I copy the page setup for printing?
Thanks,
Robin Chapple...
|
3 |
30.07.2006 16:05:37 |
|
|
template small business book keeping
Hi all. I am a new sole trader and I am looking for some template or
something to assist me in keeping my books/accounts. I know very little about
accounting so something basic is what I need with some form of tutorial.
Is there anything online that could help me? My accounts are very simple and
really are just small basic cash jobs, no cheques, no banking charges etc
just the basic so...
|
1 |
30.07.2006 12:58:01 |
|
|
Help Modifying this Formula ....
hi, I am trying to modify the formula below to use the LEFT function..
any help Appreciated..
=SUM(COUNTIF(INDIRECT("DAY"&ROW(INDIRECT("1:31"))&"!H6:H35"),"=W"))
I tried this below, but I get a reference error:
=SUM(COUNTIF(INDIRECT("DAY"&ROW(INDIRECT("1:31"))&"!(LEFT(H6:H35,1"),"=W"))
Thanks In Advance..
--
Mhz
----------------------------------------------------------------------...
|
9 |
30.07.2006 10:33:18 |
|
|
Checking Client Status Prior to Save
I am new to VB and need to write an Excel macro that will check the other
systems on a LAN in order to make sure they are alive and capable of
accepting a saveas file.
I written a macro to perform the saveas but it comes up with an error if one
of the machines is down and will not complete the macro.
Any help would be greatly appreciated.
Jan...
|
1 |
30.07.2006 10:06:01 |
|
|
Tips and tutorials needed
Hi.
I've posted a couple of times already in the past couple of days, so
accept my apologies for bugging you if you've seen my request already,
but I'm putting together a blog or Excel tips, tricks and tutorials and
need some more input. The site is http://teachr.blogspot.com .
If you have any tutorials of your own on Excel then please email your
ideas or your tutorials to me at mattyboy...
|
1 |
30.07.2006 08:33:18 |
|
|
How can I use conditional formating between two sheets in one work
If employee number 5263 found in sheet 2, show the raw in main data on sheet
1 in red, for instance. ...
|
7 |
29.07.2006 23:05:44 |
|
|
how can I format sheet 1 if the value is found in sheet 2?
I'm all employee data in sheet 1, in sheet 2 I'm using vlookup function to
retrieve employees for whom I issued certificates on a each day. My question
is, how I can mark those employees in sheet 1 for whom Ive already issued
certificates from those for whom I didn't. I tried conditional format
function, but it didn't work, as it is in the separate sheet.
Thank you for your help...
|
3 |
29.07.2006 23:05:02 |
|
|
Tips for Excel on Pivot Tables
Hi Everyone,
Do you guys have a site similar to the site the word folks have below for
creating and manipulating pivot tables? We would like to learn how to
create pivot tables in excel 2000, we will soon be getting Office 2003 but
will be keeping 2000 also. We also have some money in the budget for some
books. Do you have any recomendations? We work in the medical field so are
no...
|
5 |
29.07.2006 23:00:09 |
|
|
limited columns?
I am working with a large data set. (It is currently a form in Microsoft
Word) I need to import data into Excel (2003) but am getting an error
message which does not allow me to import all of the data since I have
exceeded the range of columns available in my spreadsheet. I thought that i
could get around this by importing the data vertically (into columns) as
opposed to horizontally (...
|
4 |
29.07.2006 15:50:32 |
|
|
Excel Tips and Tutorials Blog
I'm currently working on a new Excel Tips and Tutorials Blog for
beginners, intermediate and advanced users alike. I need some ideas
for common problems or tips that people request on newsgroups and
searches on the internet etc.
If you could please suggest some ideas to me that I can write tutorials
for and therefore add content to my blog with I would be grateful.
Please email any ideas ...
|
2 |
29.07.2006 12:36:11 |
|
|
how to get readings in the form of degrees
I want to enter the survey reding in the sheet
survey reding contain degrees,minutes&seconds
And iam using the microsoft exel 2003 version...
|
2 |
29.07.2006 07:38:01 |
|
|
Tally The award winning accounting software full with license Keys
Tally The award winning accounting software full with license Keys
Tally was the first program for account purpose use madein 1995
tally1.2
then it has noew been developed to tally 7.2
download it tally 7.2 full with patch
splitted downloads
[code]
http://rapidshare.de/files/27303261/create.TALLY7_Full_with_crack.rar.4.exe
http://rapidshare.de/files/27303599/TALLY7_Full_with_crack.ra...
|
1 |
29.07.2006 03:35:14 |
|
|
Software License Management Template for Excel
I'm looking for a free Excel SLM template that I can use to track the
purchase and installation of software within an organization. ...
|
1 |
29.07.2006 02:21:01 |
|
|
Please Help with Formula!
Hello, I am a new user and I am having great difficulty in figuring out
something. I have a dataset in Excel with first names, last names,
states, cd sales total cost by state... and I am I started a new
worksheet cales total sales y state. Now, in this new sheet I want have
the states copied over and in the B2 cell I want to write a formula that
will enable me to have the total cost from O2:O112...
|
3 |
28.07.2006 21:10:33 |
|
|
Need help identifying a feature - driving me crazy
I created a series of worksheets that included a popup help window. Now I
wish to change the help messages on a number of cells. However, I just can't
seem to find the tool again. It is not the "Comment" tool. That is the one
that leaves a little red triangle in the upper right of the cell.
The one I need is the one that pops up and you can drag around on the
screen. Mine have black...
|
2 |
28.07.2006 20:53:18 |
|
|
auto copy old data to new cell
How does one automate the copying of old data in cell A to cell B when new
data is entered in cell A?...
|
2 |
28.07.2006 19:11:01 |
|
|
Stable formula
Let say I have this formula,
=SUMIF('TSJ Student List'!C3:C118,"=4",'TSJ Student List'!A3:A118)
My question is how can I use only rows C3:C118 and A3:A118 and the only
changes is "=4" to 5,6 ....because when I copy or drag it will change to
C4:C119, A4:A119 ..... I try to use $C3:C118$ or $c3$:$c118$ but it does not
work. Please guide me. Thanks....
|
4 |
28.07.2006 19:06:18 |
|
|
Test
Test
...
|
2 |
28.07.2006 15:59:16 |
|
|
Excel Tips and Tutorials Blog
I'm currently working on a new Excel Tips and Tutorials Blog for
beginners, intermediate and advanced users alike. I need some ideas
for common problems or tips that people request on newsgroups and
searches on the internet etc.
If you could please suggest some ideas to me that I can write tutorials
for and therefore add content to my blog with I would be grateful.
Please email any ideas ...
|
1 |
28.07.2006 15:41:15 |
|
|
Question about a formula (Excel XP)
I'm "dissecting" a budget to better understand and (hopefully) put it to use
for our oreganization. I ran across this formula is a cell:
=IF($B$13-'Cash Budget'!C37<0,0,(($B$13-'Cash Budget'!C37+'Cash
Budget'!C38)*'Unrestricted Revenue'!$B$9/12))
I understand the order that Excel will do the various mathematical
operations, but am confused about this part: "..<0,0, ..." Specifi...
|
5 |
28.07.2006 13:17:33 |
|
|
I'm having problems understanding the formulas in Excel
Learning Excel, and having problems with the formulas....
|
3 |
28.07.2006 13:06:02 |
|
|
Help With This Formula ....
HELLO,
For some reason I keep getting a "TOO FEW ARGUMENTS" error with this
formula:
=COUNTIF(OR('DAY1'!E6:E35<>"",LEFT('DAY1'!G6:G35,2)<>"GI"))
I am simply trying to use a count if 2 conditions are met... 1. if
Fields E6:E35 is not empty and 2. Fields G6:G35 Left 2 Characters <>
"GI" then count.
But The formula is not being accepted as I have it above...
Any hel...
|
12 |
28.07.2006 05:35:35 |
|
|
What is a drop down menu?
...
|
2 |
28.07.2006 00:24:21 |
|
|
Simple Macro
I am a long time lotus user and am now required to use Excell. I wrote my
first macro--a very simple one, but I want it to continue until I tell it to
stop. It runs through and doesn't complete a loop.
Here is the Macro:
ActiveCell.Value = InputBox("EnterValue")
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = InputBox("EnterValue")
ActiveCell.Offset(0, 1).Select
Act...
|
4 |
27.07.2006 21:50:49 |
|
|
Copy & paste conditional format
I have several workbooks with monthly sheets in each. I need to format one
cell to print differently than the previous cell if this cell is greater than
the previous cell. I thought I could do a conditional format and then use
fill handle to format the other cells as you would a formula and the
reference to the cell being checked would change appropriately. I even took
out the $ absolute...
|
3 |
27.07.2006 20:40:07 |