Hello,
I have a table that is 94 columns *12 rows each cell has a different number I need to find a way to duplicate the table but with the numbers in each of the cells doubled.
Any ideas?
Cheers
Martyn
Hello,
I have a table that is 94 columns *12 rows each cell has a different number I need to find a way to duplicate the table but with the numbers in each of the cells doubled.
Any ideas?
Cheers
Martyn
Last edited by martynduerden; 07-03-2009 at 07:28 PM.
Type 2 in any empty cell. Copy that cell, select your table, Edit > Paste Special and select multiply.
WOW>
I thought I was in for a few days of typing !]
Thanks very much :D
Martyn
martynduerden
Before using StephenR suggestion:-
You will need to copy your existing table to the location you reuire the doubled table to be located 1st
After using StephenR suggestion:- remove the 2 that you entered into the blank cell
Edit - Thread marked Solved as I was replying
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks