Hi Everyone,
I need a help with one thing,
I have a sheet with some tabs, one of them is the main Tab (called Main Tab)
another tabs have the name of my stores, each tab is for a different store,
I want that each store fill their own tab with the informations, and infos appears on Main Tab automatically , and including on A column the Shipping store, that is the name on the Tab.
Is possible?
Last edited by leleco; 12-11-2024 at 02:05 PM. Reason: Bad explanation
Do you still run Excel 2010? If not, please update your profile first.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
HI, thanks for advise, change is done
Please add some sample data to your posted file.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
@leleco: I would suggest you put some data into your database and manually complete at least one of the output tabs.
If you have Excel 2021, 2024 or 365, you can use FILTER. If not, it's still doable but more complicated.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Convert everything to tables
And then you can use the vstack formula
I only changed 2 tabs
=VSTACK(UBX!A2:F3;UCK!A2:F3)
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
You don't need to convert to tables.
Formula:
=FILTER(VSTACK(UBX:UIP!A2:E10),VSTACK(UBX:UIP!A2:A10)<>"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks