Author Topic: Microsoft Excel Experts?  (Read 384 times)

0 Members and 2 Guests are viewing this topic.

Offline swinks

  • Trade Count: (+18)
  • ******
  • High Score Initials:
  • Forum Posts:
  • Lake Macquarie, NSW
Re: Microsoft Excel Experts?
« on: August 10, 2011, 06:15:49 AM »
Hi there, if it is a formula it is a little more tricky but still possible, if it is purely information it is relatively easy and if it database related I am not experienced in it myself so do not know how my advice would impact you, sorry.

Before you start, I would "save as" spreadsheet A n B as another name so you keep your original and can modify the second keeping the stress levels down if things go pear shaped.

To transfer the information to spreadsheet A n B, prepare the column that want to dump it into if it is in-between. Then go to spreadsheet B n C and simply select all the cells you want to copy over and hit copy. Go back to spreadsheet A n B and select the top left cell to paste your column C info in and it will dump the info in. Remember you may have some variables in spacing so some copy and pasting may be needed.

If there are formulas I have just re-written the first line and then copied to all lines below.

Hope that helps or even on the right track.

PM me if you like me to have a look if the info is not to case sensitive. Or post a few screen shots of a dummie scanario to show what you are trying to do.
https://swinks.com.au

for pinball parts (reproduction & mods)
for pinball t-shirts