macro - all sheets

Hey, I wanted to copy the values of a coloumn. The coloumn has following formula "=INDEX('Planungsakte (2)'!E:E;VERGLEICH(C3;'Planungsakte (2)'!C:C;0))". VERGLEICH is the german term for MATCH. I just wanted to copy the values and paste it somewhere else in excel because i will delete the excel...

Hey guys, As the title says, i have two sheets named A and B. I import excel data from a report into sheet A with columns going from a - z, what i am trying to do is set up a formula or macro on sheet B that will automatically fill data from specific columns in sheet A to sheet B. IE Sheet A...

Heya I don't know much of anything about VBA or coding or whatnot so please forgive any ignorance I may have but if someone could create a macro for me that would be amazing! So I have an excel spreadsheet where I keep track of various entertainment I enjoy and in particular shows and any...

Hello: I have a workbook that has several spreadsheets. In some, but not all, of the worksheets in the workbook I need to add a formula to a specific column. I have a macro that will add the formula to all the worksheets but is there a way to omit a few of the worksheets from the macro?

Hi I need to do a homework but I can´t understand how to it. My teacher wants a Macro and a button. When I press the button she wants that the button sort the selected range. Please I need help, I hope someone can give me a hand with the code, it will be great.

Hi, My team pulls open orders weekly and puts them into a workbook. This workbook has all the columns/data I need but I want it in a specific format and it is also always put in the same place with generally the same name. I need to pull into separate workbooks the sum of units by the due date...

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...

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...

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...

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...

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...

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...

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...

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...