Related:
- Macros in Excel so it copies onto next row
- Download macros for excel - Download
- Excel formula for copying data from another sheet - Guide
- Automatically run macro in excel when cell changes - Guide
- How to write a macro in excel to extract data - Forum - Excel
- Run Macros in Excel: online, shortcuts, VBA - Guide
4 replies
Range("A1").Select
Selection.End(xlDown).Select
i think i might be trying to do a similar task. this is what i tried, if it doesnt help, please disregard as i too am new to vb.
Selection.End(xlDown).Select
i think i might be trying to do a similar task. this is what i tried, if it doesnt help, please disregard as i too am new to vb.
nazish
Nov 4, 2009 at 01:47 AM
- Posts
- 1
- Registration date
- Wednesday October 28, 2009
- Status
- Member
- Last seen
- November 4, 2009
Nov 4, 2009 at 01:47 AM
i want that when i copy the specified rows it paste in colums but after specified colum it paste to next row till spcified colum and so on.
1. Copy the cells from sheet 1.
2. Select the top cell of the first column in sheet 2
3. Open Find & Replace (Ctrl + F)
4. Open the options in Find & Replace and change "search by rows" to "search by columns"
5. Leave the value you're searching for blank.
6. Click "Find Next"
7. Paste special (values only)
Only works if you have no other blank cells above the cell you want to paste into.
2. Select the top cell of the first column in sheet 2
3. Open Find & Replace (Ctrl + F)
4. Open the options in Find & Replace and change "search by rows" to "search by columns"
5. Leave the value you're searching for blank.
6. Click "Find Next"
7. Paste special (values only)
Only works if you have no other blank cells above the cell you want to paste into.