Закрыт

Excel Macro Required

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.

Квалификация: Excel, Visual Basic, Обработка данных, Ввод данных

Показать больше excel macro fill empty cells, excel macro data cell, excel macro export xml, data net web application excel macro, excel macro expert india, excel macro load web site, install analysis toolpak automatically excel macro, excel macro convert weight, excel macro format phone numbers, excel macro copying cell content, compare tables using excel macro, excel macro open files, excel macro work required job work, excel macro required , excel macro required in 1hr, the number in this cell is formatted as text or preceded by an apostrophe excel 2010, the number in this cell is formatted as text or preceded by an apostrophe excel 2007, excel macro merge cells with same value

О работодателе:
( 0 отзыв(-а, -ов) ) Vladivostok, Russian Federation

ID проекта: #23459679

73 фрилансеров(-а) в среднем готовы выполнить эту работу за $363

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Больше

$333 USD за 2 дней(-я)
(759 отзывов(-а))
8.5
schoudhary1553

Hello, I can help you with your project - Excel Macro Required I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several pr Больше

$350 USD за 7 дней(-я)
(366 отзывов(-а))
8.1
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application fixed. I plan to use a combination of formulas and VBA code Больше

$350 USD за 5 дней(-я)
(250 отзывов(-а))
7.5
dgled

Hi, you did not attach the file. Hello, I am a financial expert and a guru in Math, Excel, VBA, and Macro. I have considerable experience in merging files, manipulating the data in a structured database, and importing Больше

$300 USD за 7 дней(-я)
(90 отзывов(-а))
7.1
elqueabandona

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

$300 USD за 3 дней(-я)
(244 отзывов(-а))
6.9
periyannas

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.

$250 USD за 1 день
(114 отзывов(-а))
6.4
dvcontact

Hi, Would you like to see a quick demo of your project on building an Excel macro formula for your spreadsheet before you award the project? You can consider it professionally done. Rather than fill this proposal with Больше

$500 USD за 5 дней(-я)
(57 отзывов(-а))
6.5
vsprybhanu

Hi, I can develop an excel vba program to accomplish your requirements. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please messa Больше

$250 USD за 3 дней(-я)
(98 отзывов(-а))
5.7
nagybatonyi

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 Больше

$250 USD за 1 день
(63 отзывов(-а))
5.7
AnowarRatul

$ 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.

$250 USD за 1 день
(77 отзывов(-а))
5.0
Sercho56

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. Больше

$250 USD за 1 день
(16 отзывов(-а))
4.8
IgeS

Hi there, Please attached the spreadsheet thus we can check it. thank you I'll be standing by to help -reggie

$250 USD за 5 дней(-я)
(15 отзывов(-а))
4.6
paulodayto08

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 Больше

$250 USD за 1 день
(37 отзывов(-а))
4.5
ravinderkumar248

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 Больше

$250 USD за 3 дней(-я)
(18 отзывов(-а))
4.5
sdroberts

Hello I would be happy to help with your excel issue. My name is Steve, I have worked with excel/vba for over 10 years for a global financial services company. In that time I became the local lead for all excel/vba b Больше

$285 USD за 3 дней(-я)
(8 отзывов(-а))
3.9
VinayOnTask

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

$255 USD за 3 дней(-я)
(11 отзывов(-а))
4.1
merinsinha

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.

$300 USD за 1 день
(15 отзывов(-а))
3.6
yhleow

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. Больше

$250 USD за 1 день
(10 отзывов(-а))
3.7
MonisZafar

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 Больше

$250 USD за 1 день
(10 отзывов(-а))
3.8
dataEntryExperty

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

$250 USD за 1 день
(17 отзывов(-а))
3.3