If a1= active, copy a2-a6 to a1-a5 on sheet2
Closed
batman28x
-
Nov 8, 2009 at 03:47 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 8, 2009 at 09:21 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 8, 2009 at 09:21 PM
Related:
- If a1= active, copy a2-a6 to a1-a5 on sheet2
- A5 size in word - Guide
- How to print a5 on a4 - Guide
- How to activate nearby friends on facebook - Guide
- Qbittorrent maximum active downloads - Guide
- Which formula am i going to use if i want to know if the text "bacon" appears in the content of cell a1 ? ✓ - Word Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 8, 2009 at 09:21 PM
Nov 8, 2009 at 09:21 PM
can be done but some clarification is required
suppose A1 has column heading "job activity"
A2 down have entries"active" or "non active".
suppose A2 has entry "active" what are entries in A3,A4,A5,A6,A7. do you want A2:A6 to be copied or A3 to A7.
can you post the first 10 entries of column A and say exactly what you want
suppose A1 has column heading "job activity"
A2 down have entries"active" or "non active".
suppose A2 has entry "active" what are entries in A3,A4,A5,A6,A7. do you want A2:A6 to be copied or A3 to A7.
can you post the first 10 entries of column A and say exactly what you want