Sheet 1 contains grids with thick border lines & comments etc. But I can't able to import this data to second sheet.
Please help me.
Sheet 1 contains grids with thick border lines & comments etc. But I can't able to import this data to second sheet.
Please help me.
You should know by now ...
There are instructions at the top of the page explaining how to attach your sample workbook.
Comments and formatting cannot be copied via formulae.
Copy and paste will retain both.
Last edited by AliGW; 07-05-2020 at 03:57 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
So I need to type all the matter in sheet 1 to sheet 2 manually?
No, just copy and paste.
What is the reason for the data duplication?
Or copy the whole sheet on the tabs at the bottom, if creating a new sheet is an option
It is unclear if you wish to retain any underlying formulas (if they are there) as you haven't told us and haven't as Ali says provided a sample with your desired outcome
Thank you Madam, you just saved me lot of time.
Last edited by kingston_123; 07-09-2020 at 04:05 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks