| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy & edit formula
Hi Guys,
I'm battling to get a macro to perform the following: My workbook contains 150 sheets [stock items] on each sheet variuos information appears. I've got a summarysheet witch reflect all information from the sheets. It's much easier to copy the formulas from column A [which contains all 150 shhet names] on the summary sheet to column B. The sheet names remains te same of course, but the cell adress changes. I've tried the macro recorder without sucess. To summirise I would like to copies the formula in column A [Sheet 1 "B2"] to column B [Sheet 1 D2] etc. Any help would be appreciated Thanks -- HJN |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy, edit then paste a macro. | Excel Worksheet Functions | |||
| I just selected Move or Copy from Edit | Excel Discussion (Misc queries) | |||
| Edit/Move or Copy Creating .xls on Tab | Excel Worksheet Functions | |||
| macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
| HOW DO I COPY A CONDITIONAL SUM (sumif) AND EDIT IT? (THE SUM NEV. | Excel Worksheet Functions | |||
Threaded Mode
