Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

How to divide multiple linked numbers by a single number

Sep 2, 2010 7:22PM PDT

Hi
im using MS office excel 2007 enterprise version.
i have a excel with a worksheet full of numbers say 'A' which are linked from another excel file say 'B'. i wanted to divide all the numbers in the excel file 'A' by a single number
can any one tell me how to do it?

Discussion is locked

- Collapse -
Dividing
Sep 2, 2010 7:28PM PDT

You change the formula from, say, =B!sheet2!A7 to =B!sheet2!A7/3. Repeat for all cells. Copying the formula using the copy handle makes it rather fast and convenient process.

Kees

- Collapse -
i tried it aready
Sep 2, 2010 7:44PM PDT

Thank you
but the issue is, this worksheet has more than 1000 linked numbers like that.I first started trying this. but it is taking lot of time. more over it is the linked from same excel file. the data are taken from different excel file.
can u tell me any other method to do it plz

- Collapse -
No other method than changing the formulas.
Sep 2, 2010 7:52PM PDT

It's up to you to find the most easy way, like:
1. Do it all apart manually.
2. Do only the unique ones and copy/paste or drag.
3. Write a macro to do it. For all cells with a formula: add "(" in front and ")/3" or even better something like ")/sheet7!$A$1" at the end.

If it's for your work, your boss may have to decide about having you do #1 or #2 or hiring a programmer to do #3. He would need an hour or 2 maybe, that's USD 200 or so. How many hours can you work for USD 200? And how many hours would you need? Then it's a simple decision.

If it's for your own use, my guess is that #2 would be faster than #3 if you have to start from the basics about VBA programming.

Kees

Kees