Create VBA that creates new sheet with data from the main sheet.

**MrWoggie** · 02-27-2021, 09:55 AM

Hi there! I have a schedule with the dates, days and times that a given person will be the president of a meeting. The Schedule Sheet is in attached in this thread. Note that this file has 2 sheets: The Main Schedule and a Calendar Sheet with some days highlighted.

WHAT I NEED TO DO:

I need to create a calendar sheet for every name in the main schedule and in the calendar sheet the days that this name appears need to be highlight (With one color for the morning and another one if it's in the afternoon). I tried to do this using Formulas (And I think it might be possible) but I was unable to do it properly so I tought that this should be possible with VBA, but I'm new to VBA and I don't know how to do it. Can you guys help me?

**nankw83** · 02-27-2021, 10:17 AM

Hi MrWoggie & welcome to the forum,

Can you mock manually your expected results for few examples ?

**MrWoggie** · 02-27-2021, 10:52 AM

I've made some calendars, I will send them to you (if that's what you asked for). It's only one XLSX file with the main sheet and some calendar sheets containing the name of the person and the days that the person's name appears (with yellow highlight for the afternoon and green for the morning).

**MrWoggie** · 02-28-2021, 09:18 AM

Originally Posted by nankw83

Hi MrWoggie & welcome to the forum,

Can you mock manually your expected results for few examples ?

I've made some calendars, I will send them to you (if that's what you asked for). It's only one XLSX file with the main sheet and some calendar sheets containing the name of the person and the days that the person's name appears (with yellow highlight for the afternoon and green for the morning).

**nankw83** · 02-28-2021, 10:43 AM

Hi MrWoggie,

You first have to create the "Calendar Template" sheet as it will be used as a template for each person. Try below code ... I have also attached a sample file

Please Login or Register  to view this content.

**MrWoggie** · 02-28-2021, 11:03 AM

Originally Posted by nankw83

Hi MrWoggie,

You first have to create the "Calendar Template" sheet as it will be used as a template for each person. Try below code ... I have also attached a sample file

Please Login or Register  to view this content.

Oh, I got it now! Thanks a lot, I will read this code and try to learn something from it, thanks buddy!

**nankw83** · 02-28-2021, 11:06 AM

Let me know how it goes .. Also, please don't quote the whole post it just clutter. If necessary, just quote the required part

As you're new to the forum, you can thank those who have helped by clicking the * icon under their usernames to Add Reputation points to them

**MrWoggie** · 02-28-2021, 11:11 AM

Ok! Thanks I will add reputation

Create VBA that creates new sheet with data from the main sheet.

LinkBack

Thread Tools

Rate This Thread

Display

Create VBA that creates new sheet with data from the main sheet.

Re: Create VBA that creates new sheet with data from the main sheet.

Re: Create VBA that creates new sheet with data from the main sheet.

Re: Create VBA that creates new sheet with data from the main sheet.

Re: Create VBA that creates new sheet with data from the main sheet.

Re: Create VBA that creates new sheet with data from the main sheet.

Re: Create VBA that creates new sheet with data from the main sheet.

Re: Create VBA that creates new sheet with data from the main sheet.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] macro creates new sheet and names it, need to create hyperlink to new sheet on main sheet

Macro filtering on main data sheet and creating new sheet with the results

Create automatically new sheet based on main data sheet

Macro to get data from cell in another sheet and write in the main sheet(file attached)

Create copy of multiple worksheets and automatically fill in data from a main sheet

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions