automatically retrieving data from share drive, generate new tab and format with msg box

[turbo600hp]

Dear all,

Please see attached file.

The Report is named by Month and added to the folder. Ex. March AR. Report has many clients, i put example on the original data tab with only few clients due to the size. File path is C:\users\fab\documents\vb.

On the Control tab, my goal is to click on the button, msg box pop up to ask for Client name and Month. By doing that, macro will go to that path and folder, first to identify the month. If user enters March, then pull March AR file. then by identifying the cient name which on Col H as Customer Description to pull information only related to this client and generate tab name as AR Report. Once the new tab generated, i like to format the data like what is on By Client tab.

1. Delete row 1-5
2.Bold headers
3.freeze panel by col J2
4. add total at bottom with borders, bold and yellow fill.

So basically there are only two tabs at end, control and new AR Report tab.

I have also added another tab called TB, that will be another file saved in the March folder along with March AR. on the 2nd thought, instead of clicking on each button at control tab, i am thinking that is there a way put general information (see control tab). enter Client Name and Month. Then when i click AR button, it will go to proper folder, pulling THE MONTH looking for and file like March AR, then pulling by Client Name entered from the file, generate tab on this template.

same applied to tb file.



And also by clicking on the reset workbook button to delete new AR Report tab.



Please help and thank you so much

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.