Auto Copy a Value from a Cell and Paste it in Another Cells in another row
i need a ms excel formula which automatically do like this
it should copy the value inhope you understand, if not please let me know. i will try to expand my question thank you!
`B1` and should paste it from `A1` to `A7` and then copy the value in
`B8` and should paste it from `A8` to `A14` and then copy the value in
`B15`and should paste it from `A15` to `A21` and so on...
waiting for your answer.
(my excel version : 2007)
In A1 = B1
In A2 copied down
= IF(MOD(ROW(),7)=1, B2, A1)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks