Getting Data from another excel file copies the cell format and style
I want to have a separate excel sheet that can get an updated data from another worksheet and also follows the cell format and style.
I can only get an updated data but it won't follow the cell format and style
If I do a copy/paste, I can get the data with the format and style but it won't update any data if there are changes from the other workbook
Stéphane English commented
But the paste button (or, if you prefer keyboard shortcuts, Alt-E,S) includes a dropdown lots of options for pasting format, column width, values only, formats, etc. Therefore I disagree, unless there's a user option to decide on the default option for pasting.
As far as your last sentence is concerned - it sounds like you want to reference data in an external spreadsheet, not copy and paste the content of a cell. If so, then there are tutorials online to show you how to link to external data so that it updates any changed values.
Sounds like a school task to do... :)
Maybe - copy/paste "data with the format and style" AND THEN "get updated data"?
This feature would be very helpful and convenient! Please add this feature.
Yeah! This totally helps a lot on my workload!
This feature would be very helpful and convenient!
Please add this feature!!