Dear All,
Hope you all are well!!
Subject: I am getting an error to importing images (An error occurred while importing this file. D:\A Suresh 2022 New Data\2022 New Data_Ariane_Suresh\Low_Resoution_Images/AMKARN0000.png)
Below is the code which i am Using.
>>> use code - tags <<<
Private...
Dear Sir,
Please find attached sheet.
Query : I want to put formula in E column.
Date Credit Withdrawal Remain. Balance
21/01/18 100 0
22/01/18 200 300 300
IF I WITHDRAWAL ON 22-01-2018 THEN ABOVE BALANCE WILL ZERO in remain. Balance column.
Dear Sir,
Please find the attached file of data entry userform.
https://docs.google.com/open?id=0B6VY6rBw3NuBRF92Qmt6MlpaQlU
you will find in sheet two buttons 1. Add data and 2 . Edit / Update data
My question is that ...
In edit/update data userform, when i click button update record...
Dear Sir
Thank u so much, but here a problem that ...
when i enter second entry by same id ( for example id no : 1) in data entry sheet then sheetname 1's entry increasing , it should not to be .
Dear All,
I have created a column as id number, Sheetname "Dataentry"'s rows data will transfer in same id number's sheets ( other sheets name i given as ID )
Cell A1 = 1 ( 1 is id number )
Cell A2 = 2 ( 2 is id number )
Cell A3 = 3 ( 3 is id number )
Cell A4 = 1 ( Repeated id number )...
Dear Chandoo !
Please find the link . need vba help please
your concept will clear after see file .
I want to here for modify above coding
if I enter id no 1 in this data entry sheet then its data (a2:f4) comes in sheet name 1
if i enter id no 2 in this data entry sheet then its data...
A B C D
A1 1 10 1 =answer here
A2 1 20
A3 2 5
A4 2 6
As per above data we required result in D1 Cell.
Maximum value according to C1 cell from B column ,
in sort . C1 = A1 then answer B2 (20) means maximum value
Thanks SirJB7...........
I assume that ........
first condition : sheet2's cell B1 is "1" then sheet2's A1 cell's data transfer in sheet 3 in A1,
same condition is here
second condition : sheet2's cell C1 is "2" then Sheet2's A2 cell's data transfer in sheet 4 in cell A2
is this possible ?