Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
tksnota
Post Patron
Post Patron

Excel Problem...Open to Other Options

 

Note: Source Sheet is the bottom and Target one is the top

 

Problem1. Red arrow the same with the stock code but when I replaced each item it will delete the formula encircled in amber circle thereby not generating the stock code number and Stock Item. It also needs to add rows automatically while  source sheet is being updated. Need some suggestion

 

Problem2. Auto-populate the target sheet while the source sheet is being but the catch is the days and day rate of several rows interchange.   It also needs to add rows automatically while  source sheet is being updated. Need some suggestion

 

Problem 3. Can the automation be done via excel especially if the rows involved hundred of thousands? Will new commands need to be written everytime an automation will be needed? 

 

Looking forward to hear from the community..

tksnota_0-1721224553788.png

 

2 REPLIES 2
dufoq3
Super User
Super User

Hi @tksnota, provide sample data in usable format (read note below) and expected resuld based on sample data please.


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Hi


there are several problems in this post so I need to address the priority one. 

If a text has been introduced in the target sheet taken from the source sheet that match the stock code then it will trigger the appropriate stock item. stock items are stored on another excel sheet and only linked to the target sheet.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.