Select cell based on value, copy row of select cell and paste into rows in other workbook

Yes, there are more records in Practice PEFF workbook. I might not has been clear in my intent.
- I want to select just a single record from column F with "1".
- The "1" is person that had full attendance for the day, so the data in the rest of the row is the full data for a full day.
- I want to clone that data in that row to each row in the range mentioned in the previous post of EOL 1st Template workbook that has text in it.

Hopefully this time, I wrote it a bit more clear. My apologizes for any misunderstanding. And thank you for your time.

Originally Posted by Ajaxs87

Open 'EOL 1st Template" and paste the copied cells into each row between F17:F40, that has a value in Column B.

Not clear to me.

First 1 appears in F17, so copy H17:I17 & L17:AA17 then paste to
1) Which sheeet?
2) which cell(s) to be pasted?

If you explain the steps when you do it manually, it may help to understand how you want it, or you could upload a workbook before/after sheets in order to make it clearer...

I used the macro reader to kind of walk through what I am looking for. Hopefully this covers what both of you are suggesting I do. Thank you

Code is starting off in Practice PEFF workbook

Please Login or Register  to view this content.

Are you sure about copy/paste, not paste only value?
Used paste value due to breaking borders etc.

Please Login or Register  to view this content.

Jindon
I used the macro reader for reference, but like you said I only wanted the value of the row. It is working very much in the manner I was looking for! I do run into this one error code, but the function still works even with the error code. I attached a screenshot.

I guess it is smoting to do with the macro in "EOL 1st Template.xlsm".

Thank you for your knowledge and help with this setup Jindon!

Ajaxs87,
Try add bold lines

Please Login or Register  to view this content.

Thank you! That fixed that error code I was receiving. I did notice one issue, after it completes, it is writing over the formulas in cells J & K in each row it paste into of the EOL Template workbook.

My apologizes, I am still novice to excel and didn't have the understanding to articulate that concept at the time. Thank you for your help once again.

Hi Jindon,
I want to thank you for your vba setup! I recent tried to alter this to work with a loop setup in a 2nd excel file. I am having trouble trying to figure out how to write the pathways for the files as they are loop created names that vary. The first code is the one I made to create copies from a template based on if a similar file exist.

Please Login or Register  to view this content.

The second code was my failed attempt at altering pathways. I would greatly appreciate any help with wording of the alteration. Thank you

Please Login or Register  to view this content.

I attached my other excel file for reference to cells, but most pathways won't be functional for you.

First of all, it's a very good practice to declare varialbes even you are not sure about the data types.

However, all I can understand is that you are calling PEFFCopy when Col E = No Match.
And your amendment in PEFFCopy doesn't make sense to me.

So you will need to explain how it should "Loop"...

Once again, please excuse my ignorance. I will attempt to improve these shortcomings as I improve my knowledge.

The 1st code works up to calling PEFF Copy

But more or less, what it does is look into two folders to see what documents exist.
- If the date in the file names in each of the two folders' doesn't match, then "No Match" in column 5.
- If "No Match" is present in column 5, it uses PEFF Template and copies the file to a pathway and renames its based on a combination of different columns to generate.
- It loops down the list, if there are several files with "No Match" to make a filecopy.

At this point, I have a file with the correct name in the correct folders. This is where I seeked to use your VBA formula, but as the filenames vary based on the 1st code in my last post. I am not sure how to substitute them into the below you wrote prior.
I bolded some parts in the below code of where I think I am running into a problem.

Please Login or Register  to view this content.

So you need to open/close 2 workbooks each time?

If so, make it simple
Create a Template workbook.
Open \\saims-fs01.sai-llc.local\Dept\2022 PEFF Files\Templates\EOL 1st Template.xlsm
and save as .xltm
so that no need to filecopy in the loop.
When you open .xltm file, it always opens a new copy, so all you need is to save with the full path.

If not, need more details...

Thank you for that advice, I will look into that down the road.

But the file creation side is working in the current state. I am having trouble with the PEFFCopy vba part.
- In your original, you had it use thisworkbook as the source's path to pull information from. In the new one, it using a string of information from cells as the source's path.
-Then later you set = wb thisworkbook.path, and in the new setup, it is once again using a string of information from cells to make the path.

I am having trouble implementing the change from thisworkbook to use these strings of cells instead to find excel files path.

still unsure

Please Login or Register  to view this content.

Thank you for trying, you are very skilled at the program and I appreciate all you have done.