Create and Excel workbook/worksheet change log -- 2

Imekamilika Ilichapishwa Mwaka 1 uliopita Kulipwa wakati wa kujifungua

$30-250 AUD

Kulipwa wakati wa kujifungua

Imekamilika Kulipwa wakati wa kujifungua

I have an excel that I want to have a live change log file created and stored in a separate file.

The log should submit on only particular column edits like C:C, J:J, K:K

When a change is made to any of the columns on the worksheet a record should be created for the entire row in a separate workbook. The Changelog workbook will be closed and be being used for Power BI reporting on entries from the file.

I did have a working script that created a log into the existing workbook on a new sheet. But this recently stopped and I am not sure why as I changed nothing.

Script running was, issue is it stopped running on the row "[login to view URL]([login to view URL]).Copy .Cells(Rw, 1)" this morning for some reason and 2nd main issue is I need it to create the log into a closed separate workbook.

Private Sub Worksheet_Change(ByVal Target As Range)

Dim dtmTime As Date

Dim Rw As Long

If Intersect(Target, Range("C:C,J:J,K:K")) Is Nothing Then Exit Sub

dtmTime=Now()

With [login to view URL]("LOGS")

Rw= .Cell(.[login to view URL], 1).End(x1Up).Row + 1

[login to view URL]([login to view URL]).Copy .Cells(Rw, 1)

.Cells(Rw, 21)=dtmTime

End WIth

End Sub

.NET Kuprogramu ukitumia C# Kutengeneza Data Excel Visual Basic

Kitambulisho cha Mradi: #35651368

Kuhusu mradi

15 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

Imetuzwa kwa:

Picha ya Profaili ya utrathore3
utrathore3

(Maoni 211)
7.4

15 wafanyakazi huru wanazabuni wastani wa $121 kwa kazi hii

Picha ya Profaili ya worksoft
worksoft

Hi, I am an experienced .net developer. I can fix this. I can also change it to create separate log file. Thank you.

$140 AUD kwa siku 7
(Maoni 10)
4.2
Picha ya Profaili ya judibest4405
judibest4405

I am an experienced data entry specialist with a demonstrated history of delivering high quality in a timely manner. I hope to be considered for an opportunity to grow my skills and help your company with your data ent Zaidi

$140 AUD kwa siku 7
(Maoni 0)
0.0
Picha ya Profaili ya scriptwriterx
scriptwriterx

Hi there I have read your project discription and I'm confident I can do this project for you perfectly . I still have few questions , come inbox for further details . Thankyou

$30 AUD kwa siku 2
(Maoni 2)
0.1
Picha ya Profaili ya wilsonpalacios23
wilsonpalacios23

Hello I have seen your project and I am interested in working with you on this project. I have extraordinary skills related to Microsoft office and translating texts. Contact me and we'll talk about your project

$140 AUD kwa siku 7
(Maoni 0)
0.0
Picha ya Profaili ya fsbasil
fsbasil

Dear, As a highly experienced freelancer with a strong background in Excel programming and VBA, I am excited to submit my proposal for the opportunity to create a live change log file for your Excel workbook. I under Zaidi

$80 AUD kwa siku 1
(Maoni 0)
0.0
Picha ya Profaili ya devitra123
devitra123

Hello, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I have more than 16 years of experience and have completed 100+ projects. I can achieve the resul Zaidi

$100 AUD kwa siku 3
(Maoni 1)
0.0
Picha ya Profaili ya basirulamin
basirulamin

Hello, I'm able to do the job. I have previous work experience samples proofs and buyer feedback. I'm ready to help you. I'm waiting for your response.

$140 AUD kwa siku 7
(Maoni 0)
0.0
Picha ya Profaili ya imamtopet
imamtopet

Hello sir/madam I have checked your project description, I can repair your excel files . I have 7+ years of expertise in Excel/VBA, SQL, Power BI, Tableau creating complex automation tools, formulas, databases, queries Zaidi

$200 AUD kwa siku 7
(Maoni 0)
0.0
Picha ya Profaili ya abusyeed845
abusyeed845

Thank you for inviting me to apply for this job. I am a very hard worker who’s in serious need of a job. I’ve been going through some difficult times and I am willing to do anything to get this position. I am willing Zaidi

$140 AUD kwa siku 7
(Maoni 0)
0.0
Picha ya Profaili ya armankhan0012001
armankhan0012001

I am Arman Khan, One of the top-rated & preferred freelancers for Data Entry & Web Scraping I am available 24x7 via Freelancer.com Mobile Apps. Please never hesitate to ping me anytime. I am an expert in Data Entry, Zaidi

$140 AUD kwa siku 7
(Maoni 0)
0.0
Picha ya Profaili ya rajputboyrajput1
rajputboyrajput1

Hy i see your work details and I'm experience date entry operator with 4 year experience in the date entry industry.i am complite lot of work in date entry in the past.i will done your work within 6 hour and i give m Zaidi

$30 AUD kwa siku 1
(Maoni 1)
0.0
Tuma Mradi Kama huu