Hi, I recently started learning VBA and need some help with some code. I have around 16 columns of data, that needs to be filled in with a help of a User Form. I came so far that I have created the userform and can fill out all rows correctly, so I have coe for that. However for some of the columns I would like to have a combobox instead of a textbox
Hello, I am looking for a Excel VBA specialist who can help me with a project. I want to have certain macros work from the first time I open a workbook until about 2 days. Depending on the total listed in sheet1 Column E will determine how long to extend the macro. For example if after the 2 days the total is 1 then it would work for 1 month from
I need an excel vba expert to write a code to automate data extraction from one excel workbook to another based on two input boxes where they have to put what they are searching for then the code extracts the matching information from the second workbook to the first workbook
...written that will read GRV June 2018 file. There is a tab in the GRv June 2018 file called Weekly Floats. This contains around 4 different tests conducted on different dates. I need the code to copy the data from each test to the appropriate columns in the FSHT. This code needs to be able to work if the GRVN June 2018 file is changed. It also needs to work
Hi, I am interested in having a google sheet created that feeds all information from masternodes.online. Would like to have it so I can click a button and the sheet updates. Would also like to have it sort-able and searchable. Would like to include all information from the pages not just the initial home feed. GOOGLE SHEETS
...Google Sheet that's shared with multiple people. I need it to be protected in a way that the users of the sheet are able to select the value from a dropdown cell in 1 row. Apart from that, the user should not be able to perform any other write operations on the sheet. I also need the filter (and not filter views) to work on the protected sheet.
We need all our supplier data sheet and cad files that has their name on it to be switched with our logo instead.
Hi, I am looking for an excel expert who can create VBA codes to disable developer tabs and copying of excel document to another computer. Must also encrypt VBA codes and VBA password. To discuss further, please bid and lets chat.
Data Entry, Excel, Web Scraping, Data Mining, and Research. I am a professional musician who is looking for the contact information for 150 hype machine indexed bloggers who write articles on current pop music and artists of current pop music that are similar to the style of pop music that I create. I need a freelancer to find 150 DIFFERENT bloggers
Module required to split UK postcode (zip codes) as per attached spreadsheet. The table on left is an Access table. The yellow table on right will be the resulting query, The module needs to b run to create a query as per the yellow table. So the new row is created after each space and then at the end of the cell. Unless there is a space the group will remain together e.g. BD1-22,97-99 1 B, BB...
Have a hand me down Access file that takes a spreadsheet and uploads it to a database. now have an error and would like help resolving the error to find the specific place to add table modifiers as I am not strong in VBA. would probably take someone 10 minutes to figure out who is good with VBA.
I'm looking for someone who has the ability to design and drawing a product spec sheets. I have all the information available and ready to go. See attached picture to give you some idea what the specification is. I'm happy for you to come up with your own design and we can finalise and continue on with balance of spec sheets. Look forward to working with you.
We have reports on google sheets, we need to simplify our reports. You must download reports from quickbooks (example of data- Transactions) on a daily basis and fetch data with formulas to the production report. I have a long video to make more sense. [login to view URL]
An Excel spreadsheet on an iphone is being further developed and assistance with coding for two columns is requested. IMPORTANT: Due to the limitations of Excel running on an Apple Iphone environment no VBA code can be used. The two columns to be coded draw on the surrounding columns to decide what data populates each cell.
Need create a excel file with two sheets, the fisrst sheet with organizational info (Name, Department, Manager) and in this sheet create a button to call the VBA to create a new sheet with Smartart organization chart populated.