| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a formula within a row from a column on another worksheet
I am attempting to copy text from a column to a row in another worksheet via
a formula. For example A1, A2, A3, A4...from worksheet 1 will be copied to B2, C2, D2, E2...on worksheet 2. I can simply do this with cut and paste special using the transpose function but I want to pull changes from worksheet 1 into worksheet 2 automatically using a formula. I used =T('Worksheet1'!A1) but cannot copy across the row. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF in between rows | Excel Worksheet Functions | |||
| Index and Match Formula | Excel Worksheet Functions | |||
| Lookup function/sum function | Excel Discussion (Misc queries) | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Threaded Mode
