Populate template in new sheet when new row is added on master data sheet

Hi

A bit more sample data would help.
I tweaked your file a bit.

Here's a starting point for you.
see attached file

If this is of any help, please let me know.
If not, let me know anyway.

zeddy

Hello, thank you very much this is a great starting point. It successfully populates data from the first line in the data sheet into the Pressure Test Template. Except when I try to click "Select Folder..." I get an error, "Run-time error '91': Object variable or With block variable not set". Also if I try to click on "Show Form..." it give me the error, "Run-time error '1004': Application-defined or object-defined error". Do you know what I am doing wrong? I am a beginner so the answer may be obvious and I am sorry for that!

I have added 2 rows of data so everyone can see what an example entry would look like on the data sheet. I am very pleased that the data sheet top row populates the template, but how could I have it so every new row will populate the template. For example, if row one is filled out it populates the template and the person can save the pdf. Then they go to the second row and insert data into that row, could that row populate the template after the first one has? This data sheet is meant to be on going and will have many rows of data entered in and I would like each new row to populate the template. I have also added a second (rough) template that I would also need populated. Is it possible for the response in the data sheet column C, "Request Type" to dictate which template the data goes to. If "Pressure Test Only" is written for request type then the "Pressure Test Template" will be populated. If "Final Walk Down Only" is written for request type then "Final Walk Down Template" will be populated. If "Pressure Test & Final Walk Down" is chosen then both will be populated.

Thank you times a million

Hi

Not sure what version of Excel you are using, what operating system you are using (e.g. Windows 10 ??) and where your files are located.
Hopefully it is not a web-based set-up??? Please let us know. It helps.

Save the attached v2a sample file to a folder of your choice for testing (e.g on local C: drive folder???)

Then open that saved file, with macros enabled.

Thanks for the extra sample data. Extra is always good.

There are a few ways we can get the 'last record row' for each corresponding Report type.
As an example, I've added some formulas in columns [AG] and [AG] on [Data Sheet]

This allows us to 'fetch' the record data for the last entry according to Report Type, and place this in the template.

Check the template sheets to see the formulas we can use to fetch the relevant data from the last-corresponding-report-type-data-record-row.

I'va added a couple of tweaks to the Form, to show which Report Template is being used etc etc etc.

Lets see how this works out so far.

Please let us know if you get debug errors.
I have tested this on a local drive and it seems to work ok here.

zeddy

Hi zeddy,

Im using excel version 16.38. It is not a web based set up it is on my desktop. I probably should have mentioned that I am on a Mac, it is all that I have. It is Mac OS Catalina and version 10.15.5. In the code, ".Title = saywhat" gets highlighted when I debug. Do you know why this could be? I hope I am not just SOL because I am on a Mac.

lexi

Hi lexie

You're in the big Apple, big home of Apple users. You are using a Mac.
I should've seen that.

Office 2011 for the Mac is always 32 bit.
Office 2016 for the Mac can be 32 or 64 bit.
If the Mac build is 15.26 or later, then it is 64-bit.

Windows can have 32-bit Excel or 64-bit Excel.

This all makes a big difference when using VBA.

I can easily add code to the workbook to detect whether it's running on a Mac or not, and 32-bit or 64-bit.

Then we would have to deal with the different ways they behave.
Apple uses a significantly different way of dealing with folders.

This is why you were having an issue with my windows-based sample file.

Do you have ANY Users that work with Windows PCs???
Or are they ALL using Macs?? Is there a mix of versions???

Please advise.

I'll have a look at making a v3 sample version to tackle this.
In the meantime, extra info is still always welcome

zeddy

PS Our UK Gov are subsidising meals out next month..
..which makes the UK the CHEAPEST PLACE IN THE WHOLE WORLD FOR A BIG MAC
..just saying

Yes.. the big home of Apple Users. There is a mixture here at my work, some use mac and some use windows. Also they use tablets. I would like it to work on a tablet as well if possible. I am currently updating the template so the cells have changed, it is attached.

And good for you about the big mac! Go UK

Hi lexie

it is attached

is it still on your Mac?

zeddy

Hi, yep it was still on my mac... here u go

Hi lexi

Thanks for that.
- we have a major incident here with phones and broadband out.
Mobile phone's OK
..engineer is visiting

will respond as soon as everything here is fixed

zeddy