macro - formula

Im trying to create a macro that comments based on another sheet I set up with the text in proper order (ie. A1 on Comment Sheet has Comment that should be in A1 for Sheet 1 and so on). I'm struggling with automating this one, does anyone know how to do this?

Hi, I'm currently producing a pivot table and I'm trying to write a macro for the data that coincides with it. I have three sheets, Sheet1(PivotTable), Sheet2(Data) and Sheet3(Mapping) Sheet2 uses a couple of inputs to drag data from Sheet3. What I want to do is write a macro that will write...

I am currently trying to get a macro to basically copy the formulas I have set up from P15:AN15. Each column is a different equation and I need it to run the equation all the way down to the last row of column O. The spreadsheet I am using currently has multiple tabs but, will only need to...

I've multiple worksheets but I need consolidate from five ("India", "Japan", "china", "australia" and "south korea") worksheet to "Master" worksheet Problem is Headers in all the sheets are difference hence I need to copy and paste the details matching the header in Master worksheet. If I get...

Hi, Please help me in this problem. I have my data in worksheet 1 with Row headers..Like Name, City, Assignment,Date. Now worksheet 1 is having list of 100 members in Column1 and they will be assigned 2-3 type of assignment on daily basis. Assignment will be entered on Column 2..Date will will...

I have a macro that creates multiple charts. The data is time sequenced and I would like to slow down the macro so the changes in the charts can be seen as they are made. Sort of like a movie effect. Can this be done?

Hello I'm trying to find a way to extract a User ID from cells in a field called Metadata. The data is not in a similar format in each cell and I've been racking my brain trying to figure out how to easily extract the User ID to an adjacent cell so I can run it easily daily without having to...

Hia, I have the following formula, which works when entered into a cell directly, but when I attempt to include it in a macro the text turns red & is not accepted. Unfortunately there is no error message displayed so I don't even have a starter to hit google with, so I'm assuming that at 1021...

I have some 10k lines in both VAN and SHOPS column. Sometimes the Vans go to wrong shop so I would like to know how many times a van went to a certain shop . Source: <tbody> Date VANS SHOPS 30/11/2017 VAN1 SHOP1 30/11/2017 VAN1 SHOP2 30/11/2017 VAN1 SHOP1 30/11/2017 VAN1 SHOP3...

With rows of data of a few thousand this runs in under a minute. However the data is now just over 100,000 and the macro makes excel not respond. Can anyone help. thanks Sub DailyToMaster() ' ' DailyToMaster Macro ' Ctrl+Shift+Z ' ' Keyboard Shortcut: Ctrl+Shift+Z ' Application.Calculation...

I have an excel (generated from a polling app) in this format: Person 1 Person 2 Person 3 Person 4 Option A Yes Yes Option B Yes Option C Yes What I...

So I have this problem when importing a csv file, one cell has information that needs to be split into columns or repeated with the same tablet id. I have tried several combinations but everything takes time and it is not clean and it doesnt solve the problem, any ideas data is below and the two...

I'm trying to create a spreadsheet to keep track of my inventory.I am using Microsoft Excel for mac on 365Column I, I would like to add new stock in to add to Column K which I can do by a formula using column J<tbody>=I+J</tbody>Ideally, I want a macro button or something that then deletes I for...

Hello Everyone, I just made excel searchable drop down by using active x control (Combo Box) and it's working fine But to select the drop down value i have to use Mouse , however i want to select the drop down value by arrow keys. is it possible? Please help

I'm trying to create a macro to replace a formula and I don't seem to succeed. So I'm asking for your help. Situation: I’m using a formula incolumn M, row 2 to 65536 which fetches the content of column V, row 2 to 65536. The result in column M, row 2 has tobe as “P0000000”. In this example =...

I use this array formula in an excel sheet. The formula works fine in a small data base. The database is currently 600 rows long and growing and now it takes time to calculate. I think that a macro instead of the array formula could help to speed up the calculation. Can somebody help me finding...

I have columns A through DB (A:DB) with data, and there is a varied number of rows for each column. If possible, I need a macro that will "stack" columns in pairs of two. For example, column "C" directly under column "A" and column "D" directly under column "B" and so on for all columns A:DB...

i have a document which has a lot of information in sheet1, column a right up to column BI. i would like to be able to tick a box in column BI that then removes the row from sheet 1 and puts it into sheet 2, and adds a date. this is my formula so far, but im getting stuck at the text highlighted...

Hi Experts, Heres my query and thank you in advance for your help. TABLE 1 === I have a list of sales transactions. <tbody> Date Item # Revenue Cost Profit 17 feb 2017 568 $100 $70 30 18 Feb 2017 439 $120 $130 -10 01 Mar 2017 439 $150 $130 20 </tbody> TABLE 2 === I have another table...

I am creating a new macro to enable a custom report from a download we use on a bi-weekly basis. Initially, I recorded the macro. This has given me everything I need, except for my last piece. I need to find the last row, go one row down, and sum columns J, K, L, and M. Then in column "I"...