I want to know about vbscript with macros
Closed
san`
-
Jul 21, 2009 at 11:18 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 22, 2009 at 08:59 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jul 22, 2009 at 08:59 PM
Related:
- I want to know about vbscript with macros
- Macros in excel download free - Download - Spreadsheets
- Excel online macros - Guide
- Unlock excel vba and excel macros - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Macro for number to words in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 22, 2009 at 08:59 PM
Jul 22, 2009 at 08:59 PM
why do you want vb scrip
in sheet 2 in any cell type this formula
=IF(OR(Sheet1!B2="a",Sheet1!B2="b"),100,IF(Sheet1!B2="c",400,""))
if necessary copy this formula down
in sheet 2 in any cell type this formula
=IF(OR(Sheet1!B2="a",Sheet1!B2="b"),100,IF(Sheet1!B2="c",400,""))
if necessary copy this formula down