473,326 Members | 2,438 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

To Do list help - to add two more columns to the current code

I am preparing a to do list in which there is Status (completed / not yet) and Task name in sheet 1. In sheet 2 (completed) the task which is marked completed is moved with the current time.
Now I need to work out on adding two more columns D (person) and E (estimated completion date) in Sheet 1. So, When I mark the task as Completed & click on button, all 3 details i.e. Task name, Person and Estimated completion date should move to Sheet 2.

For the reference, I have added the file here. Macro codes are defined.

I am unable to edit the code as per above requirement.
Any help would be greatly appreciated.
Attached Files
File Type: xls Todo List Application.xls (32.0 KB, 477 views)
Sep 28 '13 #1
1 1452
Luuk
1,047 Expert 1GB
Here you are copying the data from column B:
Expand|Select|Wrap|Line Numbers
  1.         ElseIf moveThis Then
  2.             Range("removedTodos").Offset(tmpCount + 1).Value = cell.Value
  3.             Range("removedTimes").Offset(tmpCount + 1).Value = removalTime
  4.             moveThis = False
  5.             tmpCount = tmpCount + 1
  6.         End If
You managed to write the code for this, so how difficult would it be to add two more lines which also copy the values of columns D and E ??
Sep 28 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: derek / nul | last post by:
Is there any list or array code that can load lines from a file? ie what I would like is to open a file and load line by line into a list or array. Any pointers most appreciated. Derek
1
by: michaaal | last post by:
How can I list my current cookie variables?
1
by: Steve Jorgensen | last post by:
An Access database connected to a PostgreSQL back-end. Sometimes, when I close a form, i get a message saying that the action will reset the current code in break mode. The front-end literally...
0
by: YFS DBA | last post by:
I'm getting an error message when I open queries then try to close them: "This action will reset the current code in break mode" Clicking on 'Yes' just brings up the same message. If I change...
1
by: idta | last post by:
Hi there, I have a table full of numbers. I want to delete all the columns that do not have ANY numbers in the rows under the column. I assume I could sum the column, and if the sum is 0, I know...
0
by: Yanir | last post by:
H I have to display a sortable list of columns(a table or so) - by click on the title of a column the column would be to criteria to sort by I know datagrid is very conveniant, but I want to save...
2
by: Christina N | last post by:
I want to write a (vb.net) function that outputs a list of currently active users, and an indication of how many minutes they've been inactive. I want the output to look something like this: ...
2
by: Jordan S. | last post by:
VS 2005: What is the keyboard command, if one exists, that I can use to collapse the current code region (the one in which the cursor currently resides)? Thanks
3
by: ronn2007 | last post by:
Hi, I know sys.tables and sys.columns gives me a list of tables and columns in a SQL 2005 database. How can I list Columns in a specific Table please? Thanks in advance, Ronny
10
by: mulamootil | last post by:
Is there a way to hide fields in a report that do not have any data. I have few fields that have images and I would like to hide them as well whenever there is none. I am using Access 07.
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.