I have uploaded a spreadsheet with three worksheets.
You are asked to write a Macro to create a few text strings as shown in Column A os Sheet2 and 3. You will need to check the formulas in Sheet2 and 3. so that you can understand what it is required.
Text String example from Sheet 2 :
P0=IIF(n=="A",50,IIF(n=="AA",0,IIF(n=="AAN",50,0)));
the number of strings depends on the number of rows in Sheet1.
Text String example from Sheet 3 :
PositionSize= -
IIF(B==0, P0,
IIF(B==, P,0))))))))));
the number of strings depends on the number of rows in Sheet1.
You can produce the required codes directly in Sheet1 if it is better for you.
We may need to discuss this further once you make your offer.
Hello Sir
Im excel VBA macro and formula Expert :)
i can do anything in excel :)
please give me a chance for doing your job and im able to start doing your job right now :)
Thank You
Sincerely
Prameswara :)