Remove weekly barrier

nachobear

New Member
Joined
Feb 1, 2024
Messages
25
Office Version
  1. 365
Platform
  1. Windows

is there a way to remove the weekly barrier cause I want to PASTE something thats a months worth but i can only paste 5 days of data at a time
a2fb01c0-bf42-483f-99c3-a65076494fc6.png



I posted this on another forum and no help
In the other thread I did a typo saying I want to COPY something that's a months worth

Thank you
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Do you have hidden columns? What data do you want to paste?

Mr. Excel has a tool, xl2bb add in, link below that allows you to post mini worksheets of your workbooks.
I think it would be very helpful if you could do that.

If you cannot do that, then please post your data in a table
BEFORE (the paste),

What you want Pasted.

AFTER (what it should look like)

Thanks in advance.
 
Upvote 0
Do you have hidden columns? What data do you want to paste?

Mr. Excel has a tool, xl2bb add in, link below that allows you to post mini worksheets of your workbooks.
I think it would be very helpful if you could do that.

If you cannot do that, then please post your data in a table
BEFORE (the paste),

What you want Pasted.

AFTER (what it should look like)

Thanks in advance.
I don't see the link

I did hide the weekends which I just compacted them by clicking and dragging them to hide them

I'm just copying and pasting regular numbers from an online excel to the downloaded excel file
 
Upvote 0
Follow the arrow in the image to the link:

What does the data in the web look like when you copy it? Have you tried posting in a brand new worksheet with no hidden columns?
And please do as we ask, just don't say what you have done. The forum cannot replicate "what you see"? That is why I asked for the xl2bb mini worksheet or a table of everything.
Before
what you're pasting
what you expect it to look like.

Help the forum help you. Please don't make the forum guess, it wastes everyone's time.

1706821730765.png
 
Last edited:
Upvote 0
Follow the arrow in the image to the link:

What does the data in the web look like when you copy it? Have you tried posting in a brand new worksheet with no hidden columns?
And please do as we ask, just don't say what you have done. The forum cannot replicate "what you see"? That is why I asked for the xl2bb mini worksheet or a table of everything.
Before
what you're pasting
what you expect it to look like.

Help the forum help you. Please don't make the forum guess, it wastes everyone's time.

View attachment 106175
I was on the phone yesterday and it didn't show the signature until i'm on the computer

I'm on the computer and it doesn't let me install XL2bb
1706892266751.png


I will share a google drive of the file

Loading Google Sheets



pic below is online excel

1706892661417.png



---------------------------
screenshots Below are files on the computer

Before
1706892430282.png





After

1706892402373.png





the google drive file is a file that I have to use since its for work, I dont have another option to use another file/worksheet
 

Attachments

  • 1706892225415.png
    1706892225415.png
    13.7 KB · Views: 2
Upvote 0
I don't see a problem. The data M-F for two weeks matches in both images.
 
Upvote 0
Hi I'm trying to copy numbers from Dec 1 to Dec 15 on the web Excel and when I try to select those days on the downloaded excel files it will only let me select 5 days

There's a barrier after Friday
 
Upvote 0

Forum statistics

Threads
1,216,100
Messages
6,128,830
Members
449,471
Latest member
lachbee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top