I have a big worksheet (target) which links to different sources (say file
names A, B, C etc). However the addresses in each source linked to the target
are the same.
I can format the whole target by pasting the source A (say) onto the target

Hello all, appreciate any thoughts you might have on being able to
sync my HPiPAQ 2215 with Windows Mobile to my laptop with Vista.
Thanks!
Eddie

I am extracting a list of account numbers on one sheet (Extract), and need
to copy the extracted values to another sheet (P&L). The sheet the values are
being copied to, has formulas, for which I need to insert rows (The number of
rows are determined by the number of accounts ...

http://www.contextures.com/xlUserForm01.html
i have realised that the sample above have some limit.
for example, if inside PartsData sheet, A2 and B2 has been filled,
and i go to Input sheet to insert new data, the newly data will be inserted

It is possible to change the font color of the select cell only.
For example, If I select the cell A1 I want to see the font in blue, bold,
however, after I select the cell A2 I want the cell A1 to return to its
previous setup and get the blue, bold at cell A2.

=IF(Pace!J3>7,IF(Sheet1!AQ7<1.1,1320/FeetSecond!G4,(1320-(Sheet1!AR7*10)/FeetSecond!G4)),IF(Sheet1!AQ7<1.1,1320/FeetSecond!G4,(1320-(Sheet1!AR7*10)/FeetSecond!G4)))
Is it possible for an If to be answered by more If's ?

I have a two part question:
1. How do I automatically take data from one tab and sort the data based on
the frequency the numbers are used and paste that data into another tab
showing a column with the data and the frequency the data occurred.

I am seeking to gain a better understanding of constructing formulats using
dates and time.
a) In the formula below I enter the start date in Cell A2
b) Number of weeks in B2

Please, HELP!!!
Is there any way in which I can change a huge amount of data that is in row
format to columns???????

How do I randomly pick a set of numbers out of an array?  I have 5 columns
and 10 rows of data and I want to randomly pick 5 numbers out of this data
set how do I do that?

Is there a simplified vba code for the following routine?
Sub test()
Dim row, NextRow As Long
For row = 6 To 20

how to convert numerals to their number name format e.g.1 to one

I tried
CTRL, Shift and Enter and t doesn’t add the command that is required is
there something I missing?
Thanks ahead!

I use a particular spreadsheet everyday, and sort the data in three columns
of the worksheet many times (there is also other data that I do not sort).  I
don't have a header row.  Until recently, the spreadsheet seemed to know how
I wanted to sort, and the 'sort by' box always ...

Can I customer HYPERLINK(formulae) to specify the target location of the url?
target="_parent" is added by default.
thanks,
jacque