Find Jobs
Hire Freelancers

Data transfer to another Workbook with conditions and Place data in Table

$10-30 USD

Fechado
Publicado há mais de 8 anos

$10-30 USD

Pago na entrega
First, What I want to get done here is that I want to see if “J11” or “L11” is > then $0 in book1/sheet1, if yes then compare the value of “C11” and “E11” from book1/sheet1 to list of Column C and Column B in book2/sheet1. IF the both values are same in Column C and Column B in book2/sheet1 then check for E12 in book1/sheet1 and continue. And if the value did not match in Column C and Column B in book2/sheet1 then I want to copy D11 to A4, E11 to B4, C11 to C4, J11&L11 to I4 and B11 to H4 from book1/sheet1 to book2/sheet1 and continue in next empty row in book2/sheet1 table. I do have code written and working fine, but there are minor following things that im unable to get it done. See attached two Excel files. 1. Unable to paste data in table in Workbook2. 2. If I put "-" in empty cells in column G, H, J and L in book1/sheet1 the code is not working. Other then above things code is working fine just need modification. Second, I want to enter a number in "B3" book1/sheet1 and place that number in first available empty cell in table2 in book1/sheet2 by clicking on add button. And clear the "B3" cell. Also, if entered number already in table, then should not get place again. Similarly after entering number in "B3" and clicking deleted the number should get removed from table. And cell should get empty for next entry.
ID do Projeto: 9145863

Sobre o projeto

36 propostas
Projeto remoto
Ativo há 8 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
36 freelancers estão ofertando em média $23 USD for esse trabalho
Avatar do Usuário
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$34 USD em 0 dia
5,0 (202 avaliações)
6,9
6,9
Avatar do Usuário
A proposal has not yet been provided
$44 USD em 1 dia
5,0 (159 avaliações)
6,7
6,7
Avatar do Usuário
A proposal has not yet been provided
$15 USD em 1 dia
5,0 (170 avaliações)
6,0
6,0
Avatar do Usuário
Hello Dear, HERE Ready to start!!! I can perfectly do it. I have lot of experience related and different types of projects. I am waiting to your quick positive reply. Feel free ask me question if any. I Look forward to hearing from you. Have a nice day and stay fine:-) Best Regards Maariyaa
$34 USD em 1 dia
4,8 (142 avaliações)
6,2
6,2
Avatar do Usuário
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 260 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$50 USD em 3 dias
4,9 (79 avaliações)
5,9
5,9
Avatar do Usuário
Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, MOHIUDDIN.
$15 USD em 1 dia
4,8 (83 avaliações)
5,9
5,9
Avatar do Usuário
Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$35 USD em 2 dias
4,9 (57 avaliações)
5,6
5,6
Avatar do Usuário
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$13 USD em 0 dia
5,0 (107 avaliações)
5,5
5,5
Avatar do Usuário
A proposal has not yet been provided
$24 USD em 1 dia
4,6 (97 avaliações)
6,0
6,0
Avatar do Usuário
Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on projects.
$25 USD em 3 dias
5,0 (28 avaliações)
4,7
4,7
Avatar do Usuário
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy
$20 USD em 1 dia
5,0 (47 avaliações)
4,4
4,4
Avatar do Usuário
Hi, I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am an experienced MS Office, VBA, Graphic Designing, PDF and Data Entry expert. Your kind response is being awaited.
$24 USD em 1 dia
4,9 (25 avaliações)
4,4
4,4
Avatar do Usuário
Have a great day! Excel automation is my masterpiece. Pleasure if you choose me to work with your project. Feel free to message me with your actual data. Thank you.
$30 USD em 1 dia
4,9 (23 avaliações)
4,0
4,0
Avatar do Usuário
Available now to contact (Chat/PM) and start the project. Also please do look at my portfolio for my past work and 100% satisfied reviews from earlier projects ***SPECIAL NOTE*** - Quickest delivery time than anyone who will bid. You can be rest assured the quality of the project will be top class and will be delivered as per the timeliness. Also I will be available for any modifications which you require during the project.
$13 USD em 1 dia
4,7 (38 avaliações)
4,3
4,3
Avatar do Usuário
A proposal has not yet been provided
$15 USD em 1 dia
5,0 (13 avaliações)
3,4
3,4
Avatar do Usuário
Hi, my name is Daniel, i am an excel expert and vb programmer, i am sure i can do this work just in a coupple of hours.
$20 USD em 0 dia
5,0 (5 avaliações)
3,3
3,3
Avatar do Usuário
Hello. I would like to work on your project, as I see the "-" issue come from the fact that the code are trying to evaluate a formula in Book 2 F4 trying to get result from Book1 computing G11+H11*7. this issue can be easily jumped out making the code to put "-" or zero or nothing in these case, as you like. Regarding the second task I would like to ask if in Book1 sheet2 column C , I mean the value near room number, will it takes always the value 1? I hope You will select me for this job. Thank you. Regards
$15 USD em 1 dia
5,0 (17 avaliações)
3,1
3,1
Avatar do Usuário
$10 USD em 1 dia
5,0 (3 avaliações)
2,4
2,4
Avatar do Usuário
Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. Good luck and succeed in this project.
$20 USD em 3 dias
4,5 (3 avaliações)
2,3
2,3
Avatar do Usuário
Hello Ok so I fixed 1) and 2). Now it copies the data corectly in the table adding rows every time it is needed. I also wrote the add and delete code. The size of the table in sheet 2 is also adjustable. If you want I can send you the file so you can check it. If you like it we can talk about any adjustments it might need. Don't hesitate to contact me. Thanks, Michael
$20 USD em 1 dia
5,0 (2 avaliações)
1,3
1,3

Sobre o cliente

Bandeira do(a) UNITED STATES
Garland, United States
5,0
2
Método de pagamento verificado
Membro desde dez. 17, 2015

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.