Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Cell Data in Multiple Places
I have a worksheet named "List" that contains data (text and numbers) in
column A and column B. I'd like a macro with a click button to create a new tab with the name equivalent to the value of cell B6 on the worksheet "Unit Names" and based on a worksheet called "Template". The data in column A of "List" needs to be added to the new worksheet, transposing the value of cell A1 on List to cell B1 on the new worksheet while the data in cell B1 needs to be added to B2 They then need to be continued across the rows. So A1=B1, A2=C1, A3=D1 and So B1=B2, B2=C2, B3=D2, etc. Many thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find a Match in Multiple Places & Return Multiple Values | Excel Worksheet Functions | |||
copy once paste multiple places | Excel Discussion (Misc queries) | |||
Data Validation - Multiple Places Changing | Excel Discussion (Misc queries) | |||
Defining a function to use multiple places in code | Excel Programming | |||
=cell("filename") in multiple places | Excel Worksheet Functions |