Hello everyone, I have a long Profit and Loss Report by Job from Quickbooks that exports horizontally. Would like to take that exported sheet and do the following: To produce the first P&L it would be A to F + G from row 1 till whichever row F no longer had content in (blank) Those contents need to be saved in their own file as “Profit and Loss by for “&G2 The next P&L would be A to F + H from row 1 till whichever row F no longer had content in (blank) Those contents need to be saved in their own file as “Profit and Loss by for “&H2 The process would need to continue to repeat until the column where row 2 is blank They would save all of these files in one folder. Any help would be greatly appreciated. Right now - i have to export each P&L and export one at a time for over 250 each month.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Copy Consecutive Ranges in an excel sheet and save as individual new files

Thread starter mitzhaki
Start date May 9, 2021

mitzhaki

New Member

May 9, 2021

Hello everyone,

I have a long Profit and Loss Report by Job from Quickbooks that exports horizontally. Would like to take that exported sheet and do the following:

To produce the first P&L it would be A to F + G from row 1 till whichever row F no longer had content in (blank)
Those contents need to be saved in their own file as “Profit and Loss by for “&G2
The next P&L would be A to F + H from row 1 till whichever row F no longer had content in (blank)
Those contents need to be saved in their own file as “Profit and Loss by for “&H2
The process would need to continue to repeat until the column where row 2 is blank
They would save all of these files in one folder.

Any help would be greatly appreciated. Right now - i have to export each P&L and export one at a time for over 250 each month.