alldata

  1. J

    New formula with IF statements

    A formula in cell E11 that would say E11 = H11+ (ALLDATA!BC6*2) IF ALLDATA! T6/220<5.5, THEN ALLDATA!BC6 =0 IF ALLDATA!T6/220>11.5, THEN BC6=BE6 IF ALLDATA!T6/220<5.5 THEN H11=H12
  2. G

    One table multiple sheets ?

    Hi, I am sure there is an easy way to do this (I hope) but I am struggling. Please help :-) I have a large set of data, about 30 columns and about 40,000 rows. About 7 of the columns need updating regularly but it's cumbersome to navigate and tricky to reorganise as the data is appended to...
  3. R

    MacScript calll with POSIX path of filename fails in 2011 vba macro

    I running on macOS 10.10.5 with Office 2011. I'm having a problem with this macro. I cannot get MacScript to return the POSIX path of a mac file path. Sub tryOut() Dim cValue As String Dim thePath As String Dim allData As String Dim unixDesktopPath As String Debug.Print...
  4. J

    Copy/Paste Issue

    Hello folks, Apologies if this is a obvious issue I'm a beginner at VBA. I have 2 sheets (Data1 & Data2) with tables of information which will vary in size. I'm trying to write macro that will find the table size on "Data1" and paste it into a new sheet "AllData" After that it will find the...

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