VBA - criteria lookup and the removing formula from cell
Closed
Debs269
Posts
21
Registration date
Monday October 15, 2012
Status
Member
Last seen
August 18, 2016
-
Apr 22, 2014 at 12:07 PM
Debs269 Posts 21 Registration date Monday October 15, 2012 Status Member Last seen August 18, 2016 - Apr 24, 2014 at 07:31 AM
Debs269 Posts 21 Registration date Monday October 15, 2012 Status Member Last seen August 18, 2016 - Apr 24, 2014 at 07:31 AM
Related:
- VBA - criteria lookup and the removing formula from cell
- Number to words in excel formula without vba - Guide
- Vba case like - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Clear only the formatting from the selected cell (leaving the content) - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 23, 2014 at 01:38 AM
Apr 23, 2014 at 01:38 AM
select H6. copy(control+c).
without removing selection cllick "pastevealues"
quote
Then go on to the next row, I also want it to ignore blank cells and leave the formula there.
quote
this is not clear
do you mena to say that when j of a row i1 then corresponding cell in H column should be values not formulas. if 0 keep the formula. clairfy
without removing selection cllick "pastevealues"
quote
Then go on to the next row, I also want it to ignore blank cells and leave the formula there.
quote
this is not clear
do you mena to say that when j of a row i1 then corresponding cell in H column should be values not formulas. if 0 keep the formula. clairfy
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 24, 2014 at 12:17 AM
Apr 24, 2014 at 12:17 AM
better way of explaining to send a small extract of your data through speedyshare.com and explain again
Debs269
Posts
21
Registration date
Monday October 15, 2012
Status
Member
Last seen
August 18, 2016
2
Apr 24, 2014 at 07:31 AM
Apr 24, 2014 at 07:31 AM
Thanks, I have managed to write something that doing what I want .. probably a better way but it is working
Thanks for your help... next will attach extract
Thanks for your help... next will attach extract
Apr 23, 2014 at 04:48 AM
In Column I has an "if" statement, that is looking for a date in column J (which is looking up data from another sheet)
Column H ... "if" statement that is looking if that date is less than or equal to todays date.
All I am trying to do is remove the formula in column H and leave the value so that when the date changes in column I it does not change in column H
If no date in column H then I want the formula to stay
I need to loop through all the rows in the sheet.
Sorry I hope I have explained it better
Debs