Excel Vba copy same date to list of entries
Hi,
I am copying a list of cell entries from invoice to ledger using vba. All the copied entries must have the same date as copied from the invoice sheet to the ledger sheet.
the next time the button is clicked, it should copy to the next empty rows. Please help me with this. I cannot seem to get the date which is one cell, to be copied against all the entries and to the next empty rows thereafter.
Thank you
Truly,
Aneela
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Please find the files attached.
Also for the ledger(Final Sheet), I want it to print statement for a user input period, say 1Jan 2014 to 1 Jan 2015 or randomly such as 12 April 2015 to 12 May 2015. Please help on that also.
Thank you
Truly,
Aneela
@aneela
Welcome to the forum but please read our rules.
You should not be using the Private Message facility in the way you have. That's not what it's for.
See rule 4
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Sorry @Richard Buttery. Please help someone. Its is urgent.
Try this.
Please Login or Register to view this content.
Hi skywriter,
No this does not work. the two files need to be separate. The button does not work on my pc.
Thank you
Regards,
Aneela
please consider this file as the file output. I am sorry.
please once again sorry. this is the file that is the final result. with entries for a given date with the specific date. the next time data is entered, it shifts to the next empty rows.
Also print this sheet for specific user defined periods as in bank statements for example 01 july 2014 to 1 dec 2014 or 1 march 2015 to 1 April 2015.
Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
http://ccm.net/forum/affich-857645-c...ates-to-ledger
http://stackoverflow.com/questions/3...ist-of-entries
http://www.excelguru.ca/forums/showt...ist-of-entries
http://www.mrexcel.com/forum/excel-q...t-entries.html
Aneela1,
When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now. We all follow these rules for the benefit of all, as must you. Thanks.
(link above in the menu bar)
As you have received an initial suggestion, we will not delete this thread. Due to the numerous crossposting of this question around the internet, I am opting to close this thread as I do not want to waste any of our helper's time on questions being worked on elsewhere.
Thanks for understanding, in general we prefer you respect our people's free time and not risk wasting it in this manner in the future.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks