i really need help please - VBA
Project details
I am working with a large excel database in which i am logging the status and training for our volunteers. We have a column where we choose the status of the volunteer, in this case i want the word “Leaver” to cause the whole row to copy and paste onto a different sheet. With the attachments this would be the change of status from sheet “BEF” to “BEF Leavers” i have managed to do it previously but it always deleted the current data on the leavers sheet, i wish for it to copy to the row underneath. I know it’s possible but i constantly hit an error with it and a DEBUG message which is making me go mad and it’s not something i am confident with in excel.
I would like it to be a macro button but that seems to be so far off being possible at the moment so am more than happy with it being a run script.
Awarded to:
Rohit A.
(4.9)
Project budget: £20 GBP
budget limits: £10-20 GBP
number of bids: 24
average bids: £19
Awarded to:
Rohit A.
(4.9)
Project budget: £20 GBP
budget limits: £10-20 GBP
number of bids: 24
average bids: £19
Project details
I am working with a large excel database in which i am logging the status and training for our volunteers. We have a column where we choose the status of the volunteer, in this case i want the word “Leaver” to cause the whole row to copy and paste onto a different sheet. With the attachments this would be the change of status from sheet “BEF” to “BEF Leavers” i have managed to do it previously but it always deleted the current data on the leavers sheet, i wish for it to copy to the row underneath. I know it’s possible but i constantly hit an error with it and a DEBUG message which is making me go mad and it’s not something i am confident with in excel.
I would like it to be a macro button but that seems to be so far off being possible at the moment so am more than happy with it being a run script.
I would like it to be a macro button but that seems to be so far off being possible at the moment so am more than happy with it being a run script.
Skills: Data ProcessingExcelVB.NETVisual BasicVisual Basic for Apps
skills of Rohit A.
| skill ? | level ? | projects ? | ||
|---|---|---|---|---|
| Backtesting |
|
50 | ||
| Balustrading |
|
50 | ||
| MetaTrader 4 |
|
50 | ||
| Metatrader 5 |
|
50 | ||
| Pine Script |
|
99 | ||
| Data Analytics |
|
50 | ||
| Data Visualization |
|
1 | ||
| Data Warehousing |
|
1 | ||
| Software Development |
|
50 | ||
| Excel |
|
447 | ||
| Web Scraping |
|
199 | ||
| Software Architecture |
|
298 | ||
| Data Processing |
|
248 | ||
| HTML5 |
|
99 | ||
| Visual Basic for Apps |
|
50 | ||
| Data Science |
|
1 | ||
| Metatrader |
|
99 | ||
| Typescript |
|
50 | ||
| Data Analysis |
|
1 | ||
| Coding |
|
50 | ||
| Scripting |
|
50 | ||
| Visual Basic |
|
149 | ||
| PC Programming |
|
1 | ||
| Data Mining |
|
50 | ||
| Trading |
|
50 | ||
| Javascript ES6 |
|
1 | ||
| JavaScript |
|
199 | ||
| XHTML |
|
1 | ||
| JavaFX |
|
50 | ||
| ES8 Javascript |
|
1 | ||
| VB.NET |
|
50 | ||
| Windows Desktop |
|
50 | ||
| Java |
|
99 | ||
| Python |
|
99 | ||
| HTML |
|
199 | ||
| PHP |
|
248 | ||
| Data Entry |
|
149 | ||
| MySQL |
|
50 | ||
| C# Programming |
|
149 | ||
| .NET |
|
50 | ||
| Website Design |
|
50 | ||
| Programming |
|
1 | ||
| App Development |
|
1 | ||
| Web Development |
|
1 | ||
| Website Build |
|
1 | ||
| Landing Pages |
|
1 | ||
Some Rohit A. projects
| Project Title | Skills required in the project |
|---|---|
| Excel Advanced Formula Help | Data Entry Data Processing Excel Visual Basic |
| write vba code to attach strings, or formula | Excel Visual Basic |
| I need pine script developer | C# Programming JavaScript Metatrader PHP Software Architecture |
| web data mining | Copy Typing Data Entry Data Processing Excel Web Search |
| Need CSV file of all wikipedia article titles | Data Processing Web Scraping Web Search |
| Fill in methods in c# for already created stored procedures | C# Programming Software Architecture SQL |
| [login to view URL] diagram set up | CSS HTML HTML5 JavaScript jQuery / Prototype |
| [login to view URL] diagram set up | CSS HTML HTML5 JavaScript jQuery / Prototype |
| Do some Excel Work | Data Entry Data Processing Excel |
| Fix my excel spread sheet | Excel Visual Basic |
| GOOGLE SHEETS FORMULA | Data Entry Excel Google Sheets |
| Create 35 online calculators from an existing .html file | Engineering HTML JavaScript Mathematics |
| Download images from website | Web Crawling Web Development Web Scraping Web Services |
| wordpress slighlty changes | CSS HTML PHP Website Design WordPress |
| Dynamic Color Changing Blocks | CSS HTML JavaScript PHP Website Design |
| Resolve a small glitch on webpage | CSS HTML JavaScript PHP Website Design |
| Resolve a small glitch on webpage | CSS HTML JavaScript PHP Website Design |
| Make a small change (javascript/html) | CSS HTML HTML5 JavaScript jQuery / Prototype |
| MySQL Whitespace removal | MySQL SQL |
| Find Information from Websites | Data Entry Excel Web Scraping Web Search |
| Create Excel Program | Data Entry Data Processing Excel Software Architecture Visual Basic |
| Find correct Microsoft Excel logic: Create single drag down formula for summing cumulative total by country | Data Entry Data Processing Excel Microsoft Visual Basic |
| JAVA Updates | Java JavaFX JavaScript PHP Software Architecture |
| Excel Formula Help! | Excel |
| data spreadsheet | Data Entry Data Processing Excel Web Scraping Web Search |
| Save pictures from the web | Data Entry Data Processing Excel Web Scraping Web Search |
| Need to do grammar correction and summarize English article | Data Entry Drafting English (UK) Translator English (US) Translator English Grammar |
| Write a multiple search and replace macro | Perl PHP |
| HTML right justify text questions | Apache CSS HTML Linux Ubuntu |
| from customer cells to letter cells | Data Entry Data Processing Excel Excel Macros Visual Basic |
| Clean up Excel sheet (very simple) | Data Entry Data Processing Database Administration Excel Microsoft Office |
| I need a file text/software or whatever that could replace 20datas in a text | PHP Software Architecture |
| modifications in the website | Website Design WordPress |
| Write some Software | PHP |
| Create a live updating line-chart with multiple lines and pagination from given API | Charts JavaScript JSON |
| PHP script that reads an XML file and outputs a filtered version | PHP XML |
| Basic Statistics & Probability | Algorithm Mathematics Python Statistical Analysis Statistics |
| Excel Support 2 | Data Entry Data Processing Excel Microsoft Office Visual Basic |
| java algorithms implementation | Algorithm J2EE Java JavaScript OpenGL |
| Convert multi sheet xslx to single sheet csv | Data Entry Data Processing Excel Software Architecture Visual Basic |
| Create a youtube playlist | YouTube |
| Build me a batch program / application | HTML Java MySQL PHP Software Architecture |
| Change Background Image in Custom Theme | CSS HTML PHP Website Design WordPress |
| Excel delete duplications and sort list with formula | Data Entry Data Processing Excel |
| Colors change on website | CSS Graphic Design HTML PHP Website Design |
| Basic javascript | CSS HTML HTML5 JavaScript jQuery / Prototype |
| Remove duplicates | Data Entry Data Mining Excel Excel Macros Excel VBA |
| Writing addresses in an Excel file [Urgent] | Data Entry Data Mining Data Processing Excel Web Search |
| Cleaning my EXCEL FILE | Data Entry Data Processing Excel Microsoft Office Word |
| Adding categories to users | Data Entry Excel |
| Coding for pine editor in tradingview | Backtesting Balustrading Coding Metatrader MetaTrader 4 Metatrader 5 Pine Script Trading |
| Need 2022 stock data. | Data Analytics Data Mining Web Scraping |
| Combine 3 Tradingview indicators | Metatrader Pine Script Python |
| Custom Scrapes – Ongoing Work | C# Programming Data Processing Excel Web Scraping |
| Scrape App | Software Architecture Software Development Web Scraping Windows Desktop |
| Scrape a FLASH website | .NET C# Programming Excel PHP Web Scraping |
| Need 2 small coding exercises completed | C# Programming Software Architecture |
| EXCEL DATA CLASSIFICATION – 28/04/2018 16:12 EDT | Data Entry Data Processing Excel |
| Java program — 2 | Java |
| TypeScript/Javascript. Convert an object with key value pairs to another object of different form | JavaScript Typescript |
| i really need help please – VBA | Data Processing Excel VB.NET Visual Basic Visual Basic for Apps |
| php developer to work on php application folder system | HTML MySQL PHP Software Architecture Website Design |
| Excel work project 1st | Data Processing Excel Software Architecture |
| Check for duplicates in two excel files. | Excel |
| Quick excel formula | Data Entry Data Processing Excel Visual Basic |
| new quick html framework (simple instructions) 5 stars – quick pay | HTML HTML5 JavaScript Python Scripting |
| Java simple project | Java JavaFX JavaScript PHP Software Architecture |
| Highlight a row based on checkbox | HTML HTML5 JavaScript PHP Software Architecture |
| PHP page to fill PDF file with a table | HTML PHP |
| Excel Formula Horse Racing for Place | Excel Visual Basic |
