Copy and paste data into an excel generated cell location

**BRIANHD** · 04-18-2013, 06:34 PM

I am very new to Excel Forum and also VBA. I have learned some things by searching and reading various threads but cannot find exactly what I am seeking. My excel sheet generates data which needs to be copied to variable locations. The locations are generated by LOOK-UP and ADDRESS fuctions and are shown in the cells with the format $Column i.d.$Row i.d. How can I extract this location data from the cell then copy and paste data to this extracted cell location.

Any help would be much apprecited as this is the last step that will allow my whole project to run efficiently.

Best regards.

**coreytroy** · 04-18-2013, 06:48 PM

Brian,

You may need to upload an example workbook to show exactly what data you require copying.

**BRIANHD** · 04-19-2013, 04:18 AM

coreytroy,

Many thanks. I will upload example as soon as possible. Please be patient as need to discover how to attach a file or folder.

Best regards

**BRIANHD** · 04-19-2013, 06:17 AM

coreytroy,

Please find attached workbook below. The first two sheets have false data in them simply to test sheet three. All the calculations in sheet three 'Premier League' are via excel functions except for columns AI to AP which are generated via a macro to give absolute values of data and location. Before this new data is inserted the current fixtures and results need to be deleted.

Data in column AI needs to be inserted in cell location in column AJ sheet 'Premier League'.
Data in column AK needs to be inserted in cell location in column AL sheet 'Premier League'.
Data in column AM needs to be inserted in cell location in column AN sheet 'Total of Draws'.
Data in column AO needs to be inserted in cell location in column AP sheet 'Total Games Played'.

Although the maximum number of fixtures is 10 very often single games are played during the week. Every game played and its result needs to be entered to keep the two arrays and the team data correct.

To be able to do the above via a macro/AVB would be superb. Manually a nightmare. I am sure you experts out there will have a simple answer.

Best Regards

EXCELFORUM EXAMPLE.xlsm

**BRIANHD** · 04-24-2013, 02:53 PM

I seemed to have solved the problem for myself by searching various threads in the forum. What I have done may not be the best in VBA but it seems to work.

Best regards