Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Auto fill forms from Excel to Excel

(0) ShareShare
ReportReport
Posted on by 2

Hello everyone,

 

I really hope someone can help me. I am trying to achieve some sort of auto fill from a master Excel sheet. Some back ground. We have a master Excel sheet, which is completed every time we receive a new order. From there various departments created different Excel sheets to pull the information through to their respective data bases. Now the issue I have is that I use the information on the sheet to create an Excel History sheet, Checklist and some other forms where we manually capture the same data. These documents are then uploaded to SharePoint and completed live as we move through the various stages of the job. These same forms are populated many times every day. Is there a way to automatically create a new form with certain criteria filled in once the master sheet is updated? We have a field which stipulate what type of job it is and different forms are used depending one the type of job. Any feedback would be greatly appreciated  

  • Katie1234 Profile Picture
    Katie1234 2 on at
    Re: Auto fill forms from Excel to Excel

    Any one?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics