VB I am trying to insert date for a new entry and to show a date for any updates in another cell.

$10-20 USD

Ολοκληρώθηκε

Αναρτήθηκε

6 μήνες πριν

$10-20 USD

Πληρωμή κατά την παράδοση

I am trying to insert date for a new entry and to show a date for any updates in another cell. I have a VBA code but it will not run in the spreadsheet. New entries shall place the entry date in column L (DateEntered) and Column M (DateUpdated). Any future updates shall put Updated Date in the DateUpdated cell. Private Sub Worksheet_Change(ByVal Target As Range) ' Code to put the date of the latest update following a change Dim myTableRange As Range Dim myDateTimeRange As Range Dim myUpdatedRange As Range Set myTableRange = Range("A2:K20") If Intersect(Target, myTableRange) Is Nothing Then Exit Sub Set myDateTimeRange = Range("L" & [login to view URL]) Set myUpdatedRange = Range("M" & [login to view URL]) If [login to view URL] = "" Then [login to view URL] = Now End If [login to view URL] = Now End Sub

Excel

Visual Basic

Visual Basic for Apps

VB.NET

Data Processing

Ταυτότητα εργασίας: 37495474

Σχετικά με την εργασία

10 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 6 μήνες πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

Βραβεύτηκε στον/στην:

@Ahsan2526

$0 USD σε 1 ημέρα

4,9

(144 αξιολογήσεις)

6,0

10 freelancers δίνουν μια μέση προσφορά $21 USD για αυτή τη δουλειά

@akritisood94

Hello there! My name is Akriti and I'm a Google Sheets Guru with extensive experience in Excel VBA and data processing. I understand that you're trying to insert date for a new entry and to show a date for any updates in another cell, but your code won't run in the spreadsheet. With my expertise in Google Sheets, I can provide the necessary tools to ensure efficient data management. I have the perfect solution for you - use my expertise to automate repetitive tasks while maximizing productivity, or design visually stunning websites using HTML, CSS, JavaScript, PHP and Python. My commitment to client satisfaction focuses on delivering projects on time and within budget so you can relax and enjoy the results without worrying about logistics. I'd love to hear more about your project and discuss how we can create something extraordinary together! Please don't hesitate to contact me if there's anything you'd like to discuss further or if you have any other questions.

$20 USD σε 1 ημέρα

4,9

(396 αξιολογήσεις)

7,5

@writingapp

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within some hours

$20 USD σε 1 ημέρα

5,0

(302 αξιολογήσεις)

7,0

@arunkumar9896

Hi Hope you are doing good! I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun

$25 USD σε 1 ημέρα

5,0

(38 αξιολογήσεις)

5,6

@hemsingh1

Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project. https://www.freelancer.com/projects/excel/Excel-VBA-Data-Entry-Analysis-32285292/reviews https://www.freelancer.com/projects/excel/Data-Analytics-Project-30073140/details https://www.freelancer.com/projects/data-mining/DATA-MINING-ANALYSIS-USING-NEURAL/reviews https://www.freelancer.com/projects/excel/Hire-Excel-Expert-15193739 I would love to discuss the project further :).

$20 USD σε 1 ημέρα

5,0

(21 αξιολογήσεις)

4,3

@atifkhaninfotech

Hello, I am Atif Ali Khan and I am a creative director at a reputable advertising agency with over 6 years of freelance design experience. I understand that you are looking for a person to help you insert date for a new entry and to show a date for any updates in another cell. With my extensive experience in data processing, I can ensure that your entries are placed in the correct columns without any errors while future updates will be placed in the Updated Date cell instead of leaving it blank. I believe that my skillset is ideally suited to complete this project perfectly. My expertise spans logo design, comprehensive branding, intricate illustations, striking icon designs, captivating poster art and expressive digital painting among other things. Additionally I am well-versed in making sure each element tells your brand's story in an inspiring way.

$15 USD σε 1 ημέρα

5,0

(2 αξιολογήσεις)

2,5

@msecon

Hello, After reviewing your requirement, I noticed that you are looking for a senior web scraping expert. I have read your job carefully and feel confident to deliver a perfect solution for you. Your idea is clear and attractive for me. I have 7+ years of experiences in building this kind of project. I will skip my skills and working history because you can see on my profile. Let’s discuss more in details over the chat. Looking forward to hearing from you. Regards

$50 USD σε 3 ημέρες

5,0

(1 αξιολόγηση)

0,0

@kbarbarius

Hello, Statistics, Web Scraping and Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced professional with years of experience in all the data analysis tools including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Scrapy, Tableau Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.

$18 USD σε 1 ημέρα