Example-
How can I copy date from cells A1:A5 and then paste them in cells B1:B5 sp
that the data from cell A5 is pasted in cell B1, A4 in B2, A3 in B3, A2 in
B4, A1 in B5?

I am plotting a time line for a portion of a project that we are working on
and I would like to use Excel to plot a time line for me.
If I input the months and their activities, how can I get Excel to plot my
time line?

i have a folder for using daily job , that folder is in my desktop. but that
folder is shared to use another user with another computer. my question is
how i can move that folder into d drive without loss any sharing.

On 13 October 2006 Bob Phillips posted below code. I would like very much to
use this code but I cannot get it to work I get the error message: "Compile
error Argument not optional", and the text  "DeleteCustomList" in the fifth
line from below is highlighted.

I have a spreadsheet which contains months of data for golfers. Some play
every saturday, some play when they are here on holiday. For months I have
input data and left blanks when the players were not here. This worked until
yesterday when someone asked, can we see each players ...

I received a workbook that had some formatting problems, which I fixed but, when I went to save
it I got a message that it was an Excel 2.1 worksheet.
I saved it using the overwrite option.
All is well but I was wondering what this is and if the formatting problem (rows appeared

I am trying to use Excel as sort of a catalog to store jpeg images. I am
placing one image in each cell. Some files may have several hundred images,
which makes them 150 Mb or larger. These files are extremely slow to open and
close, and sometimes will not close without freezing ...

I am attempting to create a pivot table. Everything is working fine
except for the field I want to insert in my "Data" section. The column
this field is pulling from contains numbers and I want the pivot table
to sum these numbers. Instead, it defaults to count and when I switch

I am using the index formula to read across a line of cells and return an
item code in one cell and the vendor in another cell.  The index code is
reading to return the item code and the vendor it belongs to that has the
lowest price.  

I use links to connect several sheets in a workbook. When I click on the
destination cell it shows the formula for the source cell, but when I change
the data in the source cell it does not update the destination cell. This is
not consistent and rather frustrating. Any ...

We were able to move the black cell highlighter by using the r/l/up/dn arrows
to navigate between all of our columns and rows.  Somehow now we aren't able
to do that.  Using those arrows, our whole page moves and the black box
highlighting the last cell we worked in stays in ...

I am creating a checkbook for work.  I need help with determining how to type
a number in one cell (i.e. '7245) and get it to produce the name of the
account that belongs to 7245.  This is what i have so far.  I am just not
sure what to do with the part that says 'account number' ...

When I open a specific excel doc, I know the document opened because the name
box will show a cell number (i.e. B24) but you cannot see the spreadsheet at
all.  If I open via Internet Explorer it looks fine and I can see everything,
and if I open the doc from another computer in ...

I am buying a car and I want to put the payments that i am making on a
worksheet that will automatically subtract my payments from the original
amount, lets say I am paying 5,500 paying 50.00 a week how can i create this
worksheet?

Let`s say I have one workbook which is shared by 40 different users on
a network,this workbook has 3 objects such as,userform1,textbox1 and
commandbutton1.Once commandbutton1 pressed the following code is
activeted;