Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VB to code sheet formulas
Hi,
I have 3 sheets in a workbook. 1. Bank 2. MIS 3. Temp Bank sheet: Formula columnB from B13 to end of column depending on ID in corresponding column D =IF($D13="","",IF(COUNTIF(List,$D13),VLOOKUP($D13, List, 3,FALSE),"Incorrect or New ERP ID ")) Formula columnC from C13 to end of column depending on ID in corrsponding column D =IF($D13="","",IF(COUNTIF(List,$D13),VLOOKUP($D13, List, 2,FALSE),"Update List")) Formula in columnM from M13 =IF(COUNTIF(MIS!$A:$A,S13),VLOOKUP(S13,MIS!$A:$Q,8 ,FALSE),"") Formula in columnN from N13 =IF(COUNTIF(MIS!$A:$A,S13),VLOOKUP(S13,MIS!$A:$Q,1 1,FALSE),ABS(0)) Formula in columnS from S13 =F13&J13 ------------------------------------------ MIS Sheet: Formula in columnA from A2 =K2&G2 Formula in columnR from R2 {=INDEX(Bank!B:B,MATCH(A2,Bank!S:S,0))} ------------------------------------------ Temp Sheet: I have a named range 'List' from this sheet which is being used in bank sheet to vlookup. Required: I would like all the formula calculations in VB for both Bank & MIS sheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copied formulas refer to destination sheet not source sheet | Excel Worksheet Functions | |||
How to copy formulas sheet to sheet in excell | Excel Worksheet Functions | |||
Code to change code in a sheet and workbook module | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
See code enclosed - Convert to formulas with absolute reference inculding the sheet references! | Excel Programming |