| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Value of Active cell and 25 rows above to a diff worksheet
Hello,
I am hoping someone can assist me. My spreadsheets consists of 70 columns and 2000 rows. If my active cell is bx400, I would like to copy value of bx399 into spreadsheet "X"'s cell a9. Then take the value of bx398 and copy that into spreadsheet "X" 's cell ac11, bx397 would be copied to sheet X cell c19 and so on for the previous 25 rows. (This should only be done when I click on the macro button) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy active worksheet to new workbook | Excel Discussion (Misc queries) | |||
| copy active cell value,find the pasted value in different worksheet | Excel Worksheet Functions | |||
| Using a cell reference to copy rows to a new worksheet | Excel Discussion (Misc queries) | |||
| how do i copy rows to a new worksheet by a cell value | New Users to Excel | |||
| hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
Threaded Mode
