macro - all sheets

  1. D

    Macro that moves an entire row from one sheet to another based on date in one cell and value in other cell.

    I use a spreadsheet to track when I need to call a client after a set period within a given territory. Each client territory is represented on a different sheet within my workbook. I already have a macro that can move a client, represented by a row of data, between any of the sheets of the...
  2. L

    Correction on Sheet duplication code

    Hi Everyone, I need help just with a quick look into the code I've been working on the recent days I am working on a file to map activity times for some team mates and so far, we have two initial tabs, the tab "List" and the tab "Activities", like this List Activities So far, lets say...
  3. L

    VBA for duplicating slide and changing name based on table

    Hi Everyone! This is my first post and I just have one question Let's say that we have two separate sheets, the first one, witha table of information for each teammate, like this one ID Name Last Name 1 A D 2 B E 3 C E And another sheet (let's call it "List" the one we want to copy...
  4. H

    Macro is required to the data filter

    Hi Excel Experts, I am looking for one small automation macro to filter the data below and need to keep one set of data from the input to the output. We have three columns below and Col-1 where "Y" is applicable in Col-3 then Col-1 cell value should be base and corresponding Col-2 data...
  5. E

    VBA Help on Data Copy

    Hi everyone, I have a question about the VBA code I wrote below. First of all, a brief summary of what I try to achieve: I have 2 excel sheets, sheet1 and sheet2. The sheet1 has the data in B:AW and the sheet2 has a data in the M:W. I wanted to create a VBA code that copies the data in B:I and...
  6. E

    Dynamic Copy Data between Sheets

    Hi everyone, I have a questions regarding copying the data between the sheets. I have a sheet, lets call sheet1, and I want to create a new sheet sheet2, which gets partial data from sheet1 and also updates itself based on the updates on sheet1. For instance, lets say I have the data in...
  7. J

    Clear data in a cell using a macro

    Trying to use a macro on excel to clear a column of data containing data, for example B2 down to B1500. I need it so when i click the macro it will clear this selection. Problem is i have another macro doing this on sheet two. But i cant work out how to set up two macros doing the same thing...
  8. N

    Lock column ranges based on value in header row, loop through all

    Hi, I need some help getting this macro to loop. I have a Budget Forecasting workbook with about 40 sheets and I need to unlock cells where the final users will input projections. Below is a snip of the ranges involved. If the value in Row 6 of the column is "Projected" then the cells in rows...

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