Copying XL2BB sheet from Board to Excel Problems

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
2,192
Office Version
  1. 365
Platform
  1. Windows
Is there a better way to copy the sheets posted using XL2BB into Excel? This is an example where the titles end up shifted to the left and the row numbers are added to the left for the remaining rows.

ExampleStart DateEnd DateWeek Number
21Monday, December 27, 2021Sunday, January 2, 202252
3Monday, December 21, 2020Sunday, December 27, 202052
4
5ExampleStart DateEnd DateWeek Number
62Monday, December 25, 2023Sunday, December 31, 202352
7Monday, December 26, 2022Sunday, January 1, 202352


This is what it should look like
ExampleStart DateEnd DateWeek Number
1Monday, December 27, 2021Sunday, January 2, 202252
Monday, December 21, 2020Sunday, December 27, 202052
ExampleStart DateEnd DateWeek Number
2Monday, December 25, 2023Sunday, December 31, 202352
Monday, December 26, 2022Sunday, January 1, 202352
 

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
2,032
Jeffrey: Starting a conversation with you. If you could send me the workbook that generates the first mini-sheet, then I can look at it to find out what's wrong with either XL2BB or the workbook. Honestly, this is the first time I heard of such a problem.
 

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
2,032
Oops. You mean copying from board to Excel.

Which mini-sheet (post-question) are you trying to get the sheet data and it adds the row numbers when you paste it into the worksheet in Excel? Could you please share the thread link here, so I can try to see what's wrong with it?

If you mean the following thread:

I just tested it and it work without problems:
Book1
ABCD
1ExampleStart DateEnd DateWeek Number
2112/27/211/2/2252
312/21/2012/27/2052
4
5ExampleStart DateEnd DateWeek Number
6212/25/2312/31/2352
712/26/221/1/2352
Sheet1
Cell Formulas
RangeFormula
D6:D7,D2:D3D2=ISOWEEKNUM(B2)
C3C3=B3+6


1673904271208.png


Note: I am sure you do but just to make sure. You actually use the little copy button on the left top corner to copy the mini-sheet, right?
1673904401377.png
 
Last edited:

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
2,192
Office Version
  1. 365
Platform
  1. Windows
Ok, I didn't know that was there.... and it works. That's just me going through life doing things the hard sometimes.

Thank you
 

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
2,032
Ok, I didn't know that was there.... and it works. That's just me going through life doing things the hard sometimes.

Thank you
(y) Glad to hear it is solved :)

We named it as "BB2XL" button, so it is somehow the reverse action of XL2BB. And actually, it is a great tool that also copies all regular formulas as well! (not the old array formulas - CSE ones, but still works well.)
 

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
2,192
Office Version
  1. 365
Platform
  1. Windows
Hey, I just noticed that it tells me I can Alt-Click on the BB2XL button and copy only the number formatting and values. While it did only copy the values, the cells had BG colors also.
 

Forum statistics

Threads
1,186,326
Messages
5,957,228
Members
438,294
Latest member
Soikeo79

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
Top