refernces

  1. N

    Referencing a linked cell in a formula

    Hello All, I have a workbook that references other workbooks to create a master sheet, not using SQL or query builder, simply "='[workbook.xlsx]Tabname'!A1" etc. Within the workbook i have linked cells that open the work that its referencing when double clicked (standard hyperlink). Does...
  2. S

    VBA code to pull data from visible (unhidden) rows to sheet 2

    Hi there! I am working on building a workbook where on Sheet1, a driver's log book data is entered. The columns on Sheet1 that have data that needs to be referenced in a report on Sheet2 are :(Date) & (Violations)x22 The first 10 rows of Sheet1 are headers and then there are 370 rows of data...
  3. T

    Working with late biding vba

    hi, i am working on a project that might be running on diffrent versions of Excel 2003/2007/2010 i heard of late biding and setting up all the Excel objects as Object type. but i haven't realized yet how should i work with this method. should i create a global object and will use it in every...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top