a18

  1. D

    copy to another cell even when new row is added

    Dear forum, I want to copy the value of cell A18 to M4 even when a new row is added. When I use =A18 and then add a new line the value in M4 changes to A19. I want it always to be A18 can this be done and how, please. Daisy ps not sure how to add my signature yet
  2. D

    There's gotta be an easier way....

    Ok - I have another question. Sorry. I've got two tabs in my spreadsheet (Tab 1 and Tab 2). On tab 2, I'm attempting to copy and paste the value that's in every 11 rows of tab 1 starting with cell A18. (It's the sum of several items). So for example, I need the value in cells A18, A29...
  3. I

    Insert photo code

    Evening, I would like some advice on a code to insert a photo into a cell using the command button Some info for you. CommandButton2 Path to image is C:\Users\Ian\Desktop Photo name will always be BAR CODE 1 Photo to be inserted into cell A18 Worksheet is called EBAY Basically press 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