Posts by manzoor

  • Pivot Tables : GROUPS IN WEEK

    HI,


    i have date column in my data from January 1, 2004 to December 31, 2004 and i want to create Group by weeks. Months, Year, Quarter, Days already in the Group Box but Weeks does not show there.


    How i could make groups by week?


    Thanks for your early reply.


    Manzoor

  • DATE CONVERSION FROM TEXT TO DATE

    Hi,


    I have tried =datevalue(A1) formula but there is problem it convert to serial numbers and when i make the format for that column for date it convert all the dates with 2003. The date has also 2004, 2005, 2006 etc. i don't understand why it format the date all for 2003. Thanks


    Manzoor

  • DATE CONVERSION FROM TEXT TO DATE

    Hi,


    I have downloaded data from a system report into excel which has date column like this "Mar-04" but when i take it to Access to add more columns by linking with other data and i change the format in for date column into Date it remove all the dates or put sequential numbers.


    I would appreciate if you please help me in this regard. I want as it is file when i took it to Access. Because after adding fields i export the file back to excel format and i need the same format. But i have seen that date format is changed into text when it goes to Access and also i have seen there is no format in property of date like this "Mar-04" etc.


    Thanks for help.


    Manzoor

  • Formulas: WHICH FORMULA?

    Hi,


    I have one worksheet in which there are two columns. In one column there are blank cells and some cells has numbers which start from 1xxxx, 2xxxx, 3xxxx, 4xxxx, 5xxxx & 6xxxx numbers.


    I want to add beside this column, if it is blank cell then it should be "OH" and if the number in cells start from 1xxxx, then PM01, 2xxxx, = PM02, 3xxxx, = PM03, 4xxxx, = PM04, 5xxxx, = PM05 and 6xxxx, = PM06.


    Appreciate for your help. Thanks


    Manzoor

  • EXCEL ARRAY FORMULAS IN COST REPORT

    Hi,
    I have a summary of monthly cost report which i am attaching herewith. I have also a big database which i download every month. I am using array formula for collection of each month total cost. In the data sheet column J1-J8500 shows category like OH, PM01, PM02 etc, column B1-B8500 Different accounts like 372xxx, M1-M8500 column 1 for January, 2 for February etc. but these are defined in separate column against Date column manually and E1-E8500 the cost in $.
    In the summary sheet there are same codes which defined in data sheet except date. Is it possible that these columns match with datasheet columns and it automatically shows the total cost by using array formula.
    I need your help in this report so that it become for me easy every month. I download my data every month and then work manually to add extra columns for dates, type etc.
    I hope excel guru will help me on this problem.
    Thanks
    Manzoor Khokhar

  • Importing: IMPORT DATA FROM EXCEL

    Hi
    I am facing problem sometime in importing Excel sheet and the error message could not tell why data has not been imported. It only says it cannot import. I would appreciate if you please let me know why in some case sheet not transferred to Access. Thanks


    Manzoor

  • Pivot Tables: DATE GROUP

    Hi,


    I have one data which has date column. when i made pivottable and group for dates, error came. I check the format and it is date format. but the date showing on left side in the cell. anybody knows please help me.


    Another question is that how i create weeks in pivottable group.


    Thanks


    Khokhar

  • APOSTROPHE TEXT STRING

    Hi,


    I have data in one column which has numbers actually but showing text with apostrophe string. I want to convert this as numbers. Appreciate anybody help me.


    Thanks


    Khokhar

  • MERGE TWO EXCEL FILES

    Maqbool,


    Thanks for your effort and response. I was waiting for reply.
    I think i could not explain well. As you know in the sample attached workbook there is one sheet i.e., Meal Data that is combination of all other sheets, you can say that after mereging all the sheets it become master sheet.
    As i have explained that we have each day one work book with all these sheets except Meal Data. At the end of month we want to make one Master Workbook which append each sheet from each workbook and it become one main workbook with one sheet as the fields of columns are same for each sheet.
    After building one workbook then we need to look which employee used each meal twice or more on each day. I hope now it will be clear to you. Thanks for your help.


    Manzoor

  • MERGE TWO EXCEL FILES

    Mac,


    Thanks for follow-up. I have one workbook with 7 sheets (Breakfast, Lunch, Dinner, G2Breakfast, G2Lunch, G2Dinner and Midnight) each day and at the end of month we have to merge all these sheets in one file and we make pivotable and look if any employee used the meal twice or more. The fields of these sheets are same like(Date, Sl#, Badge#, & Meal Type). All the files are in the same folder.


    I would appreciate if you please write vba code for this problem. Thanks for help


    Manzoor

  • MERGE TWO EXCEL FILES

    Mac,


    Yes, you are right. This file is made from different worksheets or workbooks. Manually copied and made a new file. I have 5 or 6 workbooks i.e., Breakfast, Lunch, Dinner etc. and i want to merge them by easy way or thru VBA code. Thanks for help.


    Manzoor

  • MERGE TWO EXCEL FILES

    Mac,


    Yes you are right. This file is combination of other files. But these were copied all other files manually. There are three or four type of files i.e., Breakfast, Lunch, Dinner etc. I need to merge them instead of manually copied and past in main file. or if there is VBA code it will be very easy and save lot of time. Thanks for your help


    Manzoor