RPA.xlsx (15.3 KB)
FROM SHEET 1 TO FINAL SHEET HOW TO START IN VBA PLEASE SHARE SOME INFO
Hey
can you explain a bit more about your requirement?
AS YOU CAN SEE IN THE FIRST SHEET AND 2 AND 3 EXCEL SHEET I HAVE FILTERED THE DATA FINAL DATA IS IN 3 SHEET
THAN WE HAVE TO CHANGE THE SIGN OF AMOUNT COLUMN, PERCENT=MULTIPLE BY 10 & TOTAL = PERCENT - SIGN
NUMBER OF DAYS COLUMN IS TODAYS DATE - GIVEN DATE
DUE DATE IS IF THE NUMBER IS BELOW OR EQUAL TOO 21 THAN DUE
OTHERWISE NO DUE
BUT THIS HAS TO BE DONE THROUGH INVOKE VBA UiPath
Let me summarise your requirement
We have to deal with Initial sheet which has 4 columns Reference, Date, Description, and Amount.
then
You want to
- Change the sign of amount column in Final sheet
- Add column number of days and you have to calculate the No.of days i.e. todays date - given date
- Add due date column and maintain due date flag where it should be marked to due if the due date is below or equal to 21 otherwise no due will be marked
Am I correct.
Regards,
Firoz
AS YOU CAN SEE 2 SHEET AND 3 SHEET THE DATA IS EXTRACTED FROM SHEET 1
TVS AND BLANK ROW IN DESCRIPTION ARE IN 3 SHEET
THEN WE HAVE TO DO THIS CHANGES “SIGN, PERCENT, TOTAL, NUMBER OF DAYS, DUE DATE”
Hi @Krishan_Rapswal,
You are actually telling the whole requirement in forum
Forum is just to ask question when u are facing some challenges then community will guide you.
Try to do it on your own, There are many VBA tutorials for how to copy sheets, how to add sign and how to do data manipulation etc on internet.
After trying if you face any challenge then you can connect with me I will be happy to help.
Regards,
Firoz.
Hello @Krishan_Rapswal
You can achieve this by simple Excel formula.
You can use the Autofill range activity to fill the formula in it
Refer to the Final Sheet.
RPA.xlsx (17.8 KB)
in Starting what i said i need a head start that’s it i don’t know from where to start in vba code
you asked me what has to be done so i told you just check my first message
checked this one also
ok
Try to first read the data from sheet 1
it is having whole data right
then filter that with description or any other column which you want and paste it in new sheet
use below link to do that
also here you have to modify according to your use case.
from here you can start.
Regards,
Firoz
ok i will look into this if i need some help than i will ask. Thank you
i want to ask you something whatever i used in linq (Assign)
the same thing goes for invoke vb code ?
Hi @Krishan_Rapswal,
In linq we basically iterate through the data with certain logic.
VBA code is programming for Excel.
What do you need to know exactly?
Regards,
Firoz
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.