Transfer data to a Report [Closed]

Report
Posts
2
Registration date
Friday April 11, 2014
Status
Member
Last seen
May 18, 2014
-
Hey Guys,

So my dilemma is I have (2) separate workbooks. Workbook (1) has A1 with all basic data...name, address, phone #, etc. going down to A32. Column B is all the data I input. I have a macro set up so each time I'm done (its a call-in appointment sheet), the data is saved based off the individuals last name and it clears the cells for the next caller.

My problem...

I want to take that data and put it into a weekly report of all the calls received. I have in my report workbook Row 5 with all the same corresponding information I used in Column A on workbook (1) going horizontally. I want the information I input each time in workbook (1) to populate the report (not overwriting the info of course), but I can't seem to make it happen. Any help?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!