Urgent VBA excel help! - reorganize data

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
How do I write the VBA code to search Events by date and reorganize them into a totally different format in a different sheet?

Original spread sheet in each column:
Event Category(3 types) ,Starts Date (mm/dd/yy),Ends Date (mm/dd/yy),Event Title,Event Details, Contact Name, and Contact Phone #

Search command need to show as a calendar format:
Event Category (same category ones show as one category), as rows

Next 30days Events, next 60days Events, Next 90 Days events, and 90+ days Events. as column.

and the Event Details, Contact name & phone number all will be combined and added in Event Title cell as comments.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Best way would be to record your action by using macro recorder. This will give you a template that you can adjust to suit you
Thanks for the reply!
Still cannot figure it out. Is there any way I can email you the spread sheet I'm working on? Please send your email address to me at dora-r-tang@hotmail.com.
Thanks,
DT
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can attach the book at some share site and post the link there. Here is one such site https://authentification.site