Forum Discussion
Please assist w/ how to copy and paste multiple cells to another workbook
Ok Riny thank you for reaching out to assist me! I trulu appreciate your help!
Ok so Ive copied a tiny portion of the actual document.
Im trying to copy and paste all cells from the PST of 12am-5pm but when I highlight the cells and right click to paste or even cntrl c a pop window appears saying we cant copy multiple cells.
Kittie007 Don't know what you mean by PST. And the data you are trying to copy is in A37:E147. Correct? If not, indicate which cells you select, copy and paste. Can you make a screen shot of the error message and upload it as well?
- Kittie007Dec 07, 2021Copper Contributor
See how it says ""this action wont work on multiple selections or sections""
Out of sheer urgency with tons of work ahead of me I did figure out a remedial way to execute the correct transfer. Just how this info was copied and pasted to EXCEL, I went back to step 1 copied the entire sheet, transferred it into WORD with the correct formatting. I simply selected the time frame from start to stop and pasted it back into EXCEL. Granted this is triple the amount of work for me......but I cant afford to stop lol
Im hopeful you can figure this fundamental out for me Riny! Come on Riny!!
- Riny_van_EekelenDec 07, 2021Platinum Contributor
Kittie007 But you still haven't explained what exactly you are copying and pasting. Going from Excel to Word and back doesn't seem to best way, indeed. And, I would like to see the error message. Not just the text. Can't remember that I have ever seen it.
- Kittie007Dec 07, 2021Copper Contributor
I Using the cntrl and left mouse keys, I hold and drag to copy the entire contents of the sheet. Normally with this function, one is able to copy and paste the selected fields of content, only, this feature doesnt work.
Oh my ok I thought the file uploaded. I will try again.
HERE we go Riny , I had to save the screenshot as an acceptable format
- Kittie007Dec 07, 2021Copper ContributorPacific Standard Time Zone PST and correct. I did this correct yayy!
Ok error code coming next