I have two excel spreadsheets that have two arrays of size 90 rows 900 columns.
A column out of each array needs to have it's data copied to another workbook, saved (file name is in one of the cells of the column), some data that's being looked up in the destination file will need to be hard coded (i.e. a index/match or vlookup formula will need to be converted to text. Some cells in the destination sheet need to have data validation on a drop down menu.
I've started this porting effort in Openpyxl and am just having trouble finishing the last parts. I can send you what I have. Python implementation would be prefered. Would do it myself but I need a quicker turn around.
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. I would offer native Excel VBA solution.
Bu iş için 12 freelancer ortalamada $91 teklif veriyor
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel Via VBA macro Sir :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Daha Fazla
Hi Sir/Madam, I'm expert in Python programming and I have experience working with excel files using Python, so I can help You with this task. Best regards, Fejs.
Hi, No Phyton, but I can write an Excel macro with VBA to do exactly what you want. If it is OK for you, I need the files, and detailed explanation of what is required. Best Regards