Dear All
I have work sheet name Returns if I type today something in A1 I need todays date in B1 and it should freeze and if type something in A2 or any other cell in A:A I need that particular date in B column and should freeze as given below
A B
apple 20/5/2024 (Date...
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...
Thanks a ton sir its working can you tell me this part "")),"")
and if I want to get data from 6 files means how to end the formula "")),"")
Regards
srinivas
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...
thank you sir, its working
sir we do have an software called Oriel Retail Software, I have taken data from that and keeping as recent time s we are regularly having problem with our server. This excel sheet may helpful instead of writing manual bills.
Once again thanks so much
regards...