Copying XL2BB sheet from Board to Excel Problems

[Jeffrey Mahoney]

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]

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]

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:

Find previous start and end date base on current Start & End Date and Week number?

How to find Start & End date of previous year (Yellow Highlight) base on current Start & End Date and Week number? ABCD1ExampleStart DateEnd DateWeek Number21Monday, December 27, 2021Sunday, January 2, 2022523Monday, December 21, 2020Sunday, December 27, 20205245ExampleStart DateEnd DateWeek...

www.mrexcel.com

I just tested it and it work without problems:

Book1
	A	B	C	D
1	Example	Start Date	End Date	Week Number
2	1	12/27/21	1/2/22	52
3		12/21/20	12/27/20	52
4
5	Example	Start Date	End Date	Week Number
6	2	12/25/23	12/31/23	52
7		12/26/22	1/1/23	52
Sheet1

Cell Formulas
Range	Formula
D6:D7,D2:D3	D2	=ISOWEEKNUM(B2)
C3	C3	=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?

 

[Jeffrey Mahoney]

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]

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]

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]

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!