Heading for a range?

[Jimmasterton]

Hi experts
I wonder if you can help me with this, it’s reslly frustrating.
I have 3 sheets
Sheet 1 has 2 command buttons, button 1 generates a non typical range of cells info on sheet 2. Button 2 copies the info from sheet 2 onto a summary page on sheet 3.

I want to use this button 5 times (mon to fri) and I’ve written the macro to copy everything, but I can’t figure out a way to simply put the words Monday, Tuesday etc above each copied range!

 

[jproffer]

That's probably the problem. In the workbook I set up to test with, I named the sheets "Monday", "Tuesday", "Wednesday", "Thursday", and "Friday".

But that's pretty easy to fix I would think. What are your sheet names?

 

[Jimmasterton]

So there’s only 3 sheets, sheet1, sheet2 and sheet3

 

[jproffer]

Ok. You have one summary sheet, right? So the 5 days of the week are all on 2 sheets?

 

[Jimmasterton]

Not quite, button a on sheet 1 generates a range that lands on sheet 2. Then back to sheet 1, button b sends that range to sheet 3. If I repeat this process 5 times I have 5 separate tanges on sheet 3. So far there is no reference to days of the week. Just 5 blocks of info on sheet 3. Blocks of info that can and will change size.

I had a thought though, if the ranges place on column B instead of A on sheet 3 I could somehow generate the Monday to Friday next to each block of info. All I really need to do is identify a top row of each range?

I don’t know

 

[jproffer]

I can't visualize how each range is "generated" or where it comes from, and how it knows where to start and stop for a particular day. However, if you post your workbook to google drive or some similar file sharing site, I'll be glad to take a look.

Needless to say, if any information in the WB is confidential, that would need to be changed before you send it, but having it as close to what you're looking at as possible will maximize our chances of success

 

[Jimmasterton]

Hi jproffer

I think I found a bit of a solution to my problem, I’ve created 5 summary buttons for each day of the week, each with this code:

Sheets(“Sheet3”).Select
Range(“A”& Rows.Count).End(xlUp).Offset(3).Select
ActiveSheet.Paat

But I added:


Range(“A”& Rows.Count).End(xlUp).Offset(1).value=“Monday”

And replace Monday with Tuesday etc for each module. This attatches the day of the week to the bottom of each range. How can I get it to the top?