Hi Frds
I wanna create a separate excel books based on status of the column F(Status). If contains pending completion, then the respective rows needs to be copied to new excel workbook along with the existing headers. and these excel file needs to be saved in folder and folder and excel work...
Hi frds,
I have a doubt and can anyone clarify it.
Based on the template, i want to create separate sheets for every mon to fri (not for weekends)present in the respective month
Example:for december month.
If i press over a button which is the tempplate sheet, i should get
1st sheet name as...
hi frds,
below is my query,
I have set of 16 digits numbers in a column. there is a another column based on this column. Let the columns be C & D. Baed on the last 2 digits of the column c , column D value should get changed.
I have following conditions.
if the no ends with
22 ---- AAAA...
I have written a subroutine procedure.
would like to assign shortcut key
i used the following sentence
(Application.MacroOptions Macro:="g", HasShortcutKey:=True, ShortcutKey:="^Q")
but it is not working when i press ctrl+Q
hi,
I tried to copy the values from different sheets and paste it and added the values in a separate protected sheet of the same workbook.
macro is working well if the workbook is unshared. if i shared the workbook, it is not working.
can you help me, pls?