Dear all,
I have a sheet that comes output from a software, which I have placed in the main data sheet. It has to be converted to step by step which I have shown in sheets.
Step 4 is my last sheet i need FROM VBA CODE.
also enclosed herewith pics & sheet attached.
Thank u in Advanced..
STEP-1-001.png
STEP-2-001.png
STEP-3-001.png
STEP-4-FINAL.png
Check my suggestion.
You have to change the names because they are different, e.g. the 'MAIN DATA' sheet is "LIBERTY WINES, SOLAPUR (Pro", and in the 'CUSTOMER DATA' sheet is "LIBERTY WINES, SOLAPUR (Prop.Sandeep Talreja)".
The results are in sheet 'DATA CONVERT STEP-4- & FINAL' from cell J4.
HTML Code:
Best Regards,
Maras.
Sir, Thanks for the reply,
when i run this code , Showing Display error , ( expected array )
pls check..
Sir, Actually
LIBERTY WINES, SOLAPUR (Pro is the name of this customer group, their under their name is LOTUS WINES**, LIBERTY WINES***, LUCKY WINES**
Try
Please Login or Register to view this content.
Last edited by jindon; 10-07-2019 at 08:03 AM. Reason: fixed a typo
sbvaram, you were right. There was a problem with the tables declaration.
The corrected code below.HTML Code:
Yess... Correct , 100% perfect...
Thank u Very Much sir,
Sorry, I did not reply to you yesterday, yesterday was the office holiday.
Thank u once again!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks