Recent content by Flexorion

OK. Thanks for the help.

What you posted doesn't solve the problem because I need those two rows occupied by a single item, and even with merging them, it still does not pull them in the right order because there are two rows there. If I could show you the template you would understand, but our office computers don't...

Yes, this is working well, and is surprisingly fast to format too. Thanks for the help!

I think I actually may have to make a custom template to paste the information into that can then use reference formulas to draw directly into the merged cells.

It still has the formatting issue. The reason why the cells are merged is because in the second half of the spreadsheet is a checkmark section that has to be individually highlighted by participating stores and they need to be able to highlight each section of the box, and this is how they've...

I just tried linking formulas between the two spreadsheets and then copy-pasting the formula into the other cells and letting excel automatically change the references, but it did the same thing again!

so, rather than pasting rows 1,2,3,4,5,6 it pastes 1,3,5,1,3,5

Yes, I tried all the preset pastes. When i try to paste values, say I'm trying to paste six rows of information into six rows of merges cells (12 actual rows), it keeps the merged cell format, but it pastes in the 1st, 3rd, and 5th rows twice instead of pasting in all six.

I need to copy paste information from a spreadsheet into a template. The problem is that, for content reasons, the template has merged cells, and when I go to copy paste the information into the template, rather than pasting each cell from the information into one of the merged cells, it keeps...

Never mind, that was the problem. There were self referencing macros within the macros, so I had to go through the code and everywhere in the code where the old file was mentioned I had to put in the updated file in 2010 format, so there are nomore problems now.

I think a possible problem might be that the original file I'm working from was saved in an older Excel format. But the macros I saved specifically to that notebook, and when I try to save it to Excel 2010 format, the macros are stuck in the old file and don't totally transfer over. How do I...

I'm having a problem with a very complicated macro I created that works fine while I'm using it, but then when I save and close and reopen it, an error is inserted into the code. I found the place where the error is, and I can manually go in and delete it, but I would like to know why this keeps...

Great, I'll try that. Thanks!

You guys were so helpful last time, I have another question! I series of numbers that I need to synchronize with a chart, meaning I will have a master column with a series of several hundred serial numbers, and the incoming information will be four columns, one of which are the same serial...

That helps a lot. Thanks for the help!