Macro capture a dynamics column

[Jovillanueva]

Hi Expert,

I have an attendance sheet in Excel file that distributed to different department composed of (12 dept/users) but
it is stored or copied in one folder.This attendance is filled up daily by team leaders as attendance monitoring.
the transaction is located in sheet1. i need to capture the column A to G ( this is the information related to employee, fixed column)
then the columns where the users entered the hours rendered by employee the column label format is Day-Month.

For ex. Today is April 24 (24-Apr), i need to capture the previous day (23-Apr), then tomorrow is APril 25 (capture the 24-Apr transaction).


There is a master user/admin who monitor all those transaction. It collate/captured manually all those transaction entered by users.
I wanted to automate collating/gathering of those data using Excel VBA macro and paste to assign sheet(Raw Data) in the master/admin working file.

May I ask your help on how to do this using Excel VBA macro. Thank you.

[Jovillanueva]

So far this is the codes i accomplished. my concern is how do i copied/dump the records found in the columns (23-Apr)
Based on my codes, I have successfully find the data source and then copy the column A to G of data source to my working file.

btw, Its possible to capture and insert/dump/copy simultaneously the column A to G and at the same time the columns with records that I found in the search. thanks.

Please Login or Register  to view this content.

[Jovillanueva]

Hi,

Somebody can help me on my requirements to capture multiple columns from attendance monitoring using the column header as reference.
Right now my codes capture only one column base on the define value of textbox and paste or copy the records to Admin working file.

Ex. Raw Data

Column
A----------------B-----C------D-------E------F-------G -----H--------I-------J-------K------L
SureName--firstname--Desc--code---area--Process---Sup--1-May---2-May--3-May--4-May--5-May

Desired Result: Depends on what date the amin need to capture. it can be May 1 to May 2 or May 3 to May 4 or a single column

A----------------B-----C------D-------E------F-------G -----H--------I-------J
SureName--firstname--Desc--code---area--Process---Sup--1-May---2-May--3-May


Thanks

Jov