Copy the data using function
Closed
rvm
-
19 Mar 2012 à 11:05
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 20 Mar 2012 à 10:58
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 20 Mar 2012 à 10:58
Related:
- When you wrote incorrect functions, what did you learn about spreadsheet data?
- Spreadsheet functions - Guide
- Tmobile data check - Guide
- Google spreadsheet download - Download - Spreadsheets
- 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
- How to copy data from one excel sheet to another - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
20 Mar 2012 à 10:58
20 Mar 2012 à 10:58
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
