Dec 06 2021 03:44 PM
Hello
Im struggling with how to copy and paste a group of multiple cells selected to another workbook.
I would like to select a series of rows with reconciliation data (time date username gross/net data) to another workbook. Ive currently coped a 24 hr series of transactions but now only need from 12am-5pm pst transactions and then from 5pm-11:59pm to a different worksheet.
I select the ctrl tab while using the left click mouse and Im able to copy the group of cells, and I've tried the common functions to move all to no avail!
Would love some input here please! xx
Kittie
Dec 07 2021 02:45 AM
Dec 07 2021 03:05 AM
@Kittie007 What exactly and how are you trying to copy and paste? Can you upload and example file?
Dec 07 2021 03:33 AM - edited Dec 07 2021 08:45 AM
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.
Dec 07 2021 03:47 AM
Dec 07 2021 03:48 AM
@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?
Dec 07 2021 04:26 AM
Dec 07 2021 05:50 AM - edited Dec 07 2021 06:01 AM
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!!
Dec 07 2021 06:53 AM
@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.
Dec 07 2021 07:09 AM - edited Dec 07 2021 08:47 AM
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
Dec 07 2021 09:00 AM
@Kittie007 On a Mac right now, but it's similar on Windows.
This you can select and copy:
This you can't:
Dec 07 2021 01:01 PM