Humaneyes from Israel really sucks!
...need excel to repeat oddly :)
starting with number 7334
7336- 8 times
7337- 7 times
7338- 6 times
7339- 7 times
7340- 8 times
7341- 7 times
7342- 4 times
7343- 8 times
7344- 6 times
7345- 4 times
7346- 6 times
then I need it to repeat from the top, but the next number would be i
I need this to go to 761
gotzoom's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3065
View this thread: http://www.excelfo...Help with Columns
I have this excel spreadsheet from a co-worker and the
problem that i'm having is that the columns only go to AK
and I want to to go to beyond that. My question is: is
there a way to get it to show all the columns like when
you start a new speadsheet?
They might be hidden or restricted by a scroll area macro. Why don't you ask
Granite Shoals, TX
"joe" <firstname.lastname@example.org> wrote in message
> Hi Everybody:
> I have th...default appointment times problems
When i re-open outlook and go to the calender, all the appointments times
have changed to 1am on the start day - 1am on the day after it waqs meant to
finish. So a 12 day appointment is now shown as over 2 days.
How do you change the default appointment time settings so an appointment
which is just typed into the day is from 9am - 5pm for example and will stay
as a 1 day event when opening and closing outlook?
All day events are 12 -12, not 9-5. If you want it 9-5, you need to make it
All day appointment change to 1 -1 if you change the time zone or DST
settings aft...Emailing Worksheet from Excel
I am trying to email a worksheet from excel 2003. I am following th
directions, but it always attaches the entire workbook and not just th
When troubleshooting, i notice I do not have the email icon on m
toolbar, and help says this is because I do not have outlook on m
computer. I do have Outlook 2003... is there a way I can associat
these so I can send my worksheet?
Many thanks in advance
Message posted from http://www.ExcelForum.com
> Hi all,
> I am tryi...Copying certain column information quickly
As you know in Excel you could quickly copy the information you needed with a
drag of the mouse.
Because I need information copied repeatedly and easily for my access
unfirmiliar co workers.
JOB CUSTOMER QUOTE #
A B1 110701
A(copied) A2 110701 (copied)
A(copied) C4 110701 (copied)
How do I do this quickly and efficiently for the computer challenged.
Sorry, Access is a database, not a spreadsheet, and can't be used like one.
You can write some code to select the rows that you want to ...Windows Keys: Help Request
I have a problem with an Excel program that the members of our golf club use
enter golf scores. The program runs full screen and users cannot exit or
use other programs without a password.
The problem is some of the brighter young members are using the Windows keys
to access the rest of the computer. Is there a way to disable these keys?
And to disable the cool switch (alt/tab).
you should probably ask this question in a Windows newsgroup as this is
not an Excel issue :-)
Monte Comeau wrote:
> I have a problem with an Excel program ...Quick help with excel formula
Ok, i need a forumla.
this is what I want, i have two columns like this
Time Start: .............
Time Finish: ............
I fill out these two columns like this
Time Start: ...17:42...
Time Finish: ...18:25..
Now i have another Column that says
Training Length: ........
I want this to work out the time between 17:42 and 18:25
Any one help pleas
Message posted from http://www.ExcelForum.com
and format as time
If your training time can span midnight use the formula
>Ok, i need a forumla.
>this is what ...Quick Question
I have been using Office 2007 and OneNote for some time now and have recently
set up the 2010 Beta on a second system. In the 2007 version there was a
way to repair office if things went flaqky. How do I do that in Office 2010?
On Tue, 8 Dec 2009 23:59:26 +0000 (UTC), Rev. Michael L. Burns
>I have been using Office 2007 and OneNote for some time now and have recently
>set up the 2010 Beta on a second system. In the 2007 version there was a
>way to repair office if things went flaqky. How do I do that in Office 2...Help! How can I upload data and display it in Excel on client
side. Also, how can I open a book with several sheets on
client side? (It is a web application).
How would you calculate the total times if your times were entered as:
Column C:C will have 5 for 5 minutes, .30 for 30 seconds, 15 for 15
minutes. And so on... I can't seem to figure out how to tell excel
that a decimal number is seconds and a whole number is minutes. Up to
59 minutes, then my sum total time would be h:mm:ss. Thanks so much
for your help!!!
On Sun, 10 Apr 2011 18:27:59 -0700 (PDT), Dick <email@example.com> wrote:
>How would you calculate the total times if your times were entered as:
>Column C:C will have 5 for 5 minutes, .30 for 30 seco...duplicate transactions-HELP!
If anyone knows how to fix this, I would appreciate your
I am using Money 2003 Deluxe, downloading directly from
my bank (not from MSN site).
When I pay my bills online, the bill will show in the
register using the 'estimated' date it is removed from
the account (I need the 'actual due date' to show here to
avoid confusion). Better yet, when it is downloaded from
the bank and I accept the matched transaction, it is
logged in again on a different date (date cleared)
leaving a duplicate transaction.
I didn't catch this until recently and it has really
messed u...Help with sql which counts records
Could someone help me to extend this sql to include:
1. a count of txtsole where the field is a YES/NO field and I want a count of
where the answer is YES
2. a count of txtmulti where the field is a YES/NO field and I want a count
of where the answer is YES
3. a count of txtsole where the field is a YES/NO field and I want a count of
where the answer is YES
4. a count of txtnbrparts where the field is a number field and I want a
count of where the answer greater than 1
I think I need to extend the WHERE statement?
SELECT tblhvdealspt1.txtablhybrid, Count(*) AS totals, tblhvdealspt...Need help with MS Money Plus
I know that MS Money is no longer being supported, but, until my
system actually spits the app off the hard drive, I'll continue to use
When I heard earlier this year that Money was discontinued, I
purchased the last version of Money Plus. I am now attempting to
archive 2 years' worth of data. I've created the earlier year
archive, but, when I opened my primary Money file, all the earlier
transactions were still there. All the other versions of Money
removed the transactions from the primary file.
What is going on and how do I get Money to remove those transactions?
Also, ...Need formula to add increments of 0.16 seconds to time
Need assistance in development of a formula to add increments of 0.16 seconds
to time formated as 00:00:00.00 (hh:mm:ss.00).
=A2 + TIMEVALUE("0:0:0.16")
"Tim Ashcom" <Tim Ashcom@discussions.microsoft.com> wrote in message
> Need assistance in development of a formula to add increments of 0.16
> to time formated as 00:00:00.00 (hh:mm:ss.00).
Say the date/time is in A1, use:
= A1 + 16 * (1/24/60/60/100)
one day is 1 for excel...Excel Chart Problem!!! (Bug I think)
This is a multi-part message in MIME format.
Try the folloing.
1. Open Excel.
2. Paste the following data
A B C D E F=20
2008 10 20 30 40 0 10=20
3. Menu Insert/Pie (select the first Pie type)
4. Right Click one of the top of any part of the circle/Format Data =
5. Click Shadow and move any of the slides on the right.=20
See what happend on the chart.
The problem is that the ZERO generates a full circle and you can drag =
and ...Help with Outlook 2003
I have way too many emails in OUTLOOK--about 9,000 or so
and now cannot delete, nor download, and am basically
dead in the water--any advise? Tool box repair kit was
no help--Thanks for any reccomendations,
Kathy <firstname.lastname@example.org> wrote:
> I have way too many emails in OUTLOOK--about 9,000 or so
> and now cannot delete, nor download, and am basically
> dead in the water--any advise? Tool box repair kit was
> no help--Thanks for any reccomendations,
The number of messages you have has no bearing on the problem at all. Why
not post the exact text ...Budget Help
I have transaction information from January 2002 up to the
present. I want to do a budget, however, everytime I try
to create a budget there is no data from my transactions.
It is like the autobudget function does not work at all.
Any suggestions as to what I am doing wrong?
...excel macro mail send
I'm using this vb macro code for sending mail.
Dim Email As String, Subj As String, cell As Range
Dim response As Variant
Dim msg As String, url As String
Email = "" 'create list below
Subj = "Family Newsletter"
msg = "Here needs to be named range from excel(some text)"
'-- Create the URL
For Each cell In Selection
Email = Email & cell.Text & "; "
url = "mailto:" &...Excel 2007 question
I recently upgraded to excel 2007. Whenever I open one of my spreadsheets I
get a warning bar that says
Security warning automatic update of links has been disabled.
However I do not see links any where. How I can quickly locate them.
...How can I change the cursor color in Excel?
How can I change the cursor color in Excel? Normally when you stand on any
cell, the selected cell shows a black border with a dot in the right bottom.
When you have a sheet with different border styles, it is difficult to see
which cell is selected. How can I change that cell-selection-border color?
I think you problem was answered elsewhere; however, you can look at:
"Pierre" <Pierre@discussions.microsoft.com> wrote in message
> How can I change the...Help on Macro
I have searched far and wide for this! Please help. I use Word 2003
(Professional) in an on-line program. If I'm away from the program for more
than 5-10 minutes, the program shuts down.
I need a macro that will make my screen appear as if I'm using Word when I'm
not, so that the program does not shut down.
Something simple like arrowup, arrowdown, arrowup, arrowdown, or whatever.
Just so it doesn't mess up the part of the report I've typed. I think it's
called a looping macro. I need it to continue on until I'm back at the screen
and ready to type and...In Publisher my photo cuts in half and prints double, help!
I can enter photos on my flyer created in Publisher and then when I go to
enter my personal photo it takes the photo when printing and cuts it in half
and doubles it in the photo box. When I preview it before I print it, it
looks just fine and it only does it for the one photo and it is always the
agent's photo. We are in real estate. I would be happy to fax anyone a sample
so you can see exactly what I am talking about so that you could help me! I
have Microsoft Office 2003 Professional.
Pictures print multiple times in a Publisher 2003 publication
http://support.microsoft.com/def...Is there a quick way to...
highlighting only the odd or even numbered rows?
Something like this should do:
lastrow = ActiveCell.Row
Range("A6:AK" & lastrow).Select
Selection.Interior.ColorIndex = xlNone
'Change rownum to the the first row number where data occurs
rownum = 6
For i = 1 To (lastrow - rownum) Step 2
Range("B" & rownum + i & ":AK" & rownum + i).Select
.ColorIndex = 15
.Pattern = xlSolid
...A tough problem with rotas. I need Help.
This is really bugging me.
i have a weekly roster of 35 staff members in the following format
1............<<merged cells -
h..............14th.........'text entries to show date
.....Monday....'text entries of the day
4...........Staff 1............10:30 - 5:0...