Floating cells


R

Rockbear

Hi boys and girls

I have a sheet where i put my bills, and have a list with the accounts I
need to put them in, and want that list to follow me on my way down on the
rows with bills.

A1 B1 C1 D1 F1

Date Text on bill Account Amount Account and
explenation

There are 20 accounts in column F that I want to "float" as i use the rows
for putting in bills
I have frozen row 1, so its easy to se where to put the date, text on bill,
account and amount

Any suggestions??

Rock
 
Ad

Advertisements

S

Shane Devenshire

Hi,

Why not highlight the column and choose Data, Validation from the Allow drop
down pick List and in the source box enter = and the range where you choices
are (column F)

when you move to any cell in that column you will have a drop down list with
all the choices.

If this helps, please click the Yes button

Cheers,
Shane Dvenshire
 
Ad

Advertisements

R

Rockbear

Hi
They wanted also the text from the account in the col. G to be in the list
they can choose from, is that possible in any way?

F is accountnumber, G is the explaining text of the account in F
Ex:
5340 Cost repairing office machines

Can one do in any way?

Rock
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top