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?
- Functions of spreadsheet - Guide
- Tmobile data check - Guide
- How to be offline in whatsapp when data is on - 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 limit the number of times you can request security codes in a given amount of time. we have this limit to protect your security. for help accessing your account, learn more, or try again later. - Facebook 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