HOW TO DO THE DIVISION OF 2 SHEET VALUES INTO ANOTHER SHEET

Help Automation Ops
,
1

there are 2 sheets like amount and quantity
the amount/quantity should be done and reflected in next sheet
how to do that

2

Hi @anjani_priya

Could you share the input file and also do you need to write the entire data along with the new column in a new sheet?

Regards

3

Book1.xlsx (304.8 KB)
sheet2/sheet1=sheet3
sheet5/sheet4=sheet6

4

Hi @anjani_priya

Chack out the below zip file.

BlankProcess22.zip (322.4 KB)

Hope it helps!!
Regards

5

Is there any alternate code without vba

6

@anjani_priya

VBA code will take less time to excecute rather than other codes. This will be easy to understand also.

Regards

7

can I change the names of the sheets in vba code

8

@anjani_priya

According to your sheet names you can change in the text file of VBA code.

DivideAndCopyToThirdSheet.txt is to write values to Sheet3
DivideAndCopyToSixthSheet.txt is to write the values to Sheet6

Regards

9

can you send me the logic without vba also

10

@anjani_priya

I will check out with that too.

Happy Automation
Regards

11

Hi @anjani_priya

Here is the code without invoke vba
Forum.zip (458.5 KB)

12

resultant sheet values are not changing into number format

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.