vba & cut

  1. E

    Switch between different PivotTable Fields for Values

    Hi, I have an excel file where employees can submit projects they are working on and amount spent on the project each month. The names of the months are therefore in the columns as headers. When I make a PivotTable out of the table I have the persons in the Row sections and the month I want to...
  2. F

    How to create by 1-100 row to 1 sheet then loop next to...

    1-100 = sheet(1) 101-199 = sheet(2) 200-299= sheet(3)
  3. N

    VBA to cut and paste or move data from the Master sheet when column D says "Completed" or "Deferred" to either the Completed or Deferred Worksheet

    Hello everyone, I'm in need of some assistance. I want to have the data from each row to be cut and pasted or moved (whichever is easier) to the corresponding worksheet based on specific criteria. When column D (Status) in the Master worksheet reads "Completed" I want it to automatically be...
  4. K

    Get name of pasted shape in another sheet

    Hi all, it there solution how to get shape name/id of pasted shape in another sheet. When I use the debug method/steps, cutting/pasting is done and in the second sheet the object/shape looks like it's selected, but I can't retrieve the name of the object/shape Here is my try: Dim shapeName As...
  5. J

    Move Table Row to Another Sheet

    Hello, I'm working on a table and need to automatically move a row to another table on another sheet. ABCDEFGIJKL1EFGHRev 1_02Project Impact Tool (Six Sigma Tool)From 1 to 5 1 = Low; 3 = Medium; 5 = High3Proj. ID:Project TitleWhat problem are we trying to solve? What is the business impact we...

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