VBA - criteria lookup and the removing formula from cell
Closed
Debs269
Posts
21
Registration date
Monday 15 October 2012
Status
Member
Last seen
18 August 2016
-
22 Apr 2014 à 12:07
Debs269 Posts 21 Registration date Monday 15 October 2012 Status Member Last seen 18 August 2016 - 24 Apr 2014 à 07:31
Debs269 Posts 21 Registration date Monday 15 October 2012 Status Member Last seen 18 August 2016 - 24 Apr 2014 à 07:31
Related:
- VBA - criteria lookup and the removing formula from cell
- Https //accounts.google.com/sign in/v1/lookup - Guide
- Excel cell color formula - Guide
- Number to words in excel formula without vba - Guide
- Removing search baron from mac - Guide
- Vba case like - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
23 Apr 2014 à 01:38
23 Apr 2014 à 01:38
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 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
24 Apr 2014 à 00:17
24 Apr 2014 à 00:17
better way of explaining to send a small extract of your data through speedyshare.com and explain again
Debs269
Posts
21
Registration date
Monday 15 October 2012
Status
Member
Last seen
18 August 2016
2
24 Apr 2014 à 07:31
24 Apr 2014 à 07:31
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
23 Apr 2014 à 04:48
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