appends

  1. M

    Named Range Possible - Two worksheets

    There is 3 fields to fill in on Worksheet: Cells A1 to A3 . And customers put data in Cells B1 to B3. FirstName: LastName: StateName: I would like VBA to take the open worksheet and copy the data into Worksheet2 transposed from columns to rows. I would also like to have named ranges...
  2. A

    If Statement Vlook Up not working

    =IF(VLOOKUP($A3,FiberServiceabilityDetail!$A:$BB,54,FALSE)={"Construction Required","On-Net","Autobuild"},(VLOOKUP($A3,FiberServiceabilityDetail!$A:$AL,38,FALSE)),"") Hello I have this formula that picks up the const required being the first criteria and appends the cost from...
  3. S

    Save as appends new extention to old one in 2016?

    Hi Everyone, I just joined and it's my first post. Just got a new computer with Ecxel 2016, was using Excel 2010 on old computer. With 2010, when I take a .xls file and save as a binary spreadsheet, it highlights the name minus the .xls file extension. The new file becomes a .xlsb, easy...

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