Stop insert of a row and filter in ASSET CALC

[jericho14444]

Hi everyone,
I have a vba code in ASSETS CALC workbook for selecting another workbook (ASSETS) through a user form. The code inserts a specific row in ASSETS, filters data, adds it together, and then copies the final number over to ASSETS CALC. Unfortunately, for some reason, the row that is inserted into the ASSETS workbook is also insterted into the ASSETS CALC workbook and filters are added. Does anyone know how to stop this? I just want the final number to be copied over to ASSET CALC.

Also,
Can this line of code be changed so it selects sheet1 in whatever workbook is selected in Listbox1?
ActiveCell.FormulaR1C1 = "=[assets.xlsx]Sheet1!R28C3"
Thank you.

[jericho14444]

Can someone please help? Thank you.

[jaslake]

Hi jericho14444

Try this Code for your Private Sub CommandButton2_Click()

Please Login or Register  to view this content.