Search results

I have a spreadsheet that has 16 columns of basic data (names, addresses, total rent, etc) and i need to change to a spreadsheet with one column of the data that is a string of comma delimited data. i have to save as text then and upload to a program. Is there a way to combine the columns...

i fixed a mini set with dummy data but I think it will be enough for you to see what i want to do. The data goes to the new pages and starts on row 11 like I need it to however as mentioned it would be nice if I could somehow get them to the template or if I could add the template after the...

This works great. Thank you so much. I have another question that you might can help me with if you don't mind. The first 10 rows on these worksheets are basically a template that does vlookups to fill in manager name, regional, etc. There are 130 worksheets and if there was a quick way to...

I tried it however I am getting an error message: run time error 9 subscript is out of range it occurs at this line Set src = Sheets("Sheet1") What am I doing wrong? Thank you for your help.

I have a workbook that contains employee listing by property. I have values in columns A through W and every time the value in column A changes i need all the rows for the code in column A to go to a new worksheet. I will end up with 130 worksheets, one for each property. The value in column...

I am setting up a workbook that will have 130 worksheets when finished plus a couple with master data. I would like to set up one template and have one cell contain the property code which is just a 5 digit number. I would like to use vba or something to automaically create the other 129...

Thank you Bob. Something so simple was causing me a lot of frustation. This worked. I really appreciate your help. Wanda

I have an excel file that has many columns. I have to upload charges to our software program using a csv file. The file uses the apartment number as one of the fields to match when it records my charges. Many apartment numbers have a leading zero and when I save the file as csv the zeros go...

I missed these when I searched for help. These are great. Thank you so much Hui for responding to me.

I have attached a snipet (the spreadsheets will range from 300 rows to 3500 rows) from a spreadsheet that I need to have vba code in a macro that will perform the formulas in the highlighted cells. It will need to insert the three blank columns, run the formulas, highlight the columns and also...

I have a worksheet with over 2,700 lines that lists data for different properties (property meaning apartment community). It is sorted in order by property name. I need to extract data for each property to a new worksheet everytime the property name changes. I will end up with 125 (that is...

Thank you. I accidentially posted too soon on this one and then did an edit. I found some of the posts on finding duplicates however the sentence I left out on this one was that I would then like for the non matches to go to a new spreadsheet along with all of their columns to the left of the...

I have two columns of names and need to find which ones are not duplicates. There are 479 names in one and 418 in the other column and I need to find out which ones are missing in the shorter column. Thank you for any help.

Thank you. These are all helpful. I will take some reports we do, give the applicants the raw data and see what they can do. I have had applicants in the past tell me they know excel and are very proficient in it only to find out after they were hired that they really only knew basics. I...

Thank you. I will work on option 2 as that will probably tell me a lot.

I am interviewing for a Financial Analyst and I was wondering if anyone has a good excel test to make sure the applicants have the necessary excel skills. Would appreciate any suggestions. thank you

Luke, this worked perfectly. Thank you so much for your help.

This is great. Thank you so much.

I have a workbook that has 92 worksheets. The first worksheet feeds the others with data specfic to an owner group and links to their weekly report format. we then have to pdf each worksheet and email it out. Is there a way to automatically pdf each worksheet individually? we currently pdf...

Thank you, I will give that a try.

I am getting an error message when I try to run the macro. It says: Can't execute code in break mode. The third line that starts with sheets is the one it highlights in yellow. any suggestions as to what I am doing wrong? Thank you again for your help.

Thank you

I am confused about where to adjust rows. There are 88 rows. Thank you for your help.

I have a worksheet with 85 rows and I would like to create a another worksheet in that workbook for each of the names listed in column A. So I will end up with 86 worksheets in the workbook. is there a way to do this or vba code that will do it? Thank you

thank you Hui. However I apologize that I didn't fully explain my dilemma. My dates are in weekly ranges and look like this: August 27, 2012 - September 2, 2012 September 3, 2012 - September 9, 2012 September 10, 2012 - September 16, 2012 September 17, 2012 - September 23, 2012 To add to...