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 ?
i want to get data in sheet3 of sheet2
Please modify below coding
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("sheet2")("A1:A25")) Is Nothing Then Exit Sub
Application.EnableEvents = True
If Range("sheet2")("A1") <> "" Then...
Dear all,
I have a date 1-jan-2010
i want to calculate month, day and year till today from above date ,
i want to result in point means 1 and half = 1.6
Dear Sir,
You have given me macro code for data should not delete after entry
I have a data entry form and i want to its details in different 5 sheets
Please find the link i write my question's in this sheet
https://docs.google.com/open?id=0B6VY6rBw3NuBcEhUSWtiS3RJZWc
Dear All,
I have uploaded a file , please find the iom sheet , you will my questions in this sheet
https://rapidshare.com/files/2804026139/Inter_Office_Memo.xlsx
I have save file as macro but error shows
Privacy warning : this document contains macros, Active X controls, xml expansion pack information or web components , These may include personal information that cannot be removed by the document inspector.
Macro VBA code can not work in this file ...
Dear Sir,
I am thank ful to you .
you have given solution is right , but i want to in this report file
i will enter date from___to____ after i want generate report of fund amount of all below sheet ( which is in code ), REPORT GENERATE BY DATE WISE
i only give you example here , is there...