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?
- Tmobile data check - Guide
- We limit how often you can post, comment or do other things in a given amount of time in order to help protect the community from spam. you can try again later. learn more ✓ - Facebook Forum
- 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
- Functions of spreadsheet - Guide
- USB:\ is not accessible. Incorrect Function. - Pen Drive, USB & SD Card Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
