Naresh Patel
asked on
Adding Data To Master File From Import Final
I had this question after viewing VBA Help TT V-1.1.
Hi Experts,
need a piece of code which post new data from one sheet to another ..
i have two sheets - Import Final - Master File ....i need to post new data to sheet Master File from sheet Import Final with 2 condition.
1) Post Only Those rows Where column T (Inward Status) =""
2) Post only those entries where Column A (Batch Number) is not found in Master File.
Every entry which posted to Master File - In Column B (WIP Run Date) - Put posted date i.e. today 18 Oct 2016 and new batch number entry posted then mention today's date in column B for every posting.
See Attached
EE-Sample-TT-V-2.0.xlsm
Hi Experts,
need a piece of code which post new data from one sheet to another ..
i have two sheets - Import Final - Master File ....i need to post new data to sheet Master File from sheet Import Final with 2 condition.
1) Post Only Those rows Where column T (Inward Status) =""
2) Post only those entries where Column A (Batch Number) is not found in Master File.
Every entry which posted to Master File - In Column B (WIP Run Date) - Put posted date i.e. today 18 Oct 2016 and new batch number entry posted then mention today's date in column B for every posting.
See Attached
EE-Sample-TT-V-2.0.xlsm
Couple of questions:
1) Almost every row in your example [Master File] sheet has a value of "T" for the "Inward Status" column. Do you want only items with a blank value for "Inward Status" to be moved there?
2) Will the [Master File] sheet headers always match the [Import-Final] headers? (I hope so!)
3) Do you want this new code to be incorporated into the SaveFile() routine so that it immediately moves the selected data to the [Master File] sheet right after the Import? If so, do you still want a single sheet saved externally (to D:\WIP Historicals)?
-Glenn
1) Almost every row in your example [Master File] sheet has a value of "T" for the "Inward Status" column. Do you want only items with a blank value for "Inward Status" to be moved there?
2) Will the [Master File] sheet headers always match the [Import-Final] headers? (I hope so!)
3) Do you want this new code to be incorporated into the SaveFile() routine so that it immediately moves the selected data to the [Master File] sheet right after the Import? If so, do you still want a single sheet saved externally (to D:\WIP Historicals)?
-Glenn
ASKER
1) Almost every row in your example [Master File] sheet has a value of "T" for the "Inward Status" column. Do you want only items with a blank value for "Inward Status" to be moved there?
Yes i want only those entries from sheet Import Final where inward status is blanks
And yes only those to be posted from this blanks where batch number (column A) is not exist in Master File.
2) Will the [Master File] sheet headers always match the [Import-Final] headers? (I hope so!)yes always match
Thanks
ASKER
Mr.Glenn .....
May i Sleep Now? Too Late here
May i Sleep Now? Too Late here
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You Make It Simple By Adding Formula In Column B...Good Catch...Thanks ......May I Ask FollowUp?
Yes, but now I'm heading to bed! I'll check for your followup in the morning.
ASKER
ASKER
Mr.Glenn.
Are Going To Look My FollowUp? Please Look In To That.
Are Going To Look My FollowUp? Please Look In To That.
ASKER