Copy the data using function
Closed
rvm
-
Mar 19, 2012 at 11:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 20, 2012 at 10:58 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 20, 2012 at 10:58 AM
Related:
- When you wrote incorrect functions, what did you learn about spreadsheet data?
- Spreadsheet function - Guide
- Tmobile data check - Guide
- We weren't able to confirm your identity from the video you submitted. you can submit a new video and we'll review it again. learn more. - Instagram Forum
- Google spreadsheet right to left - Guide
- Selfie video verification upload error ✓ - Instagram Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Mar 20, 2012 at 10:58 AM
Mar 20, 2012 at 10:58 AM
Hi rvm,
It basicly depends if you have data in column B. If so, then macro will be better then function.
Let's assume column B is empty.
Formula in B5: =A1
Formula in B15: =A10
Now select B6:B15 and drag it down as far as needed.
Best regards,
Trowa
It basicly depends if you have data in column B. If so, then macro will be better then function.
Let's assume column B is empty.
Formula in B5: =A1
Formula in B15: =A10
Now select B6:B15 and drag it down as far as needed.
Best regards,
Trowa
