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

Teljesítve

Kiadva ekkor:

6 hónappal ezelőtt

$10-20 USD

Teljesítéskor fizetve

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

Projektazonosító: 37495474

A projektről

10 ajánlat

Távolról teljesíthető projekt

Aktiválva: 6 hónappal ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@Ahsan2526

$0 USD 1 napon belül

4,9

(144 értékelés)

6,0

10 szabadúszó adott átlagosan $21 USD összegű árajánlatot erre a munkára

@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 napon belül

4,9

(396 értékelés)

7,5

@writingapp

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

$20 USD 1 napon belül

5,0

(302 értékelés)

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 napon belül

5,0

(38 értékelés)

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 napon belül

5,0

(21 értékelés)

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 napon belül

5,0

(2 értékelés)

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 napon belül

5,0

(1 értékelés)

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 napon belül