Dear all,
I need to create time table by checking which professor is free at particular slot and if is he/she is free I need to allocate subject to them. attached is the file for your reference please help. I need to find the time and need to update subject that particular time
thanks &...
Dear all,
I need to create time table by checking which professor is free at particular slot and if is he/she is free I need to allocate subject to them. attached is the file for your reference please help.
Sir
I want to match three three criteria and get count for example
Location Designation October November Decmber
XYZ SM 4500
XYZ SM 2500
XYZ SM
XYZ ASM 1500
XYZ ASM
XYZ...
Sir
Can any one help me with any macro to copy emp nos from emp nos Range F2 to F520 to all the sheets B4 and B24 as per below example
For example
Emp nos
File 1
A
9325
9349
9328
9349
We need to copy to file ROughlayout
Sheet 1 in B4 9325 and B24 9349 and in Sheet 2 in B4 9328 and...
Sir
Can I find a Match (by Unique ID) and get data from different excel files
For ex:
File 1 e:\Vsemp
File 2 e:\Jgemp
Main Data File
Emp No Emp Name
9325
9326
I want to check the Emp No from all the files and IF he is not present in file 1 then go to file 2 and get data
Iam...
sir,
can i stop duplicate printing of worksheet i.e i want only one copy i f anyone want to take duplicate printing it should ask password
thankyou
sriniva
dear sir, I need a formula which im trying but unable to get
i have date c and e cells
i want a formula like this c3-e3
c4-sum(e4:e3)
c5-sum(e5:e3)
c6-sum(e6:e3)
if i just copy or drag to below cells i need this formula but whats happening if i drag or paste its coming like this
c3-e3...
sir
Im working for a store, while stock taking we scan all the barcodes but some times we type barcode manually which is like this
Example A
CELLA CELLB (QTY)
0009pa004735201
0009PA004735201
0009pa004735201
0009pa004735204
Example B
CELL A...