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 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 )...
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
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 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,
Please find the link , i need formula help
https://rapidshare.com/files/2571544105/ACCOUNT_DATA.xlsm
Please open the file and find question in report file sheet
Dear Sir,
if i entry in cell A1 , =(100+200+300+400+500) then answer will shows 15,000 in same cell.
my question is that , when i entry in cell A1 same like =(100+200+300+400+500) and i want in sheet 2 same this entry as
A1 IN 100
A2 IN 200
A3 IN 300
A4 IN 400
A5 IN 500
is this...
Dear Sir ,
Good morning to you all,
when we add in sheet insert menu - smart art - any image or shape
CAN WE LOCK SMART ART ? BECAUSE NO BODY CAN CHANGE IT
Dear All,
In A1 is 8:30 AM
then B1 is 01:00 AM
after D1 answer is 7:30 hours, this is wrong so please help me
how can i calculate of total hour worked ?