Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thread: enhance macro

    by OCM
    Replies
    8
    Views
    143

    Hi Don, Attached is the sample, let me know...

    Hi Don,

    Attached is the sample, let me know if this is what you were looking for.
    I tried your code and got ‘Object required’ error

    TIA,

    Regards
  2. Thread: enhance macro

    by OCM
    Replies
    8
    Views
    143

    Thank you both. Dan, I'll try your code, but to...

    Thank you both.
    Dan, I'll try your code, but to answer your questions,

    1. However, you don't say where you want these subtotals ---> in a separate sheet would be great.
    2. sheet 2 doesn't have...
  3. Thread: enhance macro

    by OCM
    Replies
    8
    Views
    143

    Thanks Zeddy, If you save an excel file as...

    Thanks Zeddy,

    If you save an excel file as ".xlsx", then all vba is 'removed'.
    Can you post your file as a ".xlsm" file, so that the vba is retained?
    --> As per your suggestion I saved the...
  4. Thread: enhance macro

    by OCM
    Replies
    8
    Views
    143

    enhance macro

    Greetings,

    I have the following macro to delete unwanted columns, rename etc. to the attached Excel file:



    Sub Delete_Rename_Columns()
    'Make Sure We Are In The Correct Workbook
    On Error...
  5. 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...
  6. 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...
  7. 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...
  8. Thread: outlook template

    by OCM
    Replies
    0
    Views
    286

    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...
  9. Replies
    2
    Views
    544

    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...
  10. Thread: Duplicate records

    by OCM
    Replies
    3
    Views
    679

    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:
    ...
  11. Thread: auotomat e-mail

    by OCM
    Replies
    0
    Views
    368

    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:
    ...
  12. Replies
    4
    Views
    788

    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, ...
  13. Replies
    4
    Views
    788

    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...
  14. Replies
    4
    Views
    788

    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...
  15. Thread: delete blank rows

    by OCM
    Replies
    1
    Views
    759

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

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

    Thanks Steve for your reply & suggestions....

    OCM
  17. Replies
    2
    Views
    705

    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...
  18. Thread: xml extraction

    by OCM
    Replies
    7
    Views
    791

    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...
  19. Thread: xml extraction

    by OCM
    Replies
    7
    Views
    791

    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...
  20. Thread: xml extraction

    by OCM
    Replies
    7
    Views
    791

    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...
  21. Thread: xml extraction

    by OCM
    Replies
    7
    Views
    791

    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...
  22. Replies
    2
    Views
    330

    filter records (excel 2003)

    Thank you very much Hans, it works beautifuly.

    Regards,
    OCM
  23. Replies
    2
    Views
    330

    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...
  24. Replies
    10
    Views
    2,180

    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
  25. Replies
    10
    Views
    2,180

    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...
Results 1 to 25 of 106
Page 1 of 5 1 2 3 4