Copy and Paste w/in a table using VBA including Formulas

[sorensjp]

Hello all,

I'm having problems using 'Copy and Paste' with VBA of data between two Sheets with one having advanced filters. I'm having two problems that I think are related.

On my EVENTS Sheet contains the mapped data from the EVENTS LIST Sheet. I want a copy of all of the EVENTS LIST data copied to ROW 29+ on the EVENTS Sheet (eventually I will incorporate filters too). As I highlight a ROW of data on the EVENTS Sheet the data is pull to the on sheet User Form at the top. But If I make any changes they are improperly reflected the table below on the same sheet and the EVENTS LIST sheet as well. For instance - If I make a name change in cell F5:G5 the table below changes to a CREW_ID and oddly it shows the wrong one and if I change the name to the same name it shows the correct CREW_ID but I don't want that shown I want the name shown. The other aspect is the Start On (Date + Time) in K29+ doesn't show the data (I'm trying to use a Copy & Paste Special to combine two fields coming from the advanced filtered data set on the EVENTS LIST Sheet.

The Adv Filter Code VBA is contained on Events_MISC Module under Sub Event_Refresh(). I'm using Worksheet_Change Sub for Sheet 5 (EVNTS Sheet) to make updates directly to the table on that sheet.

This project is based mostly the Employee Manager Series - by Excel for FreeLancers (Randy Austin) on Youtube. The specific video is:

as it relates to the part of my project.

I've received a lot of help on this Forum and cannot be more "Thankful" for all the advice and assistance.


V/r,
Jim


Edit:

I figured out the "Start On (Date + Time)" Copy & Paste Formula issue. I didn't properly adjust for the number of "cells" shifted too the right when the formula is copied due to not being absolute referenced.

[sorensjp]

All,

Thank you for looking at my Project but I was able to resolve my issues. A few references in the VBA were not updated properly in all areas as I added items.

V/r,
Jim