LinkBack URL
About LinkBacks
Hi,
Can anyone help to amend this code? I need the code to add a zero in columns B&C in range if I in sheet 2 is not available.
Thanks
Please Login or Register to view this content.
Johnny
Hi,
Can anyone help to amend this code? I need the code to add a zero in columns B&C in range if I in sheet 2 is not available.
ThanksPlease Login or Register to view this content.
Johnny
Upload the workbook........
Lokesh Kumar
Stay Hungry.. Stay Foolish..
_________________________________________________________
Please Click STAR to Add Reputation if my/someone's answer helped!
Try this cod......
If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.Please Login or Register to view this content.
The code puts in 3 zero's for some reason even if I is available it still adds the contents in I + three zeros?
Hi
Just do me a favor I know this is the second time I am saying this.....
Run the code.......when it is putting 3 zero save the file and insert comment what you need and upload the file........
I have attached 3 examples for reference, Sample A is with the macro run with no data in sheet 2 with I in column A, Sample B is macro run with I occurring once in sheet 2 column A and sample C is macro run with I occurring twice in sheet 2 column A.Hope this helps and if you need anything further please let me know.
Earlier you requested......Correct me if I am wrong....
Here on sheet 2 I is only available on 1st line and 5th line...I need the code to add a zero in columns B&C in range if I in sheet 2 is not available.
So output will only show you data in 1st line and 5th lineI 15 132 170.09
R 7692.22 142.32 176.68
T 2926.73 67.23 44.98
W 4920.96 111.22 133.71
I 16 220.61 170.09
R 12456 142.32 176.68
T 2926.73 67.23 44.98
W 4920.96 111.22 133.71
15 132
0 0
0 0
0 0
0 0
16 220.61
0 0
0 0
0 0
0 0
Sorry, communication error, On review "I" will only occur once at any one time in sheet 2 and if "I" in not available I want a Zero placed in range instead of what is input from the data which is stored in "I", I should have been a bit clearer sorry.
It means after one time if "I" appear then it should place zero like this.......
15 132
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
No it means that if I does not appear it places a 0 instead
Hi,
Just check if it works for you........
Please Login or Register to view this content.
When the macro is run now with no I in column A Sheet 2 instead of a zero the code is inputting figures instead of one row of zero's in columns B&C within the row in range?
So basically what sheet 1 columns B&C should look like in next available row when I is not available is sheet 2 is;
and if sheet 2 contains I with 15 in column B and 245 in column C then columns B&C in sheet 1 next available row should show;Column A Column B Column C
21/04/2015 0 0
Column A Column B Column C
21/04/2015 15 245
The Initial code I have pasted is doing the same job........if It is finding "I" in sheet 2 it is copying the data from next 2 cells and pasting into last available row in Sheet 1....If there is no "I" then it is going to put 0....Originally Posted by Burt_100
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks