Posts by hajoshi21

    Hi Everyone,

    I need somehelp with this problem! I tried everthing that I knew but I wasn't able to get the result I wanted.

    Okay, Here is what I need.

    I have a excel file with 10 different work sheets.

    WsheetA, WsheetB, WsheetC... thru WsheetJ This is a master file so, I can not change or do anything with this file! So, other option I have is to copy the data and paste it in to the other file. I have been doing this for long time and I have created some Pvtable that is based on this data.

    I created a macro to copy and paste data but some time my macro does not work the reason being that some time in master file there is only 8 worksheets

    WsheetA, WsheetB, WsheetC... thru WsheetH In this situation my macro wouldn't work becasue it is created for 10 Wsheets and if there is lessthen 10 Wsheets it won't work.

    One more thing I want to make it clear is that there are other Work sheets in master file but I only wants to copy those Work Sheets which starts with Wsheets.

    Please tell me what do I need to do to get correct result.

    Thanks for your help!


    I need your help with excel file.

    I have two file

    1. Master file ( This file has been updating by several people. This file is been save as current day for example. 08.07.04 tomorrow the master file will be save as be 08.08.04. )

    2. Personal file ( This file I am coping data from above file and I have some formula in it)

    Now, I have to keep the master file in same formate it means I can not change anything it that file so, 2nd option I have to copy data from that file and paste in my personal file.

    Everyday I am coping 1 thru 7 worksheet from Master file to Personal file.

    Is there a way or VBA programme that would let me select the master file from my personal file and insert the first 7 worksheet from master file to personal file? I would like to keep the same worksheet name in my personal file.

    Or is it possible that my personal file prompt me to enter a file name and as soon as I do that it grab the first 7 worksheet from that file and insert it to my file?

    Thanks for your help!

    I have A long excel file that looks like this (Please see below)

    A B C D E
    1 ITEM 11141 11219 44312 12100
    2 TAG 5555 1111 8888 6666
    3 QTY 200 200 200 200
    4 TAG 4444 3333 9999 6666
    5 QTY 100 100 100 100
    6 TAG 5555 1111 9999 7777
    7 QTY 100 100 100 100
    8 TAG 4444 3333 8888 6666
    9 QTY 100 100 100 100
    10 TAG 4444 1111 8888 7777
    11 QTY 200 200 200 200

    Now, My question is that I want a total qty for each unique tag number for that Item.

    for example1. Item : 11141(B1) Tag # 5555 Total Qty : 300 ( B3 + B7), Item # 11141B1) Tag # 4444 Total Qty : 400 (B5+B9+B11)
    for example2. Item : 11219(C1) Tag # 1111 Total Qty : 500 ( C3 + C7 + C11)

    I am not sure If it is doable or not.

    Thanks for your help