Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Steve, thanks and I have the needed columns in...

    Steve, thanks and I have the needed columns in both my reports (order and receiving) that are in the same workbook. What would be the best way to load them into one report for reconciliation...
  2. Thanks Steve, It worked nicely for my second...

    Thanks Steve,

    It worked nicely for my second report (Receiving Report): renamed needed columns, and deleted unwanted columns.
    However, I would also like to delete unwanted columns from my first...
  3. Want to rename columns, delete unwanted columns, and reconcile reports

    Greetings,

    Given the attach sample workbook with order and receiving report, I would like to:

    1. Rename column names that are labeled differently in receiving report to match those in order...
  4. Thread: outlook template

    by OCM
    Replies
    0
    Views
    244

    outlook template

    Greetings,

    I created outlook template and given the following, how can I auto update <yesterdayís date>

    Subject: daily report for <current date>

    Body
    The first attachment is for...
  5. Replies
    2
    Views
    425

    Excel to MS Access 2010

    Greetings,

    We use a third party application for data definition purposes.

    In order to export to the third party application:
    1. Itís limited to 10 fields
    2. The file has...
  6. Thread: Duplicate records

    by OCM
    Replies
    3
    Views
    588

    Duplicate records

    Greetings,

    I receive daily student registration reports in Excel 2010 format. Every now and then Iíll notice the same student is entered multiple times because of the following reasons:
    ...
  7. Thread: auotomat e-mail

    by OCM
    Replies
    0
    Views
    344

    auotomat e-mail

    Greetings,

    Using Outlook 2010 I created a template that goes out to certain recipients every day. Iím trying to automate this process (subject line & body) my requirement is as follows:
    ...
  8. Replies
    4
    Views
    741

    Thank you Steve, I found the problem as this...

    Thank you Steve,

    I found the problem as this is related to space in one value & not the other. I used TRIM function in my VLOOKUP to remove the unnecessary spaces and works fine now.

    Regards, ...
  9. Replies
    4
    Views
    741

    Thanks for your reply Steve. Overall, the...

    Thanks for your reply Steve.

    Overall, the Vlookup works fine. However, in my wb1 column D I have a value called ďSTC.TERMĒ & this value is also in wb2 > Column P (my search target). I applied sort...
  10. Replies
    4
    Views
    741

    search & populate a workbook

    Greetings,

    Iím using Excel 2010 and try to create a formula to search for a value from one workbook in another and populate the blank columns.
    In wb1 sheet1 the cell content of column D is...
  11. Thread: delete blank rows

    by OCM
    Replies
    1
    Views
    715

    delete blank rows

    Greetings,

    Iím using Excel 2007 & have a very big excel file that was imported from access database and has a lot of blank rows that I tried to delete.
    I used the following Excel built in...
  12. Replies
    2
    Views
    664

    Thanks Steve for your reply & suggestions.... ...

    Thanks Steve for your reply & suggestions....

    OCM
  13. Replies
    2
    Views
    664

    formatting text field

    Greeting,

    Iím trying to submit a required state report as a text in certain format. I used Unidata to pull the required field as flat file and import the data to Excel 2007 successfully. The file...
  14. Thread: xml extraction

    by OCM
    Replies
    7
    Views
    735

    I've successfully imported the XML data into...

    I've successfully imported the XML data into Excel and Access (please see attached striped version) and start maneuvering around. My next task is the following:

    1) average invoice total amount...
  15. Thread: xml extraction

    by OCM
    Replies
    7
    Views
    735

    Thanks for the reply and the link. I was able to...

    Thanks for the reply and the link. I was able to open the xml document in Excel. The next task is:
    1. analysis; finding average invoice total broken out by division, for the third quarter of this...
  16. Thread: xml extraction

    by OCM
    Replies
    7
    Views
    735

    Thank you for your reply wendellB, Actually,...

    Thank you for your reply wendellB,

    Actually, my SQL Server capability is limited and I do not have access to SQL Server at this moment. Iím using Office 2007, and I am comfortable with Excel and...
  17. Thread: xml extraction

    by OCM
    Replies
    7
    Views
    735

    Greetings, I'm new to this, and wanted to know...

    Greetings,

    I'm new to this, and wanted to know how to go about doing the following tasks:

    I was given a file in XML format and asked to use T-SQL for the XML extraction and analysis. Submit...
  18. Replies
    2
    Views
    303

    filter records (excel 2003)

    Thank you very much Hans, it works beautifuly.

    Regards,
    OCM
  19. Replies
    2
    Views
    303

    filter records (excel 2003)

    Greetings,
    1. In the attached example, how do I filter out the following values along with associated records from GRP_ID column?

    5410
    A0020
    B5214
    A0005
    000362

    I tried the following but...
  20. Replies
    10
    Views
    1,994

    fill in missing data (excel 2003)

    Thank to you and Hans and also for the clarifications. I'll apply your suggestions and post back if i have any question.

    Regards,
    OCM
  21. Replies
    10
    Views
    1,994

    fill in missing data (excel 2003)

    Thanks steve,
    I'll try the code you provided, but in the meantime i was trying your previous method (with array formula) on copies of my project .
    I. when you use adv filter, you can only copy it...
  22. Replies
    10
    Views
    1,994

    fill in missing data (excel 2003)

    Steve,

    Thanks for your reply. I was trying to adopt your example, what are the steps you took to make copies to the copy sheet, copy & paste after you highlight the CSE_ID column and applied...
  23. Replies
    10
    Views
    1,994

    Re: fill in missing data (excel 2003)

    Hans,
    It doesnít really matter what column should be filled in as long as they all look the same for the given CSE_ID in this case (50913).
    In the example attached, 304 should be filled in C6 R2...
  24. Replies
    10
    Views
    1,994

    fill in missing data (excel 2003)

    Greetings,
    In the attached sample all missing data for the given CSE_ID need to be filled first and then I would run the macro to delete the dups. So far, I have manually filled in the missing data...
  25. Replies
    5
    Views
    476

    Re: delete dups (Excel 2003)

    Hans,
    Thanks it works as planned. One question though, in your previous macro line n=Range("Q" & Rows.Count).End(xlUP).Row, I assume "Q" is the colmn where I have COUNTIF formula, correct?
    ...
Results 1 to 25 of 102
Page 1 of 5 1 2 3 4