Viewing the same data on multiple worksheets

[SteveOSteve]

I have two worksheets "Bid" & "Quote". I need the line items in the Bid sheet to be displayed in the Quote sheet. The line items start on A19 and the range is dynamic, since with each bid there will be a different amount of line items. I have tried creating a dynamic Named Range, but when I tried to use it in a formula I get a volatile function error. I have tried using a macro that copies the information on Worksheet_Activate, but his did not solve my issue. SO I need to be pushed in the right direction. How do I duplicate the information across the spreadsheets in a way will the information is always current on the second spreadsheet. This would include if a row was deleted, edit, inserted.

Thanks

 

[NeonRedSharpie]

Is there additional columns on the quote sheet? Example being A:M is populated on Bid but A:Z is populated on Quote? A macro refresh on workbook open would be your best bet, and then you could call it on workbook update but it would get quite slow.

If there is additional information on the quote page, we'd need to figure out a way to temp store that additional information, key it somehow, and then re-append when the workbook refresh is completed.

 

[SteveOSteve]

No the additional information would actually be on the Bid worksheet. So there are seven fields on the Bid, and I need to copy three to Quote. If I used the workbook open option this would only populate the fields when the workbook was open correct? I would need to be able to add a line item and then print the Quote worksheet.

I think I will have to go back to my original thought process which to use the worksheet_activate, and delete and reinsert every time the worksheet tab is clicked on. Seems clunky, but it should work.

I was just hoping there was some way to write a query that would pull the information from a dynamic range on another worksheet, and populate the range in the quote sheet.

 

[NeonRedSharpie]

Is there a reason it needs to be dynamic? Why not just populate "Quote" with =Bid!A1, =Bid!A2, etc etc? Sure, it'll get large...and maybe a little slow...but so be it?

And as for the VBA option, you could bind it to a key combination. For example I have a "mail out" vba assigned to ctrl+m and it just opens an outlook window with the excel attached. You could bind some key to it and you could do it on demand.