Dear all,
I have worksheet contains formula (Column H and I), and have to fill it manually down to the last data (it was a dynamic range for sure).
One formula also has link data to the other worksheet in the same workbook.
Is it possible to do this automatically?
I tried but it doesn't work.
I am not an expert for this...
Any help would be appreciated
Thanks and regards,
MT
Hi
In the attached file, Sheet data2 has a worksheet_activate macro. On clicking this tab It does all calculations and indicates with a message as updated (right click on data2 tab and choose view code to see the codes)
ravi
You shouldn't need VBA to do this, see here
Your table shouldn't have empty columns within it, this will prevent Excel's database features from working correctly.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks