software

Hey chaps. Have a .csv file that has been exported from Access with the
standard delimted export spec. This file needs to be uploaded under a certain

I have used quot;oldquot; Excel a lot. It worked fine. Now I have unfortunately
quot;upgradedquot; to Office 2003 and it is real pain moving cursor from one cell to

Does the function Randbetween use the same algorithm (Wichman amp; Hill, 1982)
than Rand in Microsoft Office Excel 2003?

I have one column of text values. I want to extract only those values that
appear more than once in the column. Any ideas?

When using Advance Filter with 'copy to another location', it would be better
if the process only used the Sheet name, an was not dependant on the active

How do I copy the header row from one tabbed worksheet such that it will
paste all formats, ESPECIALLY CELL WIDTH, to each tabbed worksheet?

Hi There,

I am trying to aggregate info from many worksheets into a snapshot view. I
need to copy various cells that have text in them so they display on the

Please assist? I'm using lookup in macro running several advance filters on a
sales database.I want a formula/function I can use anywhere in my workbook

I've got a pivot table with 26 columns and 1532 rows (based on data of 60
cols by 30,000 rows). In version 2000, when I add another field I get the