Search:

Type: Posts; User: Heera; Keyword(s):

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    229

    Re: Moving data in new excel file

    eam,

    Can anyone help me with the resolution ?
  2. Replies
    3
    Views
    229

    Re: Moving data in new excel file

    Team,

    Can anyone help me with the resolution ?
  3. Replies
    3
    Views
    229

    Re: Moving data in new excel file

    Team,

    Can anyone help me with the resolution ?
  4. Replies
    3
    Views
    229

    Moving data in new excel file

    Hi Team,

    I have a work book with 6-8 tabs which has data. I have 5-6 workbooks like this. Every day i need to copy and move one tab data to new worksheet and name the sheet for further purpose. It...
  5. Re: How to get require worksheet tab data from excel workbook

    Please ignore the above reply, I'm getting it now, thank you so much!
  6. Re: How to get require worksheet tab data from excel workbook

    Thanks for the steps, I'm able Run the code, but there is a compile error occurring when sheet name have special characters like "|".
  7. Re: How to get require worksheet tab data from excel workbook

    Thanks DanteAmor,

    Can you help me step by step on how to add this macro script to my file ?

    Regards,
    Heera
  8. How to get require worksheet tab data from excel workbook

    Hi Team,

    I have data in multiple tabs in one workbook like 40-50 tabs and i need only 8 worksheet tab data which is require for my job and my data is available in different tabs like one lies on...
  9. Thread: Condition format

    by Heera
    Replies
    3
    Views
    179

    Re: Condition format

    Thank you so much. Its really works.

    Regards,
    Heera
  10. Thread: Condition format

    by Heera
    Replies
    3
    Views
    179

    Condition format

    Hello Team,

    I need an up and down arrow sign which should show the result. If it is above that it should give green, if it is below than red. Below is the sample data. Please fill the formulae in...
  11. Replies
    10
    Views
    261

    Re: Total worker duration

    Thank you Dave. After considering both the formulae, i am able to get the required information. Thank you so much for your help.

    Regards,
    Heera
  12. Replies
    10
    Views
    261

    Re: Total worker duration

    Hi Dave,

    Thanks for your reply. How can we fix the below dates? When the date is changing I am getting #### value in the cell after inserting the above formulae.

    ...
  13. Replies
    10
    Views
    261

    Re: Total worker duration

    Hi Dave,

    Here is my date system format :

    Short date: 2/5/2018
    Long date: s Monday, February 05, 2018
    Short time : 9:43 PM

    Time zone : (UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi
  14. Replies
    10
    Views
    261

    Re: Total worker duration

    Hi Dave,

    Thank you for your reply. When I am pasting D2 formulae it is giving me #Value ! error. Can you please help me with the other way?

    Is it possible for me to send the excel file?
    ...
  15. Replies
    10
    Views
    261

    Total worker duration

    Hello Team,

    Can anyone please simplify the below requirement?

    I am looking for a total worker working hours from the time of start of the shift to the end of the shift.

    Please add the...
  16. Thread: Count formulae

    by Heera
    Replies
    1
    Views
    252

    Count formulae

    Hi,

    I have two columns data in which, first column shown which employee is coming in which shift and second column i have data as Yes or No.

    I need to count of Yes in each shift. Below is the...
  17. Replies
    1
    Views
    162

    Category the list of tenure employees

    Hi,

    I have list of employees with their tenuity in number of days in column A and I need in small table that how many employees are in 00-30 days , 31-60 days , 61-90 days and above +91 days....
  18. Replies
    4
    Views
    747

    Re: How to freeze only 4 columns

    Anyone who can help me ?

    Regards,
  19. Replies
    4
    Views
    747

    Re: How to freeze only 4 columns

    HI Krausr : Ur suggestion don't fill my requirement. Please suggest any.

    Hi Gandor : If I do that that I am not able to see first 15 rows. That is why I have mention that I would like to freeze...
  20. Replies
    4
    Views
    747

    How to freeze only 4 columns

    Hi Team,

    I would like to know how to freeze only four column in excel 2013. For example from Column A to Column D. Cell range from A1:D40. And I want to add data from column F from F1 to my...
Results 1 to 20 of 20