Very helpful video! I just had one point: when you copy and paste the columns when recording the macro, Excel only looks at the actual position of the cells (i.e. cells K9:K11). If you were to shift the cells K9:K11 to somewhere else in the spreadsheet, such as to N9:N11, you would have to reprogram the macro. Do you how to make it so that it references the values in the copied cells for the iteration no matter where you move them? It would make a more fool-proof way of doing the iterations. Thanks in advance!
Apologies for the sounds quality - that's what you get with a home rig, sometimes, I'm afraid. I did make sure that the subtitles were accurate, though
Incredibly useful video, thank you! The circular reference thing is so new to me. As you said, I've always been taught to avoid that haha!
Glad it was helpful!
As chemical engineer, this video was very helpful. Thanks
Glad it was helpful!
Thank you so much sir
Most welcome
Very useful, thank you.
Glad it was helpful!
Sir ,can you explain the mass balance on the production of ethylbenzene using excel. Please
I'm not sure what you're asking here, but I'm afraid I don't have time to build a detailed process model in Excel for you...
@@cssandersonllc3172 sir, can you just explain the little process for production of ethylbenzene ?
@@cssandersonllc3172 PRODUCTION OF ETHYLBENZENE BY
LIQUID-PHASE BENZENE ALKYLATION
Please sir explain some mass balance
Imran - I'm sorry, but I haven't looked at that process before and can't really help you
@@cssandersonllc3172 okay sir, but thanks for your reply
Very helpful video! I just had one point: when you copy and paste the columns when recording the macro, Excel only looks at the actual position of the cells (i.e. cells K9:K11). If you were to shift the cells K9:K11 to somewhere else in the spreadsheet, such as to N9:N11, you would have to reprogram the macro. Do you how to make it so that it references the values in the copied cells for the iteration no matter where you move them? It would make a more fool-proof way of doing the iterations. Thanks in advance!
Yes - I think you can name a range in Excel with the Name Manager. You can then point at Range("MyName") in VB
@@cssandersonllc3172 Got it, thanks!
very informative
Glad you liked it
Thank you for this. Hope you can provide us the excel file of your work
I'd be happy to email you the file
Hello. Here’s my email
venusgutierrez20@gmail.com
Thanks
Welcome
speak louder man, cannot hear you..and speak slowly with proper diction
Apologies for the sounds quality - that's what you get with a home rig, sometimes, I'm afraid. I did make sure that the subtitles were accurate, though