rick rothstein

Hi team, I want to start counting payments basis month If suppose my month is given Aug'23 then paym1 will be placed in Aug'23 and then Sep'23 , Oct'23 so on If suppose month is Jun'23 then Payment1 will be placed in Jun'23 Pls help me ASAP

I want to copy the data from sheet"RaW" Column "C" start from 2nd row.. And past it to Sheet "Nicedump" Column "D" first empty. this is continue data entry file so every time first empty will be different.. What will be the VBA code?

Am not good at macros and need experts here to help me. Find below the sample data in sheet named "" <tbody> Name training 1 training 2 training 3 goal actual goal actual goal actual res-1 8 5 8 6 N/A N/A res-2 9 8 8 7 9 4 res-3 6 5 8 3 N/A N/A </tbody> Data to be populated in...

I am most likely going about this all wrong but here goes nothing... I am trying to pass a dynamic value into a textbox. My textbox reads something like this: Case(s) A, B, C, D generated given scenario(s) 1, 2, 3. There was/were X ProductType1 and Y ProductType2 totaling $$$$ I have my...

Hi Friends / Rick, My excel sheet has say 29 columns. I need to enter certain formula in the 30th column. I have 'n' numbers of rows with contents. I need to find the last row which carries the contents and insert the formula in 'n16' cell to the upper cell. But the problem is, the last row...

Hi there, I have a data like this, I have put a formula in column D to chack the percentage difference of column b and column c, in column E I need a formula as per my requirement mentioned in Column E. Please help Please help <tbody> NUMBER 1 NUMBER 2 PERCENTAGE FORMULA 2 1.1 45.00% Less...

Hi There I have a data like this in 2 sheets <tbody> SHEET 1 SHEET 2 COLUMN C COLUMN D COLUMN E COLUMN C COLUMN F COLUMN I YEAR AMOUNT DATE YEAR AMOUNT DATE 2005 2005 500 2005 600 10/07/2015 2005 700 21/09/2015 </tbody><colgroup><col><col><col><col...

Hello, I need help!! I have hundreds of thousands of data in column A and their values are also different. So, I want to be able to select a range manually and transpose the selected range to rows in a new worksheet every time I click the Command Button. Need help with the command button code...

<tbody> 791643 -4,105.80 -4,105.80 2/28/2006 -240 -240 12/31/2006 -577.8 -577.8 2/28/2007 -256.8 -256.8 3/31/2007 -271.2 -271.2 4/30/2007 -345 -345 5/31/2007 -276 -276 6/30/2007 -276 -276 7/31/2007 -621 -621 8/31/2007 -345 -345...