In case you are using OFFSET, INDIRECT etc. formulae to define ranges, the copy paste might not work.
Paste special values will not work with merged cells. Avoid merged cells as it play havoc with Excel formulae,ranges etc. If you need to merge for cosmetic reasons, format cells as 'Center across selection' alignment!
Uploading a sample will prove insightful
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi thanks for the response.
Here's the sample file. The last 3 sheets (i.e. final executive; final mid_manager; and final regular) is supposedly in a different file that contains the initial reports of the executive; mid_manager and regular. And this initial reports consists of individual time sheet of employees. The reports are multiple and coming from different areas. (sorry but can anyone help me i can't find the attach button??)
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks