$$Excel-Macros$$ Using date criteria to get the Sum

hello All, Please I need some help with writing a macro or using excel formula to get the sum of the data. I am working with a large set of data. It runs up to more than column CC. I will be able to continue once I get the foundation I want to be able to get the total for each day for ea

$$Excel-Macros$$ Duplicate Values

morning, Please I need help with excel. I don't need a macro. so I don't know if this is the right section. I have to create a pivot table with the below information. I have a lot duplicate numbers in column B. I need to create a pivot table with the following information. 1) Column B da

$$Excel-Macros$$ Refresh Pivot Table / New Data Source

So, below is what i have to update 10 pivot tables. Some spreadsheet can have more than 1 pivot table. is the below the best approach? I want to make sure that all the tables are being updated with the correct information and new row source. data is not being corrupted The pivot table can have

$$Excel-Macros$$ Copy and Paste Large data in excel using Macro

Copy and Paste Large data. I have a question about using Macro to copy and paste large data to another workbookI have data with 6000 rows running up to column AK. Is this a safe approach? I am going to use this copied data to update 10 pivot tables Below is the code that I am using. Wor

$$Excel-Macros$$ Re: Need help Using Isblank and days360 in Macro

"" "",DAYS360(RC[-29],RC[-27])))" Next For Each CurCell4 In Range("aK2:aK" & Cells(Rows.Count, "B").End(xlUp).Row) CurCell4.Value = "=IF(ISBLANK(RC[-28]),"" "",DAYS360(RC[-28],TODAY()))" Next End Sub On Wednesday, March 9,

$$Excel-Macros$$ Need help Using Isblank and days360 in Macro

Hello all! Please I need macro help with the below in red: What is the best way to achieve this without using the formula that I got from running the macro and also making the code short? I have already completed the Sum in column AH 1. Column AI to the last row should hav

Re: $$Excel-Macros$$ Search and Data Formating help....

(xlToLeft).Column > > 'Now for some data: > Cells(1, colLast + 1) = "TYPE" > Cells(1, colLast + 2) = "PMG" > > Cells(2, colLast).Select > Set Rng = Range("I2:I" & Cells(Rows.Count, "B").End(xlUp).Row) >

Re: $$Excel-Macros$$ Search and Data Formating help....

> - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* >

Re: $$Excel-Macros$$ Search and Data Formating help....

all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Tuesday, February 23, 2016 8:48 AM, Maju > wrote: > > > > Hello All,

$$Excel-Macros$$ Search and Data Formating help....

Hello All, Please I need help with the below macro. I have a worksheet with lots of data. 1. I want to go through each cell in column J. To find data and put the answer in column O. 2. Then left and Right trim spaces 3. Delete any extra line after the l