Hi Guys,
This is my formula
I have manually typed accross 501-512. I am now looking to drag down the entire 12 cells for about 50 rows and just for the m to change to n, o, p etc. This would save me 600 manual inputs.
Please Login or Register to view this content.
Any ideas please.
Last edited by FDibbins; 07-21-2015 at 01:01 PM.
Remove the $ before the M
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Slightly faster would be to copy that block of cells down the column 4 times, then highlight the cells from Row 13 to row 24 and do CTRL-H (Find & Replace), and:
Find What: $M
Replace With: $N
Click Replace All
Repeat for the next block of 12 cells, but change the $N to $O in the Replace box, and so on.
You might want to change !B to !B$ first if you always want it to bring B21, then B22 etc.
Hope this helps.
Pete
Sorry Pete. Little confused. This is in row 5 from column a-l with the same formula except 501,502 as far as 512 across. I want to highlight the 12 cells row 5 a-l and drag them down 50 rows just changing the m to n o p etc.Originally Posted by Pete_UK
Matt
Dragging a regular formula DOWN will not adjust the column numbers, only the row numbers, no matter how you absolute or notlooking to drag down the entire 12 cells for about 50 rows and just for the m to change to n, o, p
You would need to use something else like OFFSET or INDIRECT
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks all for your replies. Pete yours actually did come in handy for parts of it. Ctrl h really saved me a lot of time. Thanks a mil guys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks