First, I have attached the spreadsheet that I am talking about. What I need to do is copy all rows from one sheet to other sheets based on the content of cells in one row. I have built the spreadsheet and right now my command button works on 10 out of 16 sheets. It's the same code but for some reason it does not work on some sheets. What I want to do is create one button that copies the rows from a sheet that has all results to the individual sheets that correspond to the data. Also, I need a button to delete all rows in a range from all sheets except for the master sheet that contains all data so that the sheets reset for the purpose of copying across new data. If I don't delete all rows then a macro copying rows will copy the same rows again plus new rows. So let me now refer directly to the spreadsheet. The first sheet, Overall Results, contains all data. At the top are all stats. Below is all data. Now look at sheet "Craig1". As you an see there is a command button and when clicked it copies all rows from "Overall Results" starting at row 16 column B where the cell in column B = "Craig1" This works fine. Sheet Craig2 has the same thing. Same code just modified to refer to Craig2. For some reason though it won't work for sheet "Craig7" for example. What I really want to do though is create just one command button that deletes all data in a range of cells of all sheets EXCEPT for sheet "Overall Sessions". Then I want one command button that brings copies all rows from Overall Sessions to all sheets whose name corresponds with the text in row B of overall sheets. I know this is difficult to explain but if you look at the spreadsheet and the VBA of the command buttons you will understand. I don't want a command button on each sheet named "CraigX". I want to change it to just one command button that will copy all data from Overall Results to all sheets that correspond with the data. And as for deleting data from all sheets called "CraigX" - I want one command button to do that too. In reality this is maybe a 30 minute job for an excel expert. Please quote or message questions.
Bu iş için 73 freelancer ortalamada $363 teklif veriyor
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Contact me to discuss the details. Best regards
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have an opportunity to consult details Daha Fazla
$ 250 Only ------ In Just 12 Hours ------ Excel VBA Macro Coding, Formula Generation and Automation Process Expert with 5 Ratting ------- I can start right now, please message me to discuss more.
Hi there, I am an Australian-based software developer and completely understand your requirement. I have done projects like this before where I needed to sort results from testing into different groups on Sheet tabs. Daha Fazla
Hi Good Day! I am willing to help you to complete this work but I can't find any attachments. Can you message me and share to me your file so I can assess it? I've done a lot of Reports and Templates using MS Excel a Daha Fazla
Hi Good Day, I can do this immediate after you accept my bid I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and [login to view URL] give me this o Daha Fazla
Hi there, I'm working on data processing and excel programming projects from last 10 years. kindly let me know what needs to be done to secure this bid. Thanks
I have a question--Need the file with VBA coding to understand current status of the application and future prospect of the codes to meet the requirements.
Hi I have 5 years of experience working in bank as a financial analyst, dealing with VBA macros and excel template on a daily basis. I will only charge you $100 for this project. Please contact me for more information. Daha Fazla
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with Excel and VBA. It will be quick and accurate. I will start right away and complete it wi Daha Fazla
Please I will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects