Skip, just for the record, I agree with everything you've said, in fact, you have mentioned this to me before.
However, I was helping someone else and I was not going to change their data.
Thanks again !
Yuri - your solution seems like it may what, but I am not understanding your second sentence of how to apply the new column count to 500.
Please advise - thanks
I have a spreadsheet with data in each row (as an example) from row 1 through row 500 and I want to add a blank row between each of the 500 existing rows.
Is there an easy way to complete this task without having to use VBA?
Thanks
Skip - your timely and accurate response to my issues allow me and others to have a peaceful day.
I truly appreciate your help !
Multiple STARS are coming your way.
Again, thanks
WEC43WEC
Andy the string of text is not aligned by column heading which is why I need to find a why to pull the text with the only common factors being the forward slash and the zip code.
Please help !
Thanks
Sample Data =
Zip Code Address Directional Donation / Land Income
123456789 123 Main Street South 100 / Bus. 10,000
987654321 12345 Oak Bar Ave Northside 10000 / Resd. 100,000
I have a PDF file of over 10,000 rows with a string of data as listed in...
In Power Point, how would you go about establishing an icon or link on a ppt slide where I can click an icon or link to go to an excel or MS Word file and then return back to the same ppt slide.
I want to do a presentation where I want to reference data in other applications and be able to...
Skip - great suggestion which I will most likely use if I can not find another option. This would require more work on my part becuase I would need to change the column setting and cells within my spreadsheet, But this would only be a one time task becuase from that point forward the spreadsheet...
Thanks Macropod, but can you give me an example using the time and date indicated above.
All of the text in my report (spreadsheet) is set at a 12 font.
I want the Date "only" to be a 10 font and if possible i want the color of the DATE ONLY to be blue.
Agian, thanks for the help and the...
i currently have a cell that is formatted as time and date as follows:
[$-4409]h:mm AM/PM - mmm dd;@
example >>> 2:30 PM - Sept 08
What I would like to do is to only change the font size of the date "Sept 8" but NOT the time.
Also, is it possible to change the color of the...
Skip – I truly apologize for the confusion on my part for not making my request clear.
If I can, please let me clarify a few items as follows:
Quote:
Wec43 - The rows are all "grouped/sorted" by "STATE name
Skip - "WHERE is the STATE name???
Correction - the first column of the database...
Below is a brief sasmple of a data base that has over 5,000 rows but the same 10 columns. I only
show 20 rows of data but the data base goes to row 5,000.
The rows are all "grouped/sorted" by "STATE name" but different data for each of the other 9 columns. The numbber of rows may vary.
I want...
I have a data base that containes 10 columns with over 5,000 rows.
The data base has aready been sorted (when I get it) by column # 1 which has the same 10 different names in column # 1.
What I am trying to do is to test data in column # 8 (i am looking for the MAX number for each of the 10...
Using Excel.
In column a, I have a number on every 10th row(i.e. 10 in cell A10, 20 in cell A20, 30 in cell A30, etc).
I want to have a formula in cell B25 that says look in column A and give me or insert the first number I get to when I look at the cells above the current (formula) row...
Combo - thanks for your reply, however your solution does not resolve the problem.
The issue (I think) is not when I "draw a line" in PPT, the issue is when I copy data from Excel to PPT. The lines within the excel data that contains grid/border for each cell end with an arrow or point at the...
I am experiencing a problem when I paste data from excel to Power Point.
Data I have borders around each cell with data on / in each row and column.
Issue The lines ending on each row (on the right hand side) end with an “arrow head instead of a straight line (like this “?”).
The same issue...
How do you control the font size in the Data / Validation / "List" dropdown box in Excel without changing the "zoom" percent from the menu bar and without using VBA?
Note: I do not want to change the cell font size, just the display of text font size from the dropdown box.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.