Posts by ucanad1yn

I have attached my excel sheet. I will will have endless rows, but right now my example shows 9 rows with columns A -K so for example, if row 3 column K in the "2013" worksheet has complete then it will move it over to the "completed" sheet but now that column 3 will be blank and I want the next cell with all the values to move up and so forth. I hope this makes sense.

i currently have a macro set up that everytime I enter "complete" in column K then it will move that row to the completed sheet and so on. But I don't know how to have it so that when that row is removed then the next row automatically moves up.

Re: Macro set to move completed cell to new worksheet now need to delete empty cells

I entered that code in a new module and I get "compile error: invalid outside procedure" message.

Re: Macro set to move completed cell to new worksheet now need to delete empty cells

I have attached my excel sheet. I will have possibly endless rows, right now my example shows 9 rows with columns A -K so for example if row 3 column K in the "2013" worksheet has complete then it will move it over to the "completed" sheet but now that column 3 will be blank and I want the next cell with all the values to move up and so forth. I hope this makes sense.

Re: Macro set to move completed cell to new worksheet now need to delete empty cells

Hi! Thank you! I'm fairly new with macros and excell and learning. Do I insert this macro in a new module or where my existing macro is?

Hi,

Please help! I have an excel spreadsheet with two worksheets title "2013" which is any pending work and "completed" sheet. My xcel sheets are exactly the same with A thru K columns. I currently have a macro set that if anything in column K says "complete" then it removes that entire row A-K to the completed sheet; however now my 2013 sheet where I originally have pending work has an empty cell and I don't know how to automatically move the empty cell up by one.

I'm attaching my xcel log so you can see.

Re: Need to retrieve multiple excel sheets into one based on due dates

I still need help. Please help!

Re: Need to retrieve multiple excel sheets into one based on due dates

Quote from ucanad1yn;599750

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Okay, thank you so so so much! I hope that you find a simpler way. Maybe my format is just too complicated. I will keep an eye out for your response.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hi!!
Any luck? I hope you found something easier.

Re: Need to retrieve multiple excel sheets into one based on due dates

Quote from vwankerl;599740

I will play around with it some and see if I can give you a solution. It may take a few days though. I am currently doing something like this on a couple other workbooks I have designed for my business so I see no problems, just details to work out.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Okay, thank you so so so much! I hope that you find a simpler way. Maybe my format is just too complicated. I will keep an eye out for your response.

Re: Need to retrieve multiple excel sheets into one based on due dates

Quote from vwankerl;599714

I have downloaded the workbooks you posted. I have a couple of questions for clarification.

1. Is there any problem using VBA to do this? I don't think there is any way to solve this without VBA.

2. You say you want to see the information on those reporters that have due notes on one sheet. Can that one sheet be the "Court Reporters" sheet?

3. Is it possible for a single reporter to have more than one due at a time?

4. What information do you want to see from the sheets that are due?

Display More

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1.) I don't think there would be problem using VBA but I don't know how to do that. I would like to use it if it's easier.
2.) I think so as long as it shows what is due for each reporter.
3.) Yes, it is possible to have multiple due dates at one time for each reporter. For example, a reporter can have different cases and all be due at the same time.
4.) I would like to see the due date for that specific reporter, case name, case number and hearing dates.

Hello,

I'm losing my mind. Please help. I have multiple sheets, each sheet contains the name of the Court Reporter with their due dates for transcripts. Sheet One is title Court Reporter just making it easier for me to click on their name and it will take me directly to their sheet.
So when a DUE DATE has approached it will highlight in RED but I also want it to be automatically be moved when it comes due to one sheet. I have 30 sheets and if 5 out of those Court Reporter's have dues then I want to be able to see it in one sheet opposed to clicking on each reporter to see what they have due. I hope this makes sense. I am attaching my WORKBOOK.

I want to be able to see what is due for each reporter on one sheet when it COMES DUE opposed to clicking on each sheet. HELP!
Is there a code for this?

I have a workbook that has 4 sheets. What I would like to do is that every time the word "completed" is entered in column, the entire row will be automatically removed and moved to sheet titled "Completed." What I have been doing now is cutting and pasting the rows manually and I want to avoid doing that.

Here is some information....
I have a sheet called "Appeals-Updated" that has columns from A thru M....so when I enter "completed" on column M the entire row with entered information will be moved.