Hi,
I have a huge file with data and I want to populate same cells with the value as the cell value above of it in column B, C, D if I have value in column G.
I add a test file with before/after!
Thank you very much for your help.
Hi,
I have a huge file with data and I want to populate same cells with the value as the cell value above of it in column B, C, D if I have value in column G.
I add a test file with before/after!
Thank you very much for your help.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Assumes your data begins in Row 1
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi,
Thank you for your solution. I think we are on the right track.
...it cleared all 3 columns, B, C, D
sorry..
this is the original piece of data, it starts in row7
01-Apr-17 187 73G BGF 93
01-Apr-17 302 73G BGG 91
01-Apr-17 364 73G BGF 81
01-Apr-17 422 73G BGF 89
01-Apr-17 647 AT5 ATG 32
02-Apr-17 151 318 ASD 81
02-Apr-17 152 318 ASD 81
02-Apr-17 207 AT5 ATD 91
02-Apr-17 273 AT5 ATG 99
02-Apr-17 305 73G BGH 41
02-Apr-17 321 73G BGF 81
02-Apr-17 373 733 BGA 93
373 733 BGA 81 -this is added by me
02-Apr-17 374 733 BGA 93
02-Apr-17 382 733 BGA 89
after I run the code it gives me:
01-Apr-17 187 73G BGF.........
01-Apr-17 187 73G BGF
01-Apr-17 187 73G BGF
01-Apr-17 187 73G BGF
01-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
187 73G BGF
02-Apr-17 187 73G BGF
02-Apr-17 187 73G BGF
it should copy when it finds an empty cell...
Last edited by john55; 05-07-2017 at 03:52 PM.
Try changing this line of code
toPlease Login or Register to view this content.
and change this linePlease Login or Register to view this content.
toPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by alansidman; 05-07-2017 at 04:15 PM.
Thank you! that's it!
John55,
Since you have a 'huge" file it might be worth considering using special cells as it seems to be faster. (although you might as well test on your data)
http://www.contextures.com/xlDataEntry02.html
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Thank you scottiex!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks