Hi. I want to format every other record based on a date. Multiple rows with same date should have same color. It's easier just to show what i need than to write it, so I've uploaded an excel file with the formatting that i want. So any ideas.
Thanks in advance.
Re: Vba to copy data from one sheet to another based on 2 dates.
Yesss! Thank you JINDON. Works like a charm!
Like always you saved me!
Re: Vba to copy data from one sheet to another based on 2 dates.
Yesss! Thank you JINDON! Works like a charm!
As always you saved me!
Re: Vba to copy data from one sheet to another based on 2 dates.
that's it but the macro still deletes my totals below the table (row 515) in sheet report. is it possible for the macro not to delete rows below my table?
Thank you jindon
Re: Vba to copy data from one sheet to another based on 2 dates.
That's it, but still the macro deletes the rows under the table where my totals are (under the 500 row) in sheet report. Is it possible for the macro not to delete my totals under row 500?
Thank you jindon
Re: Vba to copy data from one sheet to another based on 2 dates.
No not row 500 in sheet sold, but row 500 in my table in sheet report. It's actually row 515 in sheet report. So when i run the macro, the code does not surpass my table because at the bottom of the table i have totals and right now the code copies data over my totals.
Thanks jindon for your efforts.
Re: Vba to copy data from one sheet to another based on 2 dates.
ЈINDON YOU READ MY MIND:).
One thing though, can the code be modified to copy data until row 500 of sheet report (row 500 inside my table)?
Re: Vba to copy data from one sheet to another based on 2 dates.
Jindon you are tha bomb!!! Thanks a lot.
Like always you are my savior!
[INDENT]Hi everyone!
I'm trying to build a report for sold items based on a date range. I have 2 sheets, sheet SOLD where i keep record of what i sell, and sheet REPORT where I want to extract data from sheet SOLD based on the 2 dates that are above the table in sheet REPORT. The code should extract the corresponding columns from sheet SOLD to sheet REPORT. For example: data from column serial should be copied to column serial, data from column name should be copied to column name and so on. Also is it possible to be done without auto filter because i have very big table with lots of data and i think auto filter will slow the process.[/INDENT][INDENT]
Here's the file:forum.ozgrid.com/index.php?attachment/48378/
Thanks in advance for any help![/INDENT]
Re: Vba to extract values from one sheet to another based on 2 dates.
Hey venkat1926 thanks. Its pretty close to what I need.
I tried the test macro, and from what I can understand the macro copies all columns from sheet SOLD and then it cuts the columns that are not needed. But there is one problem with that, I need the last column (difference) in sheet REPORT, because there is a formula there in my original file that i need, so the macro should not delete that column. Also is it possible for the macro to paste the values from sheet SOLD at the exact location in sheet REPORT. I need that because the last column DIFFERENCE is the difference between the price and the price with %. Also can the macro just paste only the values, without the formatting.
Thank you so much for your efforts, maybe I didn't explained clearly enough what I need, I'm sorry for that but I'm trying my best. English is not my first language.
Re: Vba to extract values from one sheet to another base on 2 dates.
Thanks for your reply venkat1926. The relevant dates are in are in sheet REPORT located above the table in sheet REPORT. The date in A1 in sheet SOLD is today's date, I forgot to delete it before posting it. About row 7, its not hidden its just smaller.
I don't understand what you mean by cosmetic changes, if by that you mean the color fill on the cells and the formatting then I'm sorry I didn't know that. I've posted this same file before and nobody told me that.
Hi everyone!
I'm trying to build a report for sold items based on a date range. I have 2 sheets, sheet SOLD where i keep record of what i sell, and sheet REPORT where I want to extract values from sheet SOLD based on 2 dates that are above the table in sheet REPORT. The code should extract the corresponding columns from sheet SOLD to sheet REPORT.
Here's the file:forum.ozgrid.com/index.php?attachment/45963/
Thanks in advance for any help!
Re: Vba to copy entries from one sheet to another based on 2 dates
I didn't meant to upset anyone, It's just that I'm used to very fast replies in this forum. Sorry for the inconvenience.
The solution that I have is a formula to dynamically extract records from sheet sold to sheet report. But as I make more sales the table gets bigger and excel gets to the point that i have to wait for 20 minutes just to make a report. That's why I need a VBA solution for this.
Any help would be very much appreciated.
Thanks.
Re: Vba to copy entries from one sheet to another based on 2 dates
Anyone?
Hi. I need to copy entries from sheet sold to sheet report based on two dates located in sheet report. The thing is I need to copy the corresponding cells in sheet sold to the corresponding cells in sheet report. This is for my sales report. Here's the file. forum.ozgrid.com/index.php?attachment/45083/
Thanks in advance for any help!
Re: Update a cell when year ends
Hmm. Very interesting! Thanks for the help. I'll try to adapt this to my original workbook since my original workbook is more complex than the example. I'll write here if I need any help, but I think this will do the job. THANKS A LOT MAN!
Re: Update a cell when year ends
forum.ozgrid.com/index.php?attachment/44897/ here's the example. So in my invoice list i have all invoice so far. the invoice number is generated by a formula. so the problem is how to make the invoice number in sheet invoice reset to 1 when the year changes.
Re: Update a cell when year ends
JPROFFER thanks for the response but I just cant understand what to do with this formula. Could you please explain it to me.
HI. I need a code to change cell value when year starts. Its for my invoice number. For example: for the year 2012 I start with invoice number 1 and i'm making invoices 2,3,4..., but when the year ends I want the number of the invoice to start from 1 for the next year. Any ideas?
Thanks.
Re: Copy cells from one table to another based on the value in the second column!
Jindon THANK YOU SO MUCH FOR A 1000000 times! It's perfect! You are THE BEST!!!
