Thank you Narayank for the reply. I would require all data from Booking to be viewed / updated in print sheet. Especially when i do filter condition at same time this should get updated in print sheet also.
cell reference shall work for numbers & characters. But for Filter condition & chart i'm...
Hi i have attached a sheet. Where whenever i update in booking sheet this should reflect in print sheet. Especially the filter condition & chart from source sheet to target sheet. Target sheet shall be formatted desperately for user to take print out.
I received a VB from another web as below. Problem here is each time when i run it creates new excel workbook instead of updating in existing workbook in different/specified sheet.
Sub CopySheetToNewAndFormat()
'copy sheet 1
ThisWorkbook.Sheets("Sheet1").Copy
'set new workbookSet NewWorkbook =...
Formula reference shall not work in case of charts. There can be many changes that can happen over the period. Any option to automatically get the new sheet get updated.
Hello,
I have been looking for an solution for below:
When i update sheet1(source in this case) everything should get reflected in sheet4(target) of same workbook simultaneously. Sheet 4 is mainly used for printing purpose which shall be formatted as per user requirement.
The source sheet...
Dear Team,
I'm new here
I have attached a screen shot of an excel. where column table i need to bring it below the chart. The table contains character therefore chart by default option shall not work.
I transposed the the table below the chart. But issue is row filter does not reflect in...