store_location_url_data_1.xlsx (313.3 KB)
consider sheet Aberdeen township and barnegat,here If Item Name matches in both the sheets then write its corresponding price in the sheet summary of column Abeerdeen township and vice versa…
Hi @Suthari_RohithReddy ,
We can use append range with data table similar columns
I see file have 3 types:
2 sheet is are 1 type format
and 1 sheet summary we keep it- that’s right?
and from after it to end are 1 type
to merge them - we have 3 sheets,
That’s right?
pls confirm or clear your requirement
regards,
can we connect via meet now ?
I’m in working time
I finish after 3 hours,
we can connect when I finish,
now we can message only,
basically,it’s apart from store_list_1,sheet_1 …we need to work on summary and rest…if item name in summary and rest sheets matches then write its corresponding price value in the summary sheet in its corresponding column name
Hi @Suthari_RohithReddy ,
I just reviewed the summary sheet
It seems that it is a sheet that summarizes the other sheets
we need get from each sheet then fill to summary sheet by key is name
that’s right?
pls confirm it
Thats right… Need to enter the values into it
Ok, I will try it now
I want to ask about “Sheet 1”, “Store_list_1”, “sheet2”
the templete file have them ?
index of them in file is permanent?
can I edit input file dont have them?
or Can I edit input file all of them in top of list sheet or end of list sheet?
this way will help us complete easier,
tell me your comments about my suggest
let it be in any way …but we want the output in said format
OK, i will send xaml to you
share me output excels as well as xaml
my output
store_location_url_data_1.xlsx (380.5 KB)
can we connect now ?
share the xaml as well…lemme look into it
now, In Vietnam is 0:12
we can connect until 7:AM
Main.xaml (17.9 KB)
my .xaml file
is it possible to connect now?
what do you want to ask?
a few minutes, I need to sleep after that
Where are you?
you still there?
I have to go to bed, see you in 7 hours
or Leave a message, I’ll reply when I wake up
Take a nap… Will connect you tomorrow… And thanks a lot for your time
the output is not correct