Excel Tracker w/ Listboxes and Userforms

Slutfört Publicerat 5 år sedan Betalades vid leverans
Slutfört Betalades vid leverans

I'm building an interactive excel tracker for [login to view URL] is movement based on day count and selection from Listboxes. Most of the code is done on this workbook, but I am self taught and need some assistance with the more advanced code.

1. Initially I set Column A on the Status tab to equal column A of another sheet. Now, I need Column A on the Status tab to generate values (names) from Column A of multiple sheets (all the Pending MR sheets). Need help writing a code that will pull values from Column A of those sheets and put them in Column A of the Status sheet in the next available line while maintaining the header.

2. Also on the Status tab, there is an update button that populates a userform. The userform tracks 4 stages in a process. When a record is selected and the then the button for “initial evaluation complete” is selected, I want the program to cut the record of the MR selected from one of the 3 Pending MR sheets and paste it to the completed tab.

3. On the RAU Matrix tab, there is a button “Deal MR” that populates a userform. The userform has a listbox that allows you to select a RAU to send an email to. There is another listbox2 that I want to have dynamic values. So the RAU in listbox1 that is selected generates the email addresses associated in Listbox2.

4. there is code that cuts and pastes rows from pending MR tabs as day count changes. I would like that update to run automatically when the workbook is opened.

Datainmatning Databehandling Excel JavaScript Visual Basic

Projekt-id: #18368188

About the project

6 offerter Distansprojekt Aktivt 5 år sedan

Tilldelades:

Mokshith30

Hi I am Mokshith Expertised in Web Scraping & VBA Macros.. i can do any excel automation tasks, bulk email handling using outlook,File Conversion i can "SCRAPE" any website either static or dynamic also.. & in ad Mer

$55 USD inom 1 dag
(40 omdömen)
4.6

6 frilansare har lagt bud på i genomsnitt $136 för det här jobbet

periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Willing to take up your project. Thank you, Regards.

$155 USD inom 3 dagar
(113 omdömen)
6.3
lightingdavid

Hello. I have good skills in Data Entry, Data Processing, Excel, Javascript, Visual Basic. I have checked your project description carefully and i can do it. I hope to work with you. Contact me please. Thank you

$140 USD inom 3 dagar
(144 omdömen)
6.2
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Mer

$155 USD inom 3 dagar
(9 omdömen)
5.3
upalalis6

I am freelance and I can do any job base on data entry. You will know me better after finish the job as requested.

$155 USD inom 3 dagar
(0 omdömen)
0.0