IF (cell text value) THEN copy & paste from another workbook

AndrevdS

New Member
Joined
Oct 29, 2019
Messages
2
Hi All,
Virgin poster here, rookie VBA user...please be gentle...

I have a Master workbook which automatically compiles various worksheets drawn from different Project workbooks (no code involved, just links)
Besides the linked data, I also need to copy/paste tables and graphs depending on cell values.
So to cut a long story sideways, I need to do something like the following:

CASE (cell-value in Master workbook) COPY (RANGE from Project workbook) and PASTE as a linked picture.

Is there any civilised way of doing this?

Thanks,
A.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,095,380
Messages
5,444,113
Members
405,268
Latest member
JLEMS

This Week's Hot Topics

Top