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

2016-03-09 Thread Maju
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

2016-03-09 Thread Maju
I came up with below but I need a better efficient way of writing it. I don't think it is the right way to do for each statement all the time. Dim CurCell As Object Dim CurCell2 As Object Dim CurCell3 As Object Dim CurCell4 As Object Dim

$$Excel-Macros$$ Very Urgent: Client in Jasper, IN need 2 Sitecore Developers

2016-03-09 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : **Sitecore Developers* *Location : Jasper, IN* *REQUIREMENTS* - Bachelor’s degree in computer science or related field - 2+ years of Sitecore work experience - 6+ years .Net programming,

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

2016-03-09 Thread Maju
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$$ Change of colour of cell if i put new value -- is pending .

2016-03-09 Thread Paul Schreiner
Here's one attempt: Copy the values in C5:H8 to J5:O8 the Conditional formatting in cells C5:H8 make the cell yellow if the value equal the corresponding value in the J5:O8 cells. If you CHANGE the value in one of the cells, the color is cleared. I'm sure there are other ways to accomplish this.B

$$Excel-Macros$$ Change of colour of cell if i put new value -- is pending .

2016-03-09 Thread big smile
Respected Paul Brother Please do not say sorry. I thought that may be my query is not logical so no body is Answering so I requested again . My 1 st query of conditional formatting is solved but for 2 nd I will check & let you know If I have some any doubt. One more excel query is pending ..