Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    99

    Hello, No, if its greater than 100 than...

    Hello,



    No, if its greater than 100 than split it into 100 each. if Col D points are 150 then split 100 & second one 50.


    In the same sheet in descending row order.

    Thanks in advance
  2. Replies
    4
    Views
    99

    Divide into Group

    Hello,

    I have points in Column D wherein if the value is greater than 100 then divide it into group.

    Col A---------- Col B---------- Col C---------- Col D----------Col E---------- Col F...
  3. Replies
    3
    Views
    907

    Hi, Thanks Paul T. Thanks R.G. Thanks a lot.

    Hi,

    Thanks Paul T.
    Thanks R.G. Thanks a lot.
  4. Replies
    3
    Views
    907

    Run script if start time in PowerShell

    Hello,

    I very new to powershell and i need help to achive this.

    At one stage of my poweshell script i want to define that if start time is 11:40 P.M. then hold this running script till 12:01...
  5. Replies
    14
    Views
    1,360

    Hi, Thank you, Paul Edstein for your help.

    Hi,

    Thank you, Paul Edstein for your help.
  6. Replies
    14
    Views
    1,360

    Hello, I have attached the sample file wherein...

    Hello,

    I have attached the sample file wherein i have mentioned the Employeed ID in the very first line,
    Once the letter is printed i will mark Employee ID on very first line.

    Thanks in...
  7. Replies
    14
    Views
    1,360

    Hello, Now onwards the document with a...

    Hello,



    Now onwards the document with a 'Employee Code' on the very first line of the document.
  8. Replies
    14
    Views
    1,360

    Hello Paul, Well, I agree with it and if i...

    Hello Paul,

    Well, I agree with it and if i flag Employee Code or ID on the very first line than that would be more sensible. What's your advise.
  9. Replies
    14
    Views
    1,360

    Hi, I have uploaded the sample file.

    Hi,

    I have uploaded the sample file.
  10. Replies
    14
    Views
    1,360

    Hello, Nicely written codes it works like a...

    Hello,
    Nicely written codes it works like a charm.
    I want to name the splitted pfd files from the word document which is located on the 6th line for the next 8 characters instead of ascending...
  11. Replies
    14
    Views
    1,360

    Save file as PDF files

    Hello,

    The below codes splits the files and creates a word document and its perfectly working to me desire, I want this files to be saved as pdf files instead of .doc file and want to add addin...
  12. Replies
    7
    Views
    461

    Hi Steve, This is making me crazy, at end of...

    Hi Steve,
    This is making me crazy, at end of data rows it appends zero's '0' .Please have look to image uploaded.

    Thanks
  13. Replies
    7
    Views
    461

    Thanks Steve for supporting. Well, it gives...

    Thanks Steve for supporting.

    Well, it gives Run-time error : No cells were found on this .SpecialCells(xlCellTypeConstants, 16).ClearContents.
    On sheet1 2471 rows and on sheet2 2467 rows are...
  14. Replies
    7
    Views
    461

    Thanks kweaver for solution, is it possible to...

    Thanks kweaver for solution, is it possible to automate the process of filling the formula thru macro, why because it will set values instead of formula in the cells and i don't have to drag it to...
  15. Replies
    7
    Views
    461

    Get Values and report blank cells

    Hello,

    On sheet1 i have the complete data and on sheet2 in Column 'C' & 'F' have values in them. I want these two cells conditions to lookup in Sheet1 and get values for Column 'A','B' & 'D','E' ...
  16. Replies
    3
    Views
    474

    Thanks Kweaver for the response, the formula is...

    Thanks Kweaver for the response, the formula is perfect, 1 more request i want to convert the formula to macro which will fill down the column A with ONLY VALUE.
    It means it will not have formula in...
  17. Replies
    3
    Views
    474

    Vlookup & Subsitute to get result

    Hello,
    I am trying to vlookup the value e.g. 005 from a table but the column that i want to vlookup will have the format 800021005.
    There are 9 fields but i want to have only the last 3 fields,...
Results 1 to 17 of 17