I have a big Master copy in Excel 2007 with about 800 rows and 20 columns.
Issue 1: When ever I need to copy and paste some of the data into another excel workbook, all I get is BLANK cells.
I seem to highlight the amount of cells I copied but the data is blank when I paste. - No error message on this one and the only way I can get around it is by using paste special and text only. But I just want to be able to copy and paste the data in one go.
Issue 2: Also, I ensured that the whole master copy is formatted the same...same font, and formatting for dates or currencies is done by entire column and sometimes, I get the error message: "too many different format" even i I try to only paste 5 cells into another workbook.
Can anyone help? I can deal with it but my colleague are driving me crazy!!!!
Thank you kindly