Hello,
I am trying to figure out is it possible for me too cook up a formula to achieve the desired result. What I want to do is to take random values entered into B1 column on the 1st sheet into the B1 column on 5 different sheets within the same workbook. I need this to work so I can maintain the integrity of the workbook. Is it possible?
Hi and welcome to the forum
1 way would be tio enter this into the cell where you want the value to be...
=Sheet1!B1
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ok thanks!!!!!!
My next question is how would you do this for multiple cells. For example.....lets say there values in sheet 1 cells 1-5000 B column....how would I copy those values to the next sheet cells 1-5000. I dont want to go through cell by cell entering formulas.
group all the sheets you want then enter the formulas they will be repeated on all the grouped sheets
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks! Wish I could buy you a Mojito my friend! Now one more question....can I select 1-5000 and enter some kind of formula....or would I have to though 5000 cells and enter the formula? Example in cell 1 =sheet1!B1......cell 2 = sheet1!B2...etc?
Last edited by SkillSet; 03-05-2014 at 06:09 PM.
just fill it down with the fill handle or put the first formula in say a1 then select a1:a500 then ctrl+d to auto fill
That cut the mustard!! Thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks