destination formatting

Good Morning, I have a workbook containing 7 sheets (4 of which are 'project list' working sheets, and 1 a summary sheet 'Gantt'). The gantt sheet has 4 contiguous tables with headers and a gantt chart line for each listed project in column D. It's format is not the same as the working sheets...

Hello all, I am using Excel 2010. I am attempting to run a macro as a 'Before Save' event in a workbook named "FirstWorkbook.xlsm." Among other things, the macro opens up a separate workbook ("SecondWorkbook.xlsm"), copies a range of data from the first workbook, pastes the data into the...

Hello Mr Excellers, I have come across a problem linking a cell reference from a 'source' Excel file to another 'destination' Exel file. It only picks up the first 255 characters unless I open up the source file at the same time as when the destination file is open. I have checked if there is a...

Hi all, I am wanting to lock out my spreadsheet so basically if somebody copies and pastes into it, it always defaults the paste option as "Match Destination Formatting" and doesn't screw up the contents of the cell (ie like conditional formatting or style settings of the cell if copied from...