From one workbook to another

S

Steved

Hello from Steved

I have converted a Oracle database file to an excel
spreadsheet. I called it timetable3.xls I have also a
workbook that has the same format called 486.xls.

Please what would the formula be to get the value in cell
A1 from timetable3.xls and pasting it in cell A1 in
486.xls, the value in cell B1,C1 are the same in
timetable3.xls and 486.xls, therefore if B1,C1 are the
same then copy cell A1 from timetable3.xls to cell A1 and
paste in 486.xls (The timetable3.xls will be used to copy
and paste to several other workbooks. ie 486.xls, 500.xls
and so on about 300 of them).

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
How to copy & paste a worksheet but change 1 bit of the formula? 1
Indexing Sheets in Referenced Workbook within formula 1
problems getting this macro to work 8
Build a reference to another worksheet from cell values in currentsheet 3
auto update function from workbook to another worksheet 3
How to use Copy and Paste 1
Different Number of Workbooks each week 2

Top