Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    173

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

    Hello,

    I have attached the sample text file and excel workbook.

    I will import single text file and Column B will be the name of sheet. The data to be sorted on column B and then transferred to...
  2. Replies
    3
    Views
    173

    Import 4 Text files to different sheet

    Hello,

    I have 4 text files in a folder & format, structure of files are same.
    I want to import all 4 files simultaneously to a workbook with each text file having their own sheets.
    Any one, a...
  3. Replies
    9
    Views
    367

    Hi, AWESOME kweaver & Maud. Thanks

    Hi,

    AWESOME kweaver & Maud.

    Thanks
  4. Replies
    9
    Views
    367

    Thanks kweaver. Exactly thats what i was...

    Thanks kweaver.

    Exactly thats what i was looking for.

    One thing if the number is increased in thousand than it does not give the output.
    Like starting 17500 Points 2000 How to do that.
    Can...
  5. Replies
    9
    Views
    367

    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
  6. Replies
    9
    Views
    367

    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...
  7. Replies
    3
    Views
    974

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

    Hi,

    Thanks Paul T.
    Thanks R.G. Thanks a lot.
  8. Replies
    3
    Views
    974

    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...
  9. Replies
    14
    Views
    1,405

    Hi, Thank you, Paul Edstein for your help.

    Hi,

    Thank you, Paul Edstein for your help.
  10. Replies
    14
    Views
    1,405

    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...
  11. Replies
    14
    Views
    1,405

    Hello, Now onwards the document with a...

    Hello,



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

    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.
  13. Replies
    14
    Views
    1,405

    Hi, I have uploaded the sample file.

    Hi,

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

    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...
  15. Replies
    14
    Views
    1,405

    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...
  16. Replies
    7
    Views
    473

    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
  17. Replies
    7
    Views
    473

    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...
  18. Replies
    7
    Views
    473

    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...
  19. Replies
    7
    Views
    473

    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' ...
  20. Replies
    3
    Views
    487

    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...
  21. Replies
    3
    Views
    487

    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 21 of 21