Previous Topic Next Topic

Macros for formatting a data dump

Closed
mch24 Posts 2 Registration date Thursday 30 May 2013 Status Member Last seen 31 May 2013 - 30 May 2013 à 08:32
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 3 Jun 2013 à 11:03
Hi All,

I am new to macros and was looking if some 1 could help in coding a macros for formatting of the data. Below are the issues/Steps

1. The data input would be manual from an application
2. The data relates to aged creditors balance for each vendors that needs to be put together.
3. In the input file the Supplier code is in cell A3, Supplier name is on cell B3 but the vendor balance is in cell F6
4. The expected output file from the macros would be to put Supplier code in column A, Supplier name in column B and the Supplier balance in Column B.

Hope I have been clear. If not please let me know. Thanks to you all in advance.

3 responses

Réponse 1 / 3
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
30 May 2013 à 11:01
Hi Mch24,

I don't think I understand you because it looks to me that you want to move column F to column C ("Supplier balance in Column B" is a typo, right?).

Do you maybe mean that all the supplier codes are in A3? If so, then how are they sperated?

Please shine some light on the confusion.

Best regards,
Trowa
Réponse 2 / 3
mch24 Posts 2 Registration date Thursday 30 May 2013 Status Member Last seen 31 May 2013
31 May 2013 à 04:44
Hi Trowa,

Thanks for your reply.

The expected out put would be to put the supplier code in one column, Supplier name to the next column of supplier code and the supplier balance in the next column of supplier name.

In the input file all these are in cell A3, B3 and F6 for Supplier Code, Supplier name and Supplier balance respectively.

Appreciate your help.

Thanks,
Réponse 3 / 3
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
3 Jun 2013 à 11:03
Hi Mch24

If all the supplier codes are in A3, then how are they separated?
Is it with a space or comma or ....?

You can then use the Text to Columns option to separate your data (probably best to use a separate sheet for that).

Then transpose the row of data to column.

Best regards,
Trowa