Recent Activities

(Quote from mammam)



Āpani sbāgata jānā'i

How do you determine which sheet to paste the data to ? There are three DATA tabs and 6 sheets to paste to.

I don't see anything on any of the DATA tabs that would tell which sheet to paste to.

So, the macro would:
Reference the Names tab for the unique names
Look to the 3 DATA tabs to filter the first unique name
Highlight sheets 1 - 6, copy and paste values, and save down for that first unique name as a file Swanson, Ron.xlsx
Then loop back to…

Close...the 3 data tabs are my data dump tabs only that I use for reference for sheets 1 - 6. Those summaries on sheets 1 - 6 are what I'd like as the final output and are based on what has been filtered from Column A on my DATA tabs.

If I correctly understand then ..... your workbook actually has 6 Data tabs and not only 3 ?

Thanks in advance.
I have a shape in my worksheet which runs a macro. Surprisingly, after running the macro the shape disappearing. I have fixed the size property of the shape, but no luck.

I have replaced it with an Activex command button. Fixed it's…

No problem, it's confusing and appreciate your help figuring it out. This macro is very close.

Attached 'parksdata' is the master workbook. My first 6 sheets will reference the three data tabs in some way, so when it is filtered for just 1 Name at a…

Dear Roy,

Thanks for your help. It is working properly

It's you, who have fixed my problem

Glad you could fix your problem

Thanks a lot for your Thanks ...AND for the Like

Sorry ... I don't understand your stated goal.

Create a sample workbook with the data separated as you indicated in your last post so it can be compared with the data in its original
form / location.

I am using a text box with a lot of text, so I have the vertical scroll bar. However, when you first open the document, the scroll bar is not visible. You have to click into the text box to see that it scrolls.
Is there any way to make the scroll bar…

Arsoy

Believe your ' message ' deserves the very last warning ...

Glad you could fix your problem

Thanks a lot for your Thanks ...AND for the Like

You haven't imported all the code - the global variables were missing. Also, you hadn't set g_bForm to True when calling the calendar. That needs doing so that the code will know to work with the Form

(Quote from Arsoy)

Thanks a lot Carim,

This is the perfect one I was looking for.
Especially the header part (I forgot to mention). It is nice of you that you took the pain to teach me.

Thanks again

Bhalo Theko
Surajit

Attached is your Version 2

Hope this will help

RoyUK, thank you. While I most definitely understand the economics behind such decisions, I’m hoping that the benefits in our case will be seen. If not, then I be learning something new.

Rory, thanks for your input. I had not thought much…

Ok,
I see what it was.
The code written was for a ListBox on the worksheet,where i actually have a Userform on a worksheet which then has the ListBox on the userform.

So now my code looks like this & some progress is being made BUT.....

(Code, 19 lines)

At…