Linking a number automatically to several sheets

  • Thread starter Thread starter Kenneth
  • Start date Start date
K

Kenneth

I'm trying to complete a billing sheet, and I can't figure
out how I could type a number in one field, and it will
copy to several other sheets. I.E. I type 10.99 in field
B6, and I have a total of nine worksheets. How can I get
that 10.99 to automatically show up on all the sheets, in
that exact field for each sheet?
 
Thanks a million....but I have just one more question ( i
know i seem like an idiot). We are in a hospital, and bill
each floor supplies. The lasr sheet is a pricing sheet. Is
there anyway I could change a price of something, and that
number would go into the correct pricing field. I.E.
Washers 1900.00 .....is there a formula i could use to
specify the fields I want to use on each worksheet?

Thanks again
 
You could just link to the master sheet =mastersheet!a1 or do a macro with
an array range.
 
Back
Top