# Copying XL2BB sheet from Board to Excel Problems

#### Jeffrey Mahoney

##### Well-known Member
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.

 Example Start Date End Date Week Number 2 1 Monday, December 27, 2021 Sunday, January 2, 2022 52 3 Monday, December 21, 2020 Sunday, December 27, 2020 52 4 5 Example Start Date End Date Week Number 6 2 Monday, December 25, 2023 Sunday, December 31, 2023 52 7 Monday, December 26, 2022 Sunday, January 1, 2023 52

This is what it should look like
 Example Start Date End Date Week Number 1 Monday, December 27, 2021 Sunday, January 2, 2022 52 Monday, December 21, 2020 Sunday, December 27, 2020 52 Example Start Date End Date Week Number 2 Monday, December 25, 2023 Sunday, December 31, 2023 52 Monday, December 26, 2022 Sunday, January 1, 2023 52

#### smozgur

##### BatCoder
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
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

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?

Last edited:

#### Jeffrey Mahoney

##### Well-known Member
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
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
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
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.

#### smozgur

##### BatCoder
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.
Exactly!

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?

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