Search:

Type: Posts; User: excel_1317

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. This is now resolved.

    This is now resolved.
  2. Copy/Paste specific data from different pages of same website using VBA code

    Is it possible to develop a code which open each each name from this page- http://www.fitzpatrickcella.com/?p=2541&FirstName=&LastName=&LPA=&I=&L=&Rank=

    AND

    copy details like Attorney Name,...
  3. Replies
    2
    Views
    977

    Thank you Mike..!

    Thank you Mike..!
  4. Replies
    2
    Views
    977

    Month wise calender macro

    I am trying to prepare month wise calender. So my spreadsheet has 12 tabs for each month. On top of each tab i want to place a macro which should hide all active tabs except for the month we want to...
  5. i have read both the threads on cross posting. I...

    i have read both the threads on cross posting. I promise to follow what was mentioned in those threads. The main reason for posting in this forum is we can attach sample data file.
  6. 1240 Above attached is the data dump. I need...

    1240

    Above attached is the data dump. I need to convert it into meaningful database. Please anyone help me.
  7. Find max value and second largest in a row and return column header

    1224I am using below formula to return column header in cell I2 and J2

    =INDEX($A$1:$H$1,MATCH(LARGE($A2:$H2,COLUMNS($I2:I2)),$A2:$H2,0))

    Data is..

    US MX SAM EU AS CN AF Other...
  8. By any means we cant import more than 256...

    By any means we cant import more than 256 columns? i want to make a small database, is it not possible?
  9. i am importing using import feature in MS Access

    i am importing using import feature in MS Access
  10. Unable to import excel file in Access 2007

    I am unable to import my excel file into access that i want to analyze. Access 2007 gives error that input file not found. Access 2010 gives error start position error like this....The field ...
  11. Thank you guys:)

    Thank you guys:)
  12. I had changed the template name, cell E5 and cell...

    I had changed the template name, cell E5 and cell D20..
  13. Please help..

    Please help..
  14. I have created a folder C:\Test and put 2 sample...

    I have created a folder C:\Test and put 2 sample templates. When i run the macro only information from the 1st template is copied twice(in two rows) in result file.

    So information from second...
  15. Great!!!! Its working like charm.

    Great!!!! Its working like charm.
  16. Copy specific data from an excel template and paste in new workbook

    I have around 100 excel templates in a folder from which I need to extract data from specific cells and put in a separate workbook. Is this something that can be done macro. The logic is MACRO open...
  17. Working like a charm...!!! Thanks

    Working like a charm...!!! Thanks
  18. Yes, you are right.... it should be 3

    Yes, you are right.... it should be 3
  19. Please refer to my screenshot in previous post. I...

    Please refer to my screenshot in previous post. I want the macro to function like custom autofilter of excel. So folry+hoag occurs3 times in column A
  20. Somebody, please help me....

    Somebody, please help me....
  21. My mistake, the count should be as.... Foley -...

    My mistake, the count should be as....

    Foley - 3
    CARLSON- 2
    Francis - 2

    The logic is to make the code work like a custom auto filter. For eg. Please have a look at attached screenshot....
  22. Thank you for looking into this. You got it...

    Thank you for looking into this. You got it right...

    Column A has company names and column B has IDs. Column C and Column D contains Lookup Values which i need to lookup in Column B.

    Rick's...
  23. Multiple Column Combination Lookup And Return All Items And Get Count of Items

    907Can anyone help please amend your code to provide results as Column E, F, G and H in the attached file.



    Code:


    Sub ProcessLookUpValues()
    Dim X As Long, Z As Long, Index As Long
    Dim...
  24. Replies
    1
    Views
    1,075

    Help plzz.. ...

    Help plzz..




    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=jTmVtPHtiTg&lc=Ugy_RiNN_kAqUvZ8W994AaABAg
    ...
  25. Replies
    1
    Views
    1,075

    Multiple Value Return Using Lookup

    902Rick, please amend your code to provide results as Column E, F, G and H in the attached file.

    Code:


    Sub ProcessLookUpValues()
    Dim X As Long, Z As Long, Index As Long
    Dim ArrLookUp...
Results 1 to 25 of 26
Page 1 of 2 1 2