ExcelBanter - Refresh data

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Refresh data (https://www.excelbanter.com/excel-programming/390712-refresh-data.html)

jinx

Refresh data

Hi,

I have two workbooks... (WKB1 & WKBK2)

WKBK1 feeds WKBK2... WKBK2 takes a selection of data from WKBK1 via VB and
function references in each worksheet.

My problem is that I can't get WKBK2 to automatically refresh the data... so
when WKBK1 has been updated I can press a 'refresh' button in WKBK2 and the
data will be updated.

does anyone know how to do this...

thanks
--
Thanks... Jinx

jinx

Refresh data

no worries... have worked it out thanks.

used worksheets.calculate
--
Thanks... Jinx

"jinx" wrote:

Hi,

I have two workbooks... (WKB1 & WKBK2)

WKBK1 feeds WKBK2... WKBK2 takes a selection of data from WKBK1 via VB and
function references in each worksheet.

My problem is that I can't get WKBK2 to automatically refresh the data... so
when WKBK1 has been updated I can press a 'refresh' button in WKBK2 and the
data will be updated.

does anyone know how to do this...

thanks
--
Thanks... Jinx

All times are GMT +1. The time now is 05:01 AM.